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 | 257 | 1565659574688 | 6092060568 | 79330369008 | 1556883504 | 54044888832 | 1510057802352 | 8 | 70656 | 8832.0000 | 142 | 132608 | 933.8592 | |
innodb/innodb_data_file | 1751 | 1522576412016 | 869546568 | 228903450864 | 235535624016 | 32980716384 | 1254060071616 | 1213 | 24985600 | 20598.1863 | 301 | 19415040 | 64501.7940 | |
innodb/innodb_temp_file | 93 | 467509948752 | 5026988472 | 41175541440 | 0 | 4298934288 | 463211014464 | 0 | 0 | 0.0000 | 32 | 1245184 | 38912.0000 | |
sql/binlog_index | 38 | 46864039728 | 1233264120 | 27367153440 | 389869920 | 0 | 46474169808 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 181 | 39484486800 | 218146104 | 18205369248 | 1209384528 | 92337696 | 38182764576 | 42 | 764 | 18.1905 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 45 | 23655712608 | 525682344 | 3224763168 | 12613805952 | 0 | 11041906656 | 27 | 2768337 | 102531.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 952502496 | 63499920 | 889619808 | 0 | 0 | 952502496 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 687347232 | 137469288 | 667554624 | 669138096 | 0 | 18209136 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 251730336 | 83910024 | 237186576 | 237186576 | 0 | 14543760 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 69201264 | 23067000 | 51397632 | 0 | 13010976 | 56190288 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 13995168 | 13995168 | 13995168 | 0 | 0 | 13995168 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|