monitoring tuner

$ sudo apt-get install mysqltuner -y

$ mysqltuner 

Please enter your MySQL administrative login: root

Please enter your MySQL administrative password: 

-------- General Statistics --------------------------------------------------

[--] Skipped version check for MySQLTuner script

[OK] Currently running supported MySQL version 5.1.66-0ubuntu0.10.04.1

[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------

[--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster 

[--] Data in MyISAM tables: 578K (Tables: 34)

[!!] InnoDB is enabled but isn't being used

[!!] Total fragmented tables: 2

-------- Performance Metrics -------------------------------------------------

[--] Up for: 23h 42m 11s (6K q [0.079 qps], 362 conn, TX: 332K, RX: 120K)

[--] Reads / Writes: 100% / 0%

[--] Total buffers: 58.0M global + 2.7M per thread (151 max threads)

[OK] Maximum possible memory usage: 463.8M (23% of installed RAM)

[OK] Slow queries: 0% (0/6K)

[OK] Highest usage of available connections: 1% (2/151)

[OK] Key buffer size / total MyISAM indexes: 16.0M/311.0K

[!!] Key buffer hit rate: 50.0% (4 cached / 2 reads)

[!!] Query cache efficiency: 0.0% (0 cached / 136 selects)

[OK] Query cache prunes per day: 0

[OK] Temporary tables created on disk: 24% (48 on disk / 200 total)

[OK] Thread cache hit rate: 99% (2 created / 362 connections)

[OK] Table cache hit rate: 24% (57 open / 235 opened)

[OK] Open file limit used: 11% (114/1K)

[OK] Table locks acquired immediately: 100% (76 immediate / 76 locks)

-------- Recommendations -----------------------------------------------------

General recommendations:

    Add skip-innodb to MySQL configuration to disable InnoDB

    Run OPTIMIZE TABLE to defragment tables for better performance

    MySQL started within last 24 hours - recommendations may be inaccurate

    Enable the slow query log to troubleshoot bad queries

Variables to adjust:

    query_cache_limit (> 1M, or use smaller result sets)

[출처] [MySQL] mysql tuner script (Mr.Mssql & Excel) |작성자 여리