Sort merge passes PS(merge/Uptime) : 0.00/s (1.00/6.91M) 0.00/s (0.00/60.00) Lower than 0
Sort range PS(range/Uptime) : 0.17/s (1.16M/6.91M) 0.05/s (3.00/60.00) Lower than 0
Sort rows PS(rows/Uptime) : 20.56/s (142.01M/6.91M) 12.38/s (743.00/60.00) Lower than 0
Sort scan PS(scan/Uptime) : 0.38/s (2.64M/6.91M) 0.28/s (17.00/60.00) Lower than 0
------------------------------------
connections status
------------------------------------
Thread cache hits(created/Total) : 99.88% (249.00/202.60k) 100.00% (0.00/1.00) Higher than 0
Connections used ratio(Max used/Max) : 25.17% (38.00/151.00) 0.00% (0.00/151.00) Lower than 90
Aborted connects ratio(Aborted/Max) : 168.21% (254.00/151.00) 0.00% (0.00/151.00) Lower than 0
Threads running : 1.00
------------------------------------
temp table and Open tables/files status
------------------------------------
Temp tables to Disk ratio(disk/tmp) : 3.21% (90.65k/2.75M) 0.00% (0.00/18.00) Lower than 0
Open tables/table open cache/Opened tables: (246.00/512.00/41.50k) (0.00/512.00/0.00) 1:1:1
Opened files PS(Opened/Uptime) : 0.07/s (506.48k/6.91M) 0.00/s (0.00/60.00) Lower than 0
InnoDB Status
------------------------------------
Innodb buffer read hits(Disk/total) : 99.91% (2.65M/2.74G) 100.00% (0.00/157.28k) Higher than 99.99
Innodb dblwr pages written:dblwr writes : 73.42:1 (144.62M/1.97M) Lower than 64:1
Innodb buffer pages used ratio(free/total): 100.00% (0.00/24.00k) Lower than 99.99
Innodb buffer pages dirty ratio(dirty) : 3.78% (928.00/24.00k)
Innodb buffer pages flushed PS(flushed) : 20.94/s (144.62M/6.91M) 11.90/s (714.00/60.00)
Innodb buffer pool pages misc : 325.00
Innodb row lock waits PS(waits/Uptime) : 0.00/s (0.00/6.91M) 0.00/s (0.00/60.00)
Innodb row lock current waits : 0.00 0.00
Innodb row lock time avg : 443.00 0.00
Innodb row lock time max : 50.09k 0.00
Innodb row lock time total : 10.86M 0.00
Innodb rows read PS(read/Uptime) : 466.70/s (3.15G/6.91M) 626.40/s (36.70k/60.00)
Innodb rows inserted PS(inserted/Uptime) : 246.39/s (1.66G/6.91M) 135.67/s (7.95k/60.00)
Innodb rows updated PS(updated/Uptime) : 69.96/s (483.08M/6.91M) 67.90/s (3.98k/60.00)
Innodb data reads PS(reads/Uptime) : 0.50/s (3.46M/6.91M)