Global status – table open cache

show global status like 'Table_open_cache%' shows output like: # Variable_name, Value Table_open_cache_hits, 749919 Table_open_cache_misses, 83398 Table_open_cache_overflows, 81276   If “Table_open_cache_overflows” is too high you must check...

Global status – tmp tables

show global status like '%tmp%' will show output like: # Variable_name, Value Created_tmp_disk_tables, 5939 Created_tmp_files, 6 Created_tmp_tables, 97525 If “Created_tmp_disk_tables” is too high it means system tmp tables do not fit into memory and MySQL...