阿里BaBa電腦筆記

本頁是唯讀的，您可以看到原始碼，但不能更動它。您如果覺得它不應被鎖上，請詢問管理員。

======調用mysql參數工具======
  * show演示<code mysql>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 | 
+---------------+---------+
</code>
  * mysqladmin演示<code bash>#mysqladmin variables
#mysqladmin variables extended-status
#mysqladmin variables extended-status|grep -i -E '(table_cache|open_tables|opened_tables)'
</code>
======參考資料======
  - [[http://database.51cto.com/art/201005/201257.htm|51cto_MySQL配置參數 my.ini/my.cnf的詳細解析]]
  - [[http://database.51cto.com/art/201005/201236.htm|51cto_對MySQL性能影響關係緊密的五大配置參數]]

阿里BaBa電腦筆記

使用者工具

網站工具

頁面工具