Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- >> MySQLTuner 1.2.0 - Major Hayden <major@mhtx.net>
- >> Bug reports, feature requests, and downloads at http://mysqltuner.com/
- >> Run with '--help' for additional options and output filtering
- -------- General Statistics --------------------------------------------------
- [[0;34m--[0m] Skipped version check for MySQLTuner script
- [[0;32mOK[0m] Currently running supported MySQL version 5.5.30-cll
- [[0;32mOK[0m] Operating on 64-bit architecture
- -------- Storage Engine Statistics -------------------------------------------
- [[0;34m--[0m] Status: [0;32m+Archive [0m[0;31m-BDB [0m[0;31m-Federated [0m[0;32m+InnoDB [0m[0;31m-ISAM [0m[0;31m-NDBCluster [0m
- [[0;34m--[0m] Data in MyISAM tables: 281M (Tables: 111)
- [[0;34m--[0m] Data in InnoDB tables: 208K (Tables: 13)
- [[0;34m--[0m] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
- [[0;31m!![0m] Total fragmented tables: 15
- -------- Security Recommendations -------------------------------------------
- [[0;32mOK[0m] All database users have passwords assigned
- -------- Performance Metrics -------------------------------------------------
- [[0;34m--[0m] Up for: 6m 25s (178K q [462.636 qps], 14K conn, TX: 67M, RX: 28M)
- [[0;34m--[0m] Reads / Writes: 62% / 38%
- [[0;34m--[0m] Total buffers: 168.0M global + 2.8M per thread (500 max threads)
- [[0;32mOK[0m] Maximum possible memory usage: 1.5G (4% of installed RAM)
- [[0;32mOK[0m] Slow queries: 0% (0/178K)
- [[0;31m!![0m] Highest connection usage: 100% (501/500)
- [[0;31m!![0m] Key buffer size / total MyISAM indexes: 8.0M/225.7M
- [[0;31m!![0m] Key buffer hit rate: 94.6% (62M cached / 3M reads)
- [[0;31m!![0m] Query cache is disabled
- [[0;32mOK[0m] Sorts requiring temporary tables: 0% (0 temp sorts / 20K sorts)
- [[0;31m!![0m] Temporary tables created on disk: 37% (6K on disk / 17K total)
- [[0;31m!![0m] Thread cache is disabled
- [[0;31m!![0m] Table cache hit rate: 0% (400 open / 82K opened)
- [[0;32mOK[0m] Open file limit used: 16% (417/2K)
- [[0;31m!![0m] Table locks acquired immediately: 82%
- [[0;32mOK[0m] InnoDB data size / buffer pool: 208.0K/128.0M
- -------- Recommendations -----------------------------------------------------
- General recommendations:
- Run OPTIMIZE TABLE to defragment tables for better performance
- MySQL started within last 24 hours - recommendations may be inaccurate
- Reduce or eliminate persistent connections to reduce connection usage
- When making adjustments, make tmp_table_size/max_heap_table_size equal
- Reduce your SELECT DISTINCT queries without LIMIT clauses
- Set thread_cache_size to 4 as a starting value
- Increase table_cache gradually to avoid file descriptor limits
- Optimize queries and/or use InnoDB to reduce lock wait
- Variables to adjust:
- max_connections (> 500)
- wait_timeout (< 28800)
- interactive_timeout (< 28800)
- key_buffer_size (> 225.7M)
- query_cache_size (>= 8M)
- tmp_table_size (> 16M)
- max_heap_table_size (> 16M)
- thread_cache_size (start at 4)
- table_cache (> 400)
Advertisement
Add Comment
Please, Sign In to add comment