mysql

set GLOBAL max_connections=3000;
set GLOBAL table_open_cache=3000;
set GLOBAL mysqlx_max_connections=3000;
set GLOBAL tmp_table_size=333554432;

show variables like 'log_queries_not_using_indexes';
show variables like '%max_connections%';
show variables like '%tmp_table_size%';
show variables like '%max_heap_table_size%';
show variables like '%open_files_limit%';
show global status like 'open%_tables';
flush tables;

原文地址:https://www.cnblogs.com/light-zhang/p/13612371.html