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
