MYSQL 5.6版本占用内存高
最近在检查系统的时候发现，MySQL经常性的占满了几乎所有空余内存，查了下网上的资料，发现需要调整MySQL的参数来降低内存占用。
找到 My.ini 配置文件，在后面添加如下参数 performance_schema 参数进行优化：
performance_schema_accounts_size =100 performance_schema_digests_size =5000 performance_schema_events_stages_history_long_size =1000 performance_schema_events_stages_history_size =10 performance_schema_events_statements_history_long_size =1000 performance_schema_events_statements_history_size =10 performance_schema_events_waits_history_long_size =1000 performance_schema_events_waits_history_size =10 performance_schema_hosts_size =100 performance_schema_max_cond_classes =80 performance_schema_max_cond_instances =1382 performance_schema_max_digest_length =1024 performance_schema_max_file_classes =50 performance_schema_max_file_handles =32768 performance_schema_max_file_instances =2557 performance_schema_max_mutex_classes =200 performance_schema_max_mutex_instances =5755 performance_schema_max_rwlock_classes =40 performance_schema_max_rwlock_instances =3138 performance_schema_max_socket_classes =10 performance_schema_max_socket_instances =230 performance_schema_max_stage_classes =150 performance_schema_max_statement_classes =168 performance_schema_max_table_handles =616 performance_schema_max_table_instances =684 performance_schema_max_thread_classes =50 performance_schema_max_thread_instances =288 performance_schema_session_connect_attrs_size =512 performance_schema_setup_actors_size =100 performance_schema_setup_objects_size =100 performance_schema_users_size =100
如果想停用 performance_schema ，可直接添加以下参数即可：
performance_schema = off
原文链接地址：https://blog.exsvc.cn/article/mysql-5-6-high-ram-usage.html
转载请注明：转载自 易科博客 ，谢谢！