SELECT * FROM `x$io_global_by_wait_by_latency`
|
event_name | total | total_latency | avg_latency | max_latency | read_latency | write_latency | misc_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_log_file | 803 | 4684434166368 | 5833666344 | 82745584416 | 1267421760 | 162294148896 | 4520872595712 | 8 | 70656 | 8832.0000 | 480 | 477696 | 995.2000 | |
innodb/innodb_data_file | 2799 | 3283783026480 | 1173198576 | 247959302976 | 291884407056 | 49526653440 | 2942371965984 | 1492 | 29556736 | 19810.1448 | 866 | 37044224 | 42776.2402 | |
innodb/innodb_temp_file | 93 | 378346161600 | 4068238152 | 24705598896 | 0 | 3553245168 | 374792916432 | 0 | 0 | 0.0000 | 32 | 1245184 | 38912.0000 | |
sql/binlog | 213 | 256878223008 | 1206000840 | 24339846960 | 3145536768 | 1042940976 | 252689745264 | 43 | 768 | 17.8605 | 17 | 4963 | 291.9412 | |
sql/binlog_index | 38 | 55629660240 | 1463938344 | 31649114640 | 627588192 | 0 | 55002072048 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 60 | 41174677104 | 686244504 | 4169448096 | 22624282032 | 0 | 18550395072 | 36 | 3686637 | 102406.5833 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 5114565984 | 639320616 | 2015428800 | 1131116448 | 0 | 3983449536 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1253131440 | 83542008 | 1190901360 | 0 | 0 | 1253131440 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1182228432 | 236445528 | 1166819280 | 1167967152 | 0 | 14261280 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/misc | 10 | 355993968 | 35599344 | 194792928 | 0 | 0 | 355993968 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 307711008 | 102570336 | 293969808 | 293969808 | 0 | 13741200 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 233078208 | 58269552 | 214315728 | 215359056 | 0 | 17719152 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 6 | 68355936 | 11392656 | 31455072 | 0 | 0 | 68355936 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 61532592 | 15383016 | 27745872 | 0 | 0 | 61532592 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 51070272 | 17023248 | 40122720 | 0 | 7714608 | 43355664 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|