Re: MyTOP - Key Efficiency 50.0% - How to improve it?

[Mahesh Kumar]

additional info for previous message.

[--] Up for: 2d 14h 28m 58s (106M q [474.386 qps], 25M conn, TX: 59B, RX: 11B)
[--] Reads / Writes: 76% / 24%
[--] Binary logging is enabled (GTID MODE: OFF)
[--] Total buffers: 4.9G global + 7.5M per thread (200 max threads)
[OK] Maximum reached memory usage: 5.2G (16.57% of installed RAM)
[OK] Maximum possible memory usage: 6.4G (20.33% of installed RAM)
[OK] Slow queries: 0% (0/106M)
[OK] Highest usage of available connections: 20% (40/200)
[OK] Aborted connections: 0.00%  (5/25772899)
[!!] Query cache efficiency: 0.0% (4K cached / 22M selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 1K sorts)
[OK] Temporary tables created on disk: 0% (11 on disk / 1K total)
[OK] Thread cache hit rate: 99% (40 created / 25M connections)
[OK] Table cache hit rate: 90% (141 open / 156 opened)
[OK] Open file limit used: 0% (61/16K)
[OK] Table locks acquired immediately: 100% (56M immediate / 56M locks)
[OK] Binlog cache memory access: 100.00% ( 6994352 Memory / 6994383 Total)



[--] Status: +Aria +CSV +InnoDB +MRG_MyISAM +SEQUENCE
[--] Data in InnoDB tables: 1007M (Tables: 4)
[!!] Total fragmented tables: 3