mysql监测工具tuning-primer.sh(二)
_cache_min_res_unit = 4 K
Your query_cache_size seems to be too high.
Perhaps you can use these resources elsewhere
MySQL won't cache query results that are larger than query_cache_limit in size
SORT OPERATIONS --排序情况
Current sort_buffer_size = 256 K
Current read_rnd_buffer_size = 256 K
No sort operations have been performed
Sort buffer seems to be fine
JOINS --连接情况
Current join_buffer_size = 260.00 K
You have had 0 queries where a join could not use an index properly
Your joins seem to be using indexes properly
OPEN FILES LIMIT --最大打开文件情况
Current open_files_limit = 5000 files
The open_files_limit should typically be set to at least 2x-3x
that of table_cache if you have heavy MyISAM usage.
Your open_files_limit value seems to be fine
TABLE CACHE --表缓存使用情况
Current table_open_cache = 2000 tables
Current table_definition_cache = 1400 tables
You have a total of 80 tables
You have 80 open tables.
The table_cache value seems to be fine
TEMP TABLES -- 临时表使用情况
Current max_heap_table_size = 16 M
Current tmp_table_size = 16 M
Of 337 temp tables, 10% were created on disk
Created disk tmp tables ratio seems fine
TABLE SCANS -- 表扫描情况
Current read_buffer_size = 128 K
Current table scan ratio = 6 : 1
read_buffer_size seems to be fine
TABLE LOCKING --表锁定情况
Current Lock Wait ratio = 0 : 326
Your table locking seems to be fine