Created
February 23, 2015 14:53
-
-
Save janewang/d55db5f319ee5abd1128 to your computer and use it in GitHub Desktop.
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
>> MySQLTuner 1.4.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 | |
[--] Performing tests on aa1b6ongzhnykri.ckeugrtmtumo.us-west-2.rds.amazonaws.com:3306 | |
[OK] Logged in using credentials passed on the command line | |
[--] Assuming 15000 MB of physical memory | |
[!!] Assuming 0 MB of swap space (use --forceswap to specify) | |
[OK] Currently running supported MySQL version 5.6.21-log | |
-------- Storage Engine Statistics ------------------------------------------- | |
[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM | |
[--] Data in InnoDB tables: 95M (Tables: 29) | |
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 52) | |
[!!] Total fragmented tables: 9 | |
-------- Security Recommendations ------------------------------------------- | |
[OK] All database users have passwords assigned | |
-------- Performance Metrics ------------------------------------------------- | |
[--] Up for: 19d 17h 58m 22s (274M q [161.067 qps], 3M conn, TX: 2209B, RX: 31B) | |
[--] Reads / Writes: 99% / 1% | |
[--] Total buffers: 11.1G global + 1.5M per thread (1232 max threads) | |
[!!] Maximum possible memory usage: 12.9G (88% of installed RAM) | |
[OK] Slow queries: 0% (59K/274M) | |
[OK] Highest usage of available connections: 14% (174/1232) | |
[OK] Key buffer size / total MyISAM indexes: 16.0M/2.4M | |
[OK] Key buffer hit rate: 100.0% (5M cached / 502 reads) | |
[OK] Query cache efficiency: 45.2% (116M cached / 257M selects) | |
[OK] Query cache prunes per day: 0 | |
[OK] Sorts requiring temporary tables: 0% (121 temp sorts / 7M sorts) | |
[!!] Temporary tables created on disk: 43% (2M on disk / 6M total) | |
[OK] Thread cache hit rate: 99% (1K created / 3M connections) | |
[!!] Table cache hit rate: 1% (1K open / 126K opened) | |
[OK] Open file limit used: 0% (127/65K) | |
[OK] Table locks acquired immediately: 99% (146M immediate / 146M locks) | |
[OK] InnoDB buffer pool / data size: 10.8G/95.8M | |
[OK] InnoDB log waits: 0 | |
-------- Recommendations ----------------------------------------------------- | |
General recommendations: | |
Run OPTIMIZE TABLE to defragment tables for better performance | |
Reduce your overall MySQL memory footprint for system stability | |
When making adjustments, make tmp_table_size/max_heap_table_size equal | |
Reduce your SELECT DISTINCT queries without LIMIT clauses | |
Increase table_open_cache gradually to avoid file descriptor limits | |
Read this before increasing table_open_cache over 64: http://bit.ly/1mi7c4C | |
Variables to adjust: | |
tmp_table_size (> 16M) | |
max_heap_table_size (> 16M) | |
table_open_cache (> 2000) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment