database:mysql:conf
調用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)'
參考資料
database/mysql/conf.txt · 上一次變更: 2013/07/06 01:28 (外部編輯)