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 | 1800 | 2383591577136 | 1324217400 | 611176054896 | 223541008944 | 33277157232 | 2126773410960 | 1190 | 24608768 | 20679.6370 | 366 | 21479424 | 58686.9508 | |
innodb/innodb_log_file | 294 | 2177911090608 | 7407860592 | 420408344928 | 1736513856 | 444270963312 | 1731903613440 | 8 | 70656 | 8832.0000 | 169 | 172544 | 1020.9704 | |
innodb/innodb_temp_file | 190 | 999168372048 | 5258780736 | 40648640208 | 0 | 6394529856 | 992773842192 | 0 | 0 | 0.0000 | 97 | 4407296 | 45436.0412 | |
sql/binlog | 409 | 79095854112 | 193388184 | 20279753472 | 3274077312 | 1018171440 | 74803605360 | 98 | 988 | 10.0816 | 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 | |
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 |
|