Guest User

Untitled

a guest
Jul 22nd, 2018
149
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.99 KB | None | 0 0
  1. -------- Storage Engine Statistics -------------------------------------------
  2. [--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
  3. [--] Data in MyISAM tables: 182M (Tables: 79)
  4. [--] Data in InnoDB tables: 1M (Tables: 77)
  5. [!!] Total fragmented tables: 77
  6.  
  7. -------- Security Recommendations -------------------------------------------
  8. [!!] User 'root@127.0.0.1' has no password set.
  9. [!!] User 'root@localhost' has no password set.
  10. [!!] User 'root@skwp-mbp.local' has no password set.
  11.  
  12. -------- Performance Metrics -------------------------------------------------
  13. [--] Up for: 1h 35m 22s (1K q [0.319 qps], 12 conn, TX: 110K, RX: 458M)
  14. [--] Reads / Writes: 7% / 93%
  15. [--] Total buffers: 26.0M global + 832.0K per thread (151 max threads)
  16. [OK] Maximum possible memory usage: 148.7M (0% of installed RAM)
  17. [OK] Slow queries: 0% (0/1K)
  18. [OK] Highest usage of available connections: 0% (1/151)
  19. [OK] Key buffer size / total MyISAM indexes: 16.0K/28.0M
  20. [OK] Key buffer hit rate: 98.4% (2M cached / 34K reads)
  21. [!!] Query cache is disabled
  22. [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 1 sorts)
  23. [OK] Temporary tables created on disk: 21% (3 on disk / 14 total)
  24. [!!] Thread cache is disabled
  25. [!!] Table cache hit rate: 0% (1 open / 418 opened)
  26. [OK] Open file limit used: 0% (2/755)
  27. [OK] Table locks acquired immediately: 100% (245 immediate / 245 locks)
  28. [!!] Connections aborted: 8%
  29. [OK] InnoDB data size / buffer pool: 1.2M/8.0M
  30.  
  31. -------- Recommendations -----------------------------------------------------
  32. General recommendations:
  33. Run OPTIMIZE TABLE to defragment tables for better performance
  34. MySQL started within last 24 hours - recommendations may be inaccurate
  35. Enable the slow query log to troubleshoot bad queries
  36. Set thread_cache_size to 4 as a starting value
  37. Increase table_cache gradually to avoid file descriptor limits
  38. Your applications are not closing MySQL connections properly
  39. Variables to adjust:
  40. query_cache_size (>= 8M)
  41. thread_cache_size (start at 4)
  42. table_cache (> 4)
Add Comment
Please, Sign In to add comment