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