From 4f873f73c5b7a5af020cd71a0062c438771f98e7 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期四, 20 三月 2025 18:02:06 +0800
Subject: [PATCH] zjh20250320
---
ltkj-admin/src/main/resources/sql/index.sql | 15 +++++++++++++++
1 files changed, 15 insertions(+), 0 deletions(-)
diff --git a/ltkj-admin/src/main/resources/sql/index.sql b/ltkj-admin/src/main/resources/sql/index.sql
index d2f9fac..04eaf6b 100644
--- a/ltkj-admin/src/main/resources/sql/index.sql
+++ b/ltkj-admin/src/main/resources/sql/index.sql
@@ -2,3 +2,18 @@
UPDATE ltkjpeisTest.tj_project a
JOIN ltkjpeisTest.tj_project_beifen b ON b.pro_id = a.pro_id
SET a.pro_default = b.pro_default,a.pro_scope = b.pro_scope,a.result_type = b.result_type;
+
+
+
+# 鏌ョ湅鏁版嵁搴撳崰鐢ㄥ唴瀛樺ぇ灏�
+SELECT table_schema AS 'Database',
+ SUM(data_length + index_length) / 1024 / 1024 AS 'Size (MB)'
+FROM information_schema.tables
+WHERE table_schema = 'ltkjpeis10'
+GROUP BY table_schema;
+
+# 鏌ョ湅璁剧疆涓璁剧殑鏁版嵁搴撳唴瀛樺ぇ灏�
+SHOW VARIABLES LIKE 'innodb_buffer_pool_size';
+
+# 鏌ョ湅鏈�澶х殑杩炴帴鏁�
+SHOW VARIABLES LIKE 'max_connections';
--
Gitblit v1.8.0