使用者工具

網站工具


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 (外部編輯)