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 | 353 | 1718078356368 | 4867077336 | 37831739088 | 444448224 | 31355134272 | 1686278773872 | 8 | 70656 | 8832.0000 | 205 | 206336 | 1006.5171 | |
innodb/innodb_data_file | 1980 | 671246683536 | 339013224 | 62772847632 | 142658447184 | 17076430272 | 511511806080 | 1356 | 27820032 | 20516.2478 | 379 | 22200320 | 58576.0422 | |
innodb/innodb_temp_file | 195 | 457696190160 | 2347159848 | 80439195408 | 0 | 2020570464 | 455675619696 | 0 | 0 | 0.0000 | 129 | 3162112 | 24512.4961 | |
sql/binlog | 81 | 44163487104 | 545228112 | 15841225488 | 2671180512 | 732975408 | 40759331184 | 18 | 9083 | 504.6111 | 4 | 526 | 131.5000 | |
sql/ERRMSG | 25 | 11661773904 | 466470840 | 2680334448 | 7537789776 | 0 | 4123984128 | 15 | 1543317 | 102887.8000 | 0 | 0 | 0.0000 | |
sql/binlog_index | 23 | 914975952 | 39781368 | 216948864 | 579406080 | 0 | 335569872 | 5 | 224 | 44.8000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 771654576 | 51443568 | 692585520 | 0 | 0 | 771654576 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 375032592 | 75006360 | 205213008 | 166132560 | 0 | 208900032 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 329157312 | 109718928 | 316500096 | 316500096 | 0 | 12657216 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 235618944 | 78539472 | 229899648 | 0 | 4313760 | 231305184 | 0 | 0 | 0.0000 | 1 | 5 | 5.0000 | |
sql/misc | 1 | 2614128 | 2614128 | 2614128 | 0 | 0 | 2614128 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|