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;

posted @ 2020-09-04 10:26  light-zhang  阅读(109)  评论(0编辑  收藏  举报