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 | 1617 | 8347883896704 | 5162574912 | 31253294160 | 1406014896 | 197646139680 | 8148831742128 | 8 | 70656 | 8832.0000 | 962 | 762880 | 793.0146 | |
innodb/innodb_data_file | 3903 | 4335965440752 | 1110931272 | 266339978784 | 225939947904 | 48425012592 | 4061600480256 | 1350 | 27230208 | 20170.5244 | 2067 | 75284480 | 36422.0997 | |
innodb/innodb_temp_file | 96 | 472956330528 | 4926628344 | 42976739520 | 0 | 3557282256 | 469399048272 | 0 | 0 | 0.0000 | 34 | 1343488 | 39514.3529 | |
sql/binlog | 549 | 146767815744 | 267336432 | 25278922416 | 761676960 | 810974736 | 145195164048 | 132 | 1418 | 10.7424 | 10 | 2120 | 212.0000 | |
sql/binlog_index | 38 | 56662229184 | 1491111072 | 37200763776 | 571225776 | 0 | 56091003408 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 60 | 39685912992 | 661431672 | 2987675328 | 23080399056 | 0 | 16605513936 | 36 | 3686637 | 102406.5833 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 876598272 | 109574784 | 360032640 | 616252032 | 0 | 260346240 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 851156592 | 56743632 | 786105936 | 0 | 0 | 851156592 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 655022016 | 131004192 | 635520336 | 636726288 | 0 | 18295728 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 594807312 | 148701696 | 575697408 | 577885440 | 0 | 16921872 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 81 | 271416288 | 3350688 | 231025344 | 243023616 | 0 | 28392672 | 50 | 2973 | 59.4600 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 264019008 | 88006248 | 248145216 | 248145216 | 0 | 15873792 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 5 | 201069264 | 40213800 | 151517520 | 0 | 0 | 201069264 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 40122192 | 13373976 | 25926912 | 0 | 12000384 | 28121808 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
csv/data | 4 | 33392304 | 8347944 | 10098000 | 0 | 0 | 33392304 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|