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 | 437 | 2455698415632 | 5619446976 | 71453429520 | 1410869328 | 97220250336 | 2357067295968 | 8 | 70656 | 8832.0000 | 257 | 222208 | 864.6226 | |
innodb/innodb_data_file | 2260 | 1996924699440 | 883594800 | 255830954544 | 221780413536 | 33996770544 | 1741147515360 | 1388 | 27852800 | 20066.8588 | 574 | 28033024 | 48838.0209 | |
innodb/innodb_temp_file | 176 | 978014211504 | 5556898776 | 75693267408 | 0 | 4482758016 | 973531453488 | 0 | 0 | 0.0000 | 87 | 3981312 | 45762.2069 | |
sql/binlog | 837 | 62210810112 | 74325768 | 20904791424 | 1216897968 | 47762880 | 60946149264 | 206 | 1420 | 6.8932 | 3 | 156 | 52.0000 | |
sql/binlog_index | 38 | 57239191152 | 1506294504 | 39792057888 | 311414928 | 0 | 56927776224 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 55 | 48572132400 | 883129632 | 3284785680 | 25541923968 | 0 | 23030208432 | 33 | 3375735 | 102295.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1169087568 | 77939136 | 1106025888 | 0 | 0 | 1169087568 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 611903952 | 122380632 | 590283408 | 591536352 | 0 | 20367600 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 373400544 | 93350136 | 353777952 | 355889952 | 0 | 17510592 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
csv/data | 2 | 335714544 | 167857272 | 329804640 | 0 | 0 | 335714544 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 278368992 | 92789664 | 249423504 | 249423504 | 0 | 28945488 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 80 | 261538464 | 3269112 | 218783136 | 231082368 | 0 | 30456096 | 50 | 2973 | 59.4600 | 0 | 0 | 0.0000 | |
csv/metadata | 4 | 174374112 | 43593528 | 117786240 | 117786240 | 0 | 56587872 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 21898800 | 7299600 | 16901280 | 0 | 3917232 | 17981568 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 12691536 | 12691536 | 12691536 | 0 | 0 | 12691536 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|