Re: MyTOP - Key Efficiency 50.0% - How to improve it?
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
Subject
Views
Written By
Posted
2041
January 19, 2018 10:21PM
1109
January 20, 2018 01:22AM
1262
January 21, 2018 02:55AM
1343
January 21, 2018 03:21AM
952
January 21, 2018 11:08AM
3776
January 21, 2018 08:02PM
1117
January 21, 2018 10:07PM
903
January 23, 2018 01:13AM
858
January 23, 2018 09:22AM
861
January 23, 2018 12:29PM
780
January 23, 2018 12:43PM
805
January 23, 2018 12:50PM
875
January 23, 2018 02:30PM
Re: MyTOP - Key Efficiency 50.0% - How to improve it?
1129
January 21, 2018 08:05PM
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.