Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -------- Storage Engine Statistics -------------------------------------------
- [--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
- [--] Data in MyISAM tables: 182M (Tables: 79)
- [--] Data in InnoDB tables: 1M (Tables: 77)
- [!!] Total fragmented tables: 77
- -------- Security Recommendations -------------------------------------------
- [!!] User 'root@127.0.0.1' has no password set.
- [!!] User 'root@localhost' has no password set.
- [!!] User 'root@skwp-mbp.local' has no password set.
- -------- Performance Metrics -------------------------------------------------
- [--] Up for: 1h 35m 22s (1K q [0.319 qps], 12 conn, TX: 110K, RX: 458M)
- [--] Reads / Writes: 7% / 93%
- [--] Total buffers: 26.0M global + 832.0K per thread (151 max threads)
- [OK] Maximum possible memory usage: 148.7M (0% of installed RAM)
- [OK] Slow queries: 0% (0/1K)
- [OK] Highest usage of available connections: 0% (1/151)
- [OK] Key buffer size / total MyISAM indexes: 16.0K/28.0M
- [OK] Key buffer hit rate: 98.4% (2M cached / 34K reads)
- [!!] Query cache is disabled
- [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 1 sorts)
- [OK] Temporary tables created on disk: 21% (3 on disk / 14 total)
- [!!] Thread cache is disabled
- [!!] Table cache hit rate: 0% (1 open / 418 opened)
- [OK] Open file limit used: 0% (2/755)
- [OK] Table locks acquired immediately: 100% (245 immediate / 245 locks)
- [!!] Connections aborted: 8%
- [OK] InnoDB data size / buffer pool: 1.2M/8.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
- Set thread_cache_size to 4 as a starting value
- Increase table_cache gradually to avoid file descriptor limits
- Your applications are not closing MySQL connections properly
- Variables to adjust:
- query_cache_size (>= 8M)
- thread_cache_size (start at 4)
- table_cache (> 4)
Add Comment
Please, Sign In to add comment