======調用mysql參數工具====== * show演示mysql>show status; mysql>show status like 'Qcache%'; +-------------------------+-------+ | Variable_name | Value | +-------------------------+-------+ | Qcache_free_blocks | 0 | | Qcache_free_memory | 0 | | Qcache_hits | 0 | | Qcache_inserts | 0 | | Qcache_lowmem_prunes | 0 | | Qcache_not_cached | 0 | | Qcache_queries_in_cache | 0 | | Qcache_total_blocks | 0 | +-------------------------+-------+ mysql>show status like 'uptime'; +---------------+---------+ | Variable_name | Value | +---------------+---------+ | Uptime | 1703894 | +---------------+---------+ * mysqladmin演示#mysqladmin variables #mysqladmin variables extended-status #mysqladmin variables extended-status|grep -i -E '(table_cache|open_tables|opened_tables)' ======參考資料====== - [[http://database.51cto.com/art/201005/201257.htm|51cto_MySQL配置參數 my.ini/my.cnf的詳細解析]] - [[http://database.51cto.com/art/201005/201236.htm|51cto_對MySQL性能影響關係緊密的五大配置參數]]