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