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_data_file | 2037 | 2614835370048 | 1283669640 | 611176054896 | 231259645056 | 36128363568 | 2347447361424 | 1221 | 25116672 | 20570.5749 | 560 | 27672576 | 49415.3143 | |
innodb/innodb_log_file | 380 | 2600676422256 | 6843885312 | 420408344928 | 1736513856 | 455178705168 | 2143761203232 | 8 | 70656 | 8832.0000 | 221 | 218624 | 989.2489 | |
innodb/innodb_temp_file | 190 | 999168372048 | 5258780736 | 40648640208 | 0 | 6394529856 | 992773842192 | 0 | 0 | 0.0000 | 97 | 4407296 | 45436.0412 | |
sql/binlog | 417 | 79147528416 | 189802008 | 20279753472 | 3279866832 | 1018171440 | 74849490144 | 100 | 996 | 9.9600 | 5 | 810 | 162.0000 | |
sql/binlog_index | 38 | 49799609904 | 1310515800 | 29503493184 | 1144891440 | 0 | 48654718464 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 45 | 42581097504 | 946246488 | 6031572096 | 24382594368 | 0 | 18198503136 | 27 | 2772709 | 102692.9259 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1319936112 | 263987064 | 1304207520 | 1305415584 | 0 | 14520528 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1283246976 | 85549728 | 1204769280 | 0 | 0 | 1283246976 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 4 | 877366512 | 219341496 | 496217040 | 496217040 | 0 | 381149472 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
csv/data | 2 | 613783104 | 306891552 | 576110304 | 0 | 0 | 613783104 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 366423024 | 122140920 | 341266464 | 341266464 | 0 | 25156560 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 49798848 | 16599528 | 38854992 | 0 | 8213040 | 41585808 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 2 | 42347712 | 21173856 | 32935584 | 0 | 0 | 42347712 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|