mysql占用高內存排查
-- 查看當前全局內存使用情況（需要啟用 performance_schema）
SELECT * FROM sys.memory_global_total; -- 查看總內存使用
SELECT * FROM sys.memory_global_by_current_bytes LIMIT 10; -- 按模塊分類查看內存使用排行
memory/performance_schema/file_instances占用11G
更改配置，重啟mysql
[mysqld]
# 現有的配置保持不變
binlog_expire_logs_seconds = 86400
basedir = D:\mysql-8.0.31-winx64
datadir = D:\mysql-8.0.31-winx64\data
port = 3306
character-set-server = utf8
default-storage-engine = INNODB
sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
# 新增的Performance Schema內存限制配置
performance_schema_max_file_instances = 10000
performance_schema_max_table_instances = 10000
performance_schema_max_table_handles = 10000
performance_schema_max_mutex_instances = 10000
performance_schema_max_rwlock_instances = 10000
performance_schema_max_socket_instances = 10000
performance_schema_max_cond_instances = 10000
# 可選：如果您不需要文件IO監控，可以完全禁用相關instrument
performance_schema_instrument = 'wait/io/file/%=OFF'
