Advertisement
roozgar

mysq tunner

Jun 15th, 2019
189
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.83 KB | None | 0 0
  1. Info MySQL Tuner 0.8.5 - Peter Chapman <peter@conglomo.co.nz>
  2. Info Performing tests on localhost:3306 at Saturday, 15 June 2019 11:17:04 a.m.
  3. Fail Successfully authenticated with no password - SECURITY RISK!
  4. Fail Currently running unsupported MySQL version 10.1.39-MariaDB
  5. Fail Archive Engine Not Installed
  6. Info Berkeley DB Engine Not Installed
  7. Fail Federated Engine Not Installed
  8. Pass InnoDB Engine Installed
  9. Fail ISAM Engine Not Installed
  10. Fail NDBCLUSTER Engine Not Installed
  11. Info Data in InnoDB tables: 169M (Tables: 64)
  12. Fail Total fragmented tables: 8
  13. Fail User '@localhost' has no password set.
  14. Fail User 'pma@localhost' has no password set.
  15. Fail User 'root@127.0.0.1' has no password set.
  16. Fail User 'root@::1' has no password set.
  17. Fail User 'root@localhost' has no password set.
  18. Fail User 'sat@%' has no password set.
  19. Info Up for: 2d 23h 38m 24s (11M q [44.000 qps], 2M conn, TX: 16G, RX: 4G)
  20. Info Reads / Writes: 76% / 24%
  21. Info Total buffers: 20.6G global + 30.5M per thread (5000 max threads)
  22. Fail Maximum possible memory usage: 169.7G (530% of installed RAM)
  23. Pass Slow queries: 0% (0/8M)
  24. Pass Highest usage of available connections: 19% (930/5000)
  25. Pass Key buffer size / total MyISAM indexes: 512.0M/138.0K
  26. Pass Sorts requiring temporary tables: 0% (0 temp sorts / 217 sorts)
  27. Pass Temporary tables created on disk: 7% (231 on disk / 3K total)
  28. Pass Thread cache hit rate: 99% (799 created / 1M connections)
  29. Pass Table cache hit rate: 59% (134 open / 225 opened)
  30. Pass Open file limit used: 0% (25/27K)
  31. Pass Table locks acquired immediately: 100% (3M immediate / 3M locks)
  32. Pass InnoDB data size / buffer pool: 169.7M/20.0G
  33. Recommendation Run OPTIMIZE TABLE to defragment tables for better performance
  34. Recommendation Reduce your overall MySQL memory footprint for system stability
  35. Info Scan Completed at Saturday, 15 June 2019 11:17:04 a.m.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement