mysql常用show status查询状态

show variables like 'max_connections'; 

show global status like 'max_used_connections';  

show global status like 'created_tmp%';  

show variables where Variable_name in ('tmp_table_size', 'max_heap_table_size');

show global status like 'open%tables%';  

show global status like 'Thread%';

show variables like 'thread_cache_size'; 

show global status like 'qcache%';  

show variables like 'query_cache%';  

show global status like 'sort%';  

show global status like 'open_files';  

show global status like 'table_locks%';  

show table status like ‘user'\G