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 | 265 | 1701366700176 | 6420251640 | 129183994896 | 1145272656 | 92509332960 | 1607712094560 | 8 | 70656 | 8832.0000 | 151 | 150016 | 993.4834 | |
innodb/innodb_data_file | 1918 | 1352410528128 | 705114960 | 219834741984 | 215756185392 | 28248045408 | 1108406297328 | 1231 | 25280512 | 20536.5654 | 447 | 24264704 | 54283.4541 | |
innodb/innodb_temp_file | 183 | 953927725344 | 5212719600 | 33460258128 | 0 | 4749530544 | 949178194800 | 0 | 0 | 0.0000 | 92 | 4194304 | 45590.2609 | |
sql/binlog_index | 38 | 43290146592 | 1139214384 | 24643233120 | 2261651040 | 0 | 41028495552 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 225 | 33607044240 | 149364600 | 17475897120 | 1227294288 | 58940640 | 32320809312 | 53 | 808 | 15.2453 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 50 | 30341470896 | 606829344 | 2768509920 | 18467565600 | 0 | 11873905296 | 30 | 3078053 | 102601.7667 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 923454048 | 184690704 | 903129744 | 904781856 | 0 | 18672192 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 729468432 | 48631176 | 661805760 | 0 | 0 | 729468432 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 304378800 | 101459424 | 286931040 | 286931040 | 0 | 17447760 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 20873952 | 6957984 | 16426608 | 0 | 3601488 | 17272464 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 13764960 | 13764960 | 13764960 | 0 | 0 | 13764960 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|