Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -------- General Statistics --------------------------------------------------
- [--] Skipped version check for MySQLTuner script
- [OK] Currently running supported MySQL version 5.5.35-0ubuntu0.12.04.2
- [OK] Operating on 64-bit architecture
- -------- Storage Engine Statistics -------------------------------------------
- [--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
- [--] Data in MyISAM tables: 19M (Tables: 98)
- [--] Data in InnoDB tables: 226M (Tables: 148)
- [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
- [!!] Total fragmented tables: 152
- -------- Performance Metrics -------------------------------------------------
- [--] Up for: 13m 27s (68K q [84.686 qps], 2K conn, TX: 519M, RX: 69M)
- [--] Reads / Writes: 96% / 4%
- [--] Total buffers: 190.0M global + 2.7M per thread (40 max threads)
- [OK] Maximum possible memory usage: 297.5M (8% of installed RAM)
- [OK] Slow queries: 0% (0/68K)
- [!!] Highest connection usage: 95% (38/40)
- [OK] Key buffer size / total MyISAM indexes: 14.0M/2.4M
- [OK] Key buffer hit rate: 98.7% (36K cached / 457 reads)
- [OK] Query cache efficiency: 91.9% (55K cached / 60K selects)
- [OK] Query cache prunes per day: 0
- [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 280 sorts)
- [!!] Joins performed without indexes: 4
- [!!] Temporary tables created on disk: 31% (299 on disk / 958 total)
- [OK] Thread cache hit rate: 90% (197 created / 2K connections)
- [OK] Table cache hit rate: 26% (313 open / 1K opened)
- [OK] Open file limit used: 23% (245/1K)
- [OK] Table locks acquired immediately: 100% (3K immediate / 3K locks)
- [!!] InnoDB data size / buffer pool: 226.7M/128.0M
- -------- Recommendations -----------------------------------------------------
- General recommendations:
- 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
- Reduce or eliminate persistent connections to reduce connection usage
- Adjust your join queries to always utilize indexes
- When making adjustments, make tmp_table_size/max_heap_table_size equal
- Reduce your SELECT DISTINCT queries without LIMIT clauses
- Variables to adjust:
- max_connections (> 40)
- wait_timeout (< 180)
- interactive_timeout (< 180)
- join_buffer_size (> 128.0K, or always use indexes with joins)
- tmp_table_size (> 16M)
- max_heap_table_size (> 16M)
- innodb_buffer_pool_size (>= 226M)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement