Created
January 10, 2015 16:33
-
-
Save ashtonwebster/cbfd98ee1799a7f6b323 to your computer and use it in GitHub Desktop.
mysql tuner output
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-------- Storage Engine Statistics ------------------------------------------- | |
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster | |
[--] Data in InnoDB tables: 610G (Tables: 10) | |
[--] Data in MyISAM tables: 1K (Tables: 12) | |
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17) | |
[!!] Total fragmented tables: 10 | |
-------- Security Recommendations ------------------------------------------- | |
[OK] All database users have passwords assigned | |
-------- Performance Metrics ------------------------------------------------- | |
[--] Up for: 2m 6s (163 q [1.294 qps], 55 conn, TX: 30K, RX: 10K) | |
[--] Reads / Writes: 100% / 0% | |
[--] Total buffers: 55.1G global + 2.7M per thread (151 max threads) | |
[!!] Maximum possible memory usage: 55.5G (88% of installed RAM) | |
[OK] Slow queries: 0% (0/163) | |
[OK] Highest usage of available connections: 0% (1/151) | |
[OK] Key buffer size / total MyISAM indexes: 16.0M/136.0K | |
[!!] Query cache efficiency: 0.0% (0 cached / 96 selects) | |
[OK] Query cache prunes per day: 0 | |
[OK] Temporary tables created on disk: 20% (54 on disk / 269 total) | |
[OK] Thread cache hit rate: 98% (1 created / 55 connections) | |
[OK] Table cache hit rate: 24% (63 open / 259 opened) | |
[OK] Open file limit used: 7% (73/1K) | |
[OK] Table locks acquired immediately: 100% (74 immediate / 74 locks) | |
[!!] InnoDB data size / buffer pool: 610.9G/55.0G | |
-------- Recommendations ----------------------------------------------------- | |
General recommendations: | |
Run OPTIMIZE TABLE to defragment tables for better performance | |
MySQL started within last 24 hours - recommendations may be inaccurate | |
Reduce your overall MySQL memory footprint for system stability | |
Variables to adjust: | |
query_cache_limit (> 1M, or use smaller result sets) | |
innodb_buffer_pool_size (>= 610G) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment