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;

上一篇:mysql05-慢查询


下一篇:[vue-element-admin]-更改主题颜色