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 | 1808 | 9394511220336 | 5196079152 | 241912409376 | 1345825536 | 485506941216 | 8907658453584 | 8 | 70656 | 8832.0000 | 1077 | 820224 | 761.5822 | |
innodb/innodb_data_file | 4190 | 3872037374832 | 924113784 | 245410425744 | 257957022576 | 78302990304 | 3535777361952 | 1512 | 29884416 | 19764.8254 | 2185 | 79118336 | 36209.7648 | |
innodb/innodb_temp_file | 393 | 1196651220336 | 3044913960 | 59624750592 | 0 | 298405939392 | 898245280944 | 0 | 0 | 0.0000 | 301 | 7684096 | 25528.5581 | |
sql/binlog | 279 | 76679013840 | 274835088 | 15083359104 | 4631009856 | 1381716336 | 70666287648 | 65 | 856 | 13.1692 | 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 |
|