-
-
Save tloudon/e663bdf3a9b287b8d341 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
| [[0;32mOK[0m] Logged in using credentials from debian maintenance account. | |
| >> MySQLTuner 1.5.0 - Major Hayden <[email protected]> | |
| >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ | |
| >> Run with '--help' for additional options and output filtering | |
| [[0;32mOK[0m] Currently running supported MySQL version 5.5.44-MariaDB-1ubuntu0.14.04.1 | |
| [[0;32mOK[0m] Operating on 64-bit architecture | |
| -------- Storage Engine Statistics ------------------------------------------- | |
| [[0;34m--[0m] Status: [0;32m+ARCHIVE [0m[0;32m+Aria [0m[0;32m+BLACKHOLE [0m[0;32m+CSV [0m[0;32m+FEDERATED [0m[0;32m+InnoDB [0m[0;32m+MRG_MYISAM [0m[0;32m+SPHINX [0m | |
| [[0;34m--[0m] Data in MEMORY tables: 125K (Tables: 1) | |
| [[0;34m--[0m] Data in InnoDB tables: 1G (Tables: 3809) | |
| [[0;31m!![0m] Total fragmented tables: 3809 | |
| -------- Security Recommendations ------------------------------------------- | |
| [[0;32mOK[0m] There is no anonymous account in all database users | |
| [[0;32mOK[0m] All database users have passwords assigned | |
| [[0;31m!![0m] There is not basic password file list ! | |
| -------- Performance Metrics ------------------------------------------------- | |
| [[0;34m--[0m] Up for: 5h 34m 30s (30K q [1.525 qps], 112 conn, TX: 107M, RX: 55M) | |
| [[0;34m--[0m] Reads / Writes: 88% / 12% | |
| [[0;34m--[0m] Binary logging is disabled | |
| [[0;34m--[0m] Total buffers: 192.0M global + 2.7M per thread (151 max threads) | |
| [[0;32mOK[0m] Maximum reached memory usage: 200.1M (5.06% of installed RAM) | |
| [[0;32mOK[0m] Maximum possible memory usage: 597.8M (15.12% of installed RAM) | |
| [[0;32mOK[0m] Slow queries: 0% (0/30K) | |
| [[0;32mOK[0m] Highest usage of available connections: 1% (3/151) | |
| [[0;32mOK[0m] Aborted connections: 2.68% (3/112) | |
| [[0;31m!![0m] Key buffer used: 18.2% (3M used / 16M cache) | |
| [[0;32mOK[0m] Key buffer size / total MyISAM indexes: 16.0M/99.0K | |
| [[0;31m!![0m] Read Key buffer hit rate: 80.0% (5 cached / 1 reads) | |
| [[0;32mOK[0m] Query cache efficiency: 43.9% (21K cached / 47K selects) | |
| [[0;32mOK[0m] Query cache prunes per day: 0 | |
| [[0;32mOK[0m] Sorts requiring temporary tables: 0% (0 temp sorts / 127 sorts) | |
| [[0;31m!![0m] Joins performed without indexes: 80 | |
| [[0;32mOK[0m] Temporary tables created on disk: 6% (17 on disk / 267 total) | |
| [[0;32mOK[0m] Thread cache hit rate: 97% (3 created / 112 connections) | |
| [[0;31m!![0m] Table cache hit rate: 1% (400 open / 24K opened) | |
| [[0;32mOK[0m] Open file limit used: 0% (3/1K) | |
| [[0;32mOK[0m] Table locks acquired immediately: 100% (10K immediate / 10K locks) | |
| -------- InnoDB Metrics ----------------------------------------------------- | |
| [[0;34m--[0m] InnoDB is enabled. | |
| [[0;31m!![0m] InnoDB buffer pool / data size: 128.0M/1.3G | |
| [[0;32mOK[0m] InnoDB buffer pool instances: 1 | |
| [[0;32mOK[0m] InnoDB Used buffer: 100.00% (8191 used/ 8191 total) | |
| [[0;32mOK[0m] InnoDB Read buffer efficiency: 91.77% (2760535 hits/ 3008075 total) | |
| [[0;31m!![0m] InnoDB Write buffer efficiency: 0.00% (0 hits/ 1 total) | |
| [[0;32mOK[0m] InnoDB log waits: 0.00% (0 waits / 194 writes) | |
| -------- Replication Metrics ------------------------------------------------- | |
| [[0;34m--[0m] No replication slave(s) for this server. | |
| [[0;34m--[0m] This is a standalone server.. | |
| -------- 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 | |
| Adjust your join queries to always utilize indexes | |
| 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: | |
| join_buffer_size (> 128.0K, or always use indexes with joins) | |
| table_open_cache (> 400) | |
| innodb_buffer_pool_size (>= 1G) if possible. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment