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 | 149 | 1339044033360 | 8986872576 | 440531201088 | 1415212128 | 471575381904 | 866053439328 | 8 | 70656 | 8832.0000 | 79 | 84992 | 1075.8481 | |
innodb/innodb_data_file | 1662 | 922608240048 | 555119136 | 192636095520 | 186686176512 | 13456585824 | 722465477712 | 1217 | 25051136 | 20584.3353 | 237 | 17448960 | 73624.3038 | |
innodb/innodb_temp_file | 307 | 472977205536 | 1540642224 | 91563481152 | 0 | 95224580880 | 377752624656 | 0 | 0 | 0.0000 | 244 | 4849664 | 19875.6721 | |
sql/binlog_index | 38 | 59622204048 | 1569005328 | 43954579152 | 530814240 | 0 | 59091389808 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 355 | 45217030848 | 127371816 | 16958885856 | 871490928 | 574375824 | 43771164096 | 85 | 936 | 11.0118 | 4 | 403 | 100.7500 | |
sql/ERRMSG | 65 | 38815113744 | 597155592 | 2212969440 | 19654993776 | 0 | 19160119968 | 39 | 3983584 | 102143.1795 | 0 | 0 | 0.0000 | |
sql/io_cache | 100 | 10784736864 | 107847168 | 5151718176 | 329936112 | 8481606144 | 1973194608 | 36 | 2528012 | 70222.5556 | 44 | 2528012 | 57454.8182 | |
mysys/cnf | 5 | 3024196560 | 604839312 | 3005189088 | 3006447312 | 0 | 17749248 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 973682160 | 64912056 | 895532880 | 0 | 0 | 973682160 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 240092688 | 80030808 | 220014432 | 220014432 | 0 | 20078256 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 2 | 205585776 | 102792888 | 202060848 | 0 | 0 | 205585776 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 11862048 | 3953928 | 9429552 | 0 | 1742400 | 10119648 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|