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 | 301 | 1556703739008 | 5171773200 | 27177780432 | 1121912352 | 51508941264 | 1504072885392 | 8 | 70656 | 8832.0000 | 170 | 159232 | 936.6588 | |
innodb/innodb_data_file | 2047 | 1441728314400 | 704312664 | 222775784880 | 174726270048 | 26596426560 | 1240405617792 | 1279 | 26066944 | 20380.7224 | 486 | 25313280 | 52084.9383 | |
innodb/innodb_temp_file | 293 | 539009357040 | 1839622224 | 30274304016 | 0 | 3486039744 | 535523317296 | 0 | 0 | 0.0000 | 224 | 4915200 | 21942.8571 | |
sql/binlog_index | 38 | 47432794992 | 1248231336 | 26943374832 | 360801408 | 0 | 47071993584 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 117 | 42262890912 | 361221168 | 19664604960 | 3004545984 | 45213168 | 39213131760 | 26 | 700 | 26.9231 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 30 | 27193936176 | 906464328 | 5312789328 | 12627562464 | 0 | 14566373712 | 18 | 1836485 | 102026.9444 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 917246880 | 61149792 | 842346384 | 0 | 0 | 917246880 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 678474720 | 135694944 | 648228240 | 649547184 | 0 | 28927536 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 269424144 | 89808048 | 252202368 | 252202368 | 0 | 17221776 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 48376944 | 16125648 | 37272576 | 0 | 8326560 | 40050384 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 5717184 | 5717184 | 5717184 | 0 | 0 | 5717184 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|