MySQL Forums
Forum List  »  Performance

Re: MyTOP - Key Efficiency 50.0% - How to improve it?
Posted by: Mahesh Kumar
Date: January 21, 2018 08:05PM

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



Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.