Content added Content deleted
imported>Hundfred (New page: == mysql performance tuning == '''query cache example''' <pre> mysql> show status like "%Qcache%"; +-------------------------+----------+ | Variable_name | Value | +---------...) |
imported>Hundfred No edit summary |
||
Line 2: | Line 2: | ||
'''query cache example''' |
'''query cache example''' |
||
<pre> |
<pre> |
||
mysql> show status like "%Qcache%"; |
mysql> show status like "%Qcache%"; |
||
Line 20: | Line 21: | ||
in the table '''variables''' is a opportunity to set some values: |
in the table '''variables''' is a opportunity to set some values: |
||
<pre> |
<pre> |
||
mysql> show variables like "%query_cache%"; |
mysql> show variables like "%query_cache%"; |
Latest revision as of 13:35, 23 June 2009
mysql performance tuning[edit]
query cache example
mysql> show status like "%Qcache%"; +-------------------------+----------+ | Variable_name | Value | +-------------------------+----------+ | Qcache_free_blocks | 1 | | Qcache_free_memory | 18481592 | | Qcache_hits | 82184 | | Qcache_inserts | 50875 | | Qcache_lowmem_prunes | 0 | #should be like 0 if not, chache size is too small | Qcache_not_cached | 28127 | | Qcache_queries_in_cache | 22048 | | Qcache_total_blocks | 44200 | +-------------------------+----------+ 8 rows in set (0.03 sec)
in the table variables is a opportunity to set some values:
mysql> show variables like "%query_cache%"; +------------------------------+----------+ | Variable_name | Value | +------------------------------+----------+ | have_query_cache | YES | | query_cache_limit | 1048576 | | query_cache_min_res_unit | 4096 | | query_cache_size | 41943040 | | query_cache_type | ON | | query_cache_wlock_invalidate | OFF | +------------------------------+----------+ 6 rows in set (0.00 sec)