Home

DB Tuning

Thread Cache Monitor
Threads CreatedConnectionsThread Cache SizeHit RatioWarnings
7832492860%The ideal situation is to get Threads Created as close as possible to Thread Cache Size. So no new connections are having to wait for new thread allocation. Stay as close to a 99% hit ratio as you can as this will reduce bottlenecks in your caching. Adjust your Thread Cache Size until this is achieved. You can set your Thread Cache Size on the fly by doing "SET GLOBAL thread_cache_size=N". Where N is the desired size of your Thread Cache. For additional information on the SET command please read SET Syntax

Table Cache Monitor
Table CacheOpen TablesOpened TablesWarnings
1024762836Your MySQL server has not been running long enough to make a quality assessment of the performance of your table cache. Put some traffic on there and come back soon!Uptime: 1047921

Query Cache Monitor
Query Cache Ratio0.09
Query Cache Inserts1477073
Query Cache Hits17118519
Query Cache Available?YES
Query Cache Size16777216
Query Cache TypeON
Query Cache Free Memory6724832
Query Cache Free Blocks1940If your Query Cache has a lot of free blocks in it. This can indicate fragmentation in your Query Cache. This can decrease performance and generally just be a waste of resoures. Fix this problem by issuing a 'FLUSH QUERY CACHE' command. Read more about query cache maintenance here.
Query Cache Prunes802565
Query Cache Limit1048576
Queries Not Cached345324

Memory Monitor
Minimum Memory Needed : 1418944504
This number is a calculation of the maximum amount of memory your mySQL instance will consume on your server . It is a sum of all the caches and buffers that would benefit by not using swap or not having to goto the HD. Having a number larger than your total available amount of memory will result in swapping.
Min_memory_needed = key_buffer + innodb_buffer_pool + innodb_log_buffer + innodb_additional_mem_pool + net_buffer + max_connections * (read_buffer + join_buffer + sort_buffer + myisam_sort_buffer + thread_stack + tmp_table_size + read_rnd_buffer)
Key Buffer : 16777216
InnoDB Buffer Pool : 8388608
InnoDB Log Buffer : 1048576
InnoDB Additional Memory Pool : 1048576
Net Buffer : 16384
Max Connections : 50
Read Buffer : 1044480
Join Buffer : 1044480
Sort Buffer : 2097144
Myisam Sort Buffer : 33554432
Thread Stack : 196608
Tmp Table Size : 16777216
Read Rnd Buffer Size : 262144

Select Monitor
Variable NameCurrent ValueWarnings
Select_full_join14146A high value here means that MySQL is not using indexes and is therefore taking longer to build a result set. The problem can be fixed by indexing important fields of the join.Enable the Slow Query Log and use Explain to examine your queries.
Select_scan69479A high value here can be an indication of bottlenecks in your server optimization. This happens because Mysql is not using the indexes for the tables and so is having to do extra work for inefficient queries. Enable the Slow Query Log and use Explain to examine your queries.
  • 290 reads

Syndicate

Syndicate content