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 | 211 | 1056043047312 | 5004943152 | 57235777632 | 1345825536 | 12938945184 | 1041758276592 | 8 | 70656 | 8832.0000 | 119 | 120320 | 1011.0924 | |
innodb/innodb_data_file | 1637 | 667572043776 | 407801856 | 245410425744 | 180311614032 | 18212643504 | 469047786240 | 1207 | 24887296 | 20619.1350 | 262 | 18497536 | 70601.2824 | |
innodb/innodb_temp_file | 107 | 402797382240 | 3764461272 | 26543867328 | 0 | 1273212336 | 401524169904 | 0 | 0 | 0.0000 | 41 | 1720320 | 41959.0244 | |
sql/binlog_index | 38 | 51779263536 | 1362611976 | 35470844640 | 432162192 | 0 | 51347101344 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 85 | 32211658512 | 378960648 | 15083359104 | 728275680 | 28579056 | 31454803776 | 18 | 668 | 37.1111 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 35 | 16449295104 | 469979664 | 1923128592 | 10933630752 | 0 | 5515664352 | 21 | 2143981 | 102094.3333 | 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 | |
mysys/charset | 3 | 229817808 | 76605936 | 207184032 | 207184032 | 0 | 22633776 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 15370608 | 5123448 | 10822944 | 0 | 3889776 | 11480832 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 7728864 | 7728864 | 7728864 | 0 | 0 | 7728864 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|