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 | 1837 | 9569391948336 | 5209249584 | 241912409376 | 1345825536 | 486199370976 | 9081846751824 | 8 | 70656 | 8832.0000 | 1093 | 828416 | 757.9286 | |
innodb/innodb_data_file | 4229 | 4006086944112 | 947289288 | 245410425744 | 260178249936 | 78679663920 | 3667229030256 | 1515 | 29933568 | 19758.1307 | 2203 | 79577088 | 36122.1462 | |
innodb/innodb_temp_file | 447 | 1290223129008 | 2886405192 | 59624750592 | 0 | 305524030416 | 984699098592 | 0 | 0 | 0.0000 | 349 | 8863744 | 25397.5473 | |
sql/io_cache | 154 | 79447769808 | 515894544 | 64782273600 | 317646912 | 1872531408 | 77257591488 | 72 | 3601038 | 50014.4167 | 62 | 3601038 | 58081.2581 | |
sql/binlog | 323 | 77196993984 | 238999728 | 15083359104 | 4940415216 | 1381716336 | 70874862432 | 76 | 900 | 11.8421 | 6 | 879 | 146.5000 | |
sql/binlog_index | 38 | 51779263536 | 1362611976 | 35470844640 | 432162192 | 0 | 51347101344 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 55 | 25302426336 | 460044024 | 2321821920 | 14740549296 | 0 | 10561877040 | 33 | 3371041 | 102152.7576 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1469243424 | 293848632 | 1444132800 | 1445472336 | 0 | 23771088 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1291776288 | 86118384 | 1201424400 | 0 | 0 | 1291776288 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 1270851648 | 317712912 | 693366432 | 0 | 0 | 1270851648 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 12 | 679016976 | 56584704 | 237273696 | 616750464 | 0 | 62266512 | 6 | 1296 | 216.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 34 | 556337760 | 16362720 | 278545344 | 514674336 | 0 | 41663424 | 26 | 6592 | 253.5385 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 488640240 | 61079832 | 145834128 | 288575760 | 0 | 200064480 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 229817808 | 76605936 | 207184032 | 207184032 | 0 | 22633776 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 4 | 40430016 | 10107504 | 11898480 | 0 | 0 | 40430016 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 15370608 | 5123448 | 10822944 | 0 | 3889776 | 11480832 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|