Advertisement
roozgar

new mysq tunner

Jun 16th, 2019
150
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.68 KB | None | 0 0
  1. MySQL Tuner 0.8.5 - Peter Chapman <peter@conglomo.co.nz>
  2. Performing tests on localhost:3306 at Sunday, 16 June 2019 4:26:14 p.m.
  3. Successfully authenticated with no password - SECURITY RISK!
  4. Currently running unsupported MySQL version 10.1.39-MariaDB
  5. Archive Engine Not Installed
  6. Berkeley DB Engine Not Installed
  7. Federated Engine Not Installed
  8. InnoDB Engine Installed
  9. ISAM Engine Not Installed
  10. NDBCLUSTER Engine Not Installed
  11. Data in InnoDB tables: 2G (Tables: 64)
  12. Total fragmented tables: 8
  13. User '@localhost' has no password set.
  14. User 'pma@localhost' has no password set.
  15. User 'root@127.0.0.1' has no password set.
  16. User 'root@::1' has no password set.
  17. User 'root@localhost' has no password set.
  18. User 'sat@%' has no password set.
  19. Up for: 7h 9m 15s (4M q [164.000 qps], 658K conn, TX: 5G, RX: 1G)
  20. Reads / Writes: 68% / 32%
  21. Total buffers: 20.6G global + 3.0M per thread (5000 max threads)
  22. Maximum possible memory usage: 35.4G (55% of installed RAM)
  23. Slow queries: 0% (0/4M)
  24. Highest usage of available connections: 2% (79/5000)
  25. Key buffer size / total MyISAM indexes: 512.0M/138.0K
  26. Key buffer hit rate: 0% (2 cached / 2 reads)
  27. Sorts requiring temporary tables: 0% (0 temp sorts / 41 sorts)
  28. Temporary tables created on disk: 12% (72 on disk / 626 total)
  29. Thread cache hit rate: 99% (117 created / 658K connections)
  30. Table cache hit rate: 97% (195 open / 201 opened)
  31. Open file limit used: 0% (61/27K)
  32. Table locks acquired immediately: 100% (2M immediate / 2M locks)
  33. InnoDB data size / buffer pool: 2.2G/20.0G
  34. Run OPTIMIZE TABLE to defragment tables for better performance
  35. MySQL started within last 24 hours - recommendations may be inaccurate
  36. Scan Completed at Sunday, 16 June 2019 4:26:15 p.m.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement