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 | 593 | 3551797338672 | 5989540128 | 82301119824 | 1789877232 | 127228384800 | 3422779076640 | 8 | 70656 | 8832.0000 | 345 | 376320 | 1090.7826 | |
innodb/innodb_data_file | 2409 | 3061624114032 | 1270910784 | 234943721232 | 259348057056 | 32485993056 | 2769790063920 | 1260 | 25755648 | 20440.9905 | 786 | 34717696 | 44170.0967 | |
innodb/innodb_temp_file | 141 | 558095705376 | 3958125336 | 39501338976 | 0 | 43227871632 | 514867833744 | 0 | 0 | 0.0000 | 75 | 2277376 | 30365.0133 | |
sql/binlog | 139 | 201366408672 | 1448679144 | 61084278816 | 2809602576 | 2502142896 | 196054663200 | 28 | 708 | 25.2857 | 10 | 2395 | 239.5000 | |
sql/binlog_index | 38 | 48670696272 | 1280807616 | 26150281872 | 1726863072 | 0 | 46943833200 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 50 | 34902522864 | 698050320 | 5476056432 | 21463840464 | 0 | 13438682400 | 30 | 3077203 | 102573.4333 | 0 | 0 | 0.0000 | |
sql/io_cache | 50 | 2972902944 | 59457816 | 1649576016 | 190526688 | 885878400 | 1896497856 | 18 | 1294936 | 71940.8889 | 22 | 1294936 | 58860.7273 | |
sql/casetest | 15 | 747529728 | 49835280 | 687086400 | 0 | 0 | 747529728 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 384900384 | 76980024 | 364775136 | 366097248 | 0 | 18803136 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 290393136 | 96797712 | 276241152 | 276241152 | 0 | 14151984 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 4 | 264303072 | 66075768 | 226157712 | 0 | 0 | 264303072 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 99521136 | 33173712 | 73107936 | 0 | 22450560 | 77070576 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|