mysql
SHOW GLOBAL VARIABLES WHERE Variable_name='max_connections';
SET GLOBAL max_connections=10000;
SHOW GLOBAL STATUS LIKE '%connections%';
SHOW STATUS LIKE 'Thread_%';
show variables like 'thread_cache_size';
Set global thread_cache_size = 64;
flush privileges;
show processlist;
show variables like 'key_buffer_size';
Set global key_buffer_size = 512*1024*1024;
SHOW GLOBAL VARIABLES WHERE Variable_name='max_connections';
SET GLOBAL max_connections=10000;
SHOW GLOBAL STATUS LIKE '%connections%';
SHOW STATUS LIKE 'Thread_%';
show variables like 'thread_cache_size';
Set global thread_cache_size = 64;
flush privileges;
show processlist;
show variables like 'key_buffer_size';
Set global key_buffer_size = 512*1024*1024;