mysql占用高内存排查与解决

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'