API tools faq
paste
Advertisement
Guest User

mysqltuner-output

a guest
Oct 2nd, 2014
231
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.05 KB | None | 0 0
raw download clone embed print report
  1. >> MySQLTuner 1.3.0 - Major Hayden <major@mhtx.net>
  2. >> Bug reports, feature requests, and downloads at http://mysqltuner.com/
  3. >> Run with '--help' for additional options and output filtering
  4. [!!] Successfully authenticated with no password - SECURITY RISK!
  5. [OK] Currently running supported MySQL version 5.6.19-log
  6. [OK] Operating on 64-bit architecture
  7.  
  8. -------- Storage Engine Statistics -------------------------------------------
  9. [--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM
  10. [--] Data in InnoDB tables: 338M (Tables: 199)
  11. [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 52)
  12. [!!] Total fragmented tables: 11
  13.  
  14. -------- Performance Metrics -------------------------------------------------
  15. [--] Up for: 5s (13 q [2.600 qps], 9 conn, TX: 15K, RX: 1K)
  16. [--] Reads / Writes: 100% / 0%
  17. [--] Total buffers: 1.1G global + 24.6M per thread (10000 max threads)
  18. [!!] Maximum possible memory usage: 241.6G (771% of installed RAM)
  19. [OK] Slow queries: 0% (0/13)
  20. [OK] Highest usage of available connections: 0% (1/10000)
  21. [OK] Key buffer size / total MyISAM indexes: 512.0M/94.0K
  22. [!!] Query cache efficiency: 0.0% (0 cached / 5 selects)
  23. [OK] Query cache prunes per day: 0
  24. [OK] Temporary tables created on disk: 0% (0 on disk / 3 total)
  25. [OK] Thread cache hit rate: 88% (1 created / 9 connections)
  26. [OK] Table cache hit rate: 90% (63 open / 70 opened)
  27. [OK] Open file limit used: 0% (20/50K)
  28. [OK] Table locks acquired immediately: 100% (87 immediate / 87 locks)
  29. [OK] InnoDB buffer pool / data size: 512.0M/339.0M
  30. [OK] InnoDB log waits: 0
  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. Reduce your overall MySQL memory footprint for system stability
  36. Variables to adjust:
  37. *** MySQL's maximum memory usage is dangerously high ***
  38. *** Add RAM before increasing MySQL buffer variables ***
  39. query_cache_limit (> 1M, or use smaller result sets)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!