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 | 289 | 1529637974832 | 5292864720 | 36331396992 | 975976848 | 31522282176 | 1497139715808 | 8 | 70656 | 8832.0000 | 162 | 190976 | 1178.8642 | |
innodb/innodb_data_file | 1766 | 1366543837824 | 773807232 | 67317245952 | 178527813552 | 18886381008 | 1169129643264 | 1224 | 22462464 | 18351.6863 | 382 | 21872640 | 57258.2199 | |
innodb/innodb_temp_file | 205 | 461216077872 | 2249834400 | 31150029504 | 0 | 3299539056 | 457916538816 | 0 | 0 | 0.0000 | 137 | 3424256 | 24994.5693 | |
sql/binlog | 584 | 152431040256 | 261012048 | 24349930176 | 3988647168 | 743326320 | 147699066768 | 146 | 67770 | 464.1781 | 10 | 2202 | 220.2000 | |
sql/ERRMSG | 40 | 21026607360 | 525665184 | 1950396624 | 11064170304 | 0 | 9962437056 | 24 | 2452577 | 102190.7083 | 0 | 0 | 0.0000 | |
sql/binlog_index | 23 | 2766887904 | 120299256 | 1784278320 | 2050404576 | 0 | 716483328 | 5 | 224 | 44.8000 | 0 | 0 | 0.0000 | |
sql/io_cache | 46 | 959766192 | 20864448 | 88484352 | 116646816 | 519750000 | 323369376 | 16 | 1150596 | 71912.2500 | 20 | 1150596 | 57529.8000 | |
sql/casetest | 15 | 764657520 | 50977080 | 673676256 | 0 | 0 | 764657520 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 6 | 476088624 | 79348104 | 457991952 | 5960592 | 0 | 470128032 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 445463040 | 148487592 | 420734688 | 420734688 | 0 | 24728352 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 6 | 419206128 | 69867600 | 326283936 | 0 | 0 | 419206128 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 232156848 | 46431264 | 204667584 | 205843968 | 0 | 26312880 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/metadata | 4 | 217296288 | 54324072 | 151939920 | 151939920 | 0 | 65356368 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 12026256 | 4008576 | 10020912 | 0 | 1437216 | 10589040 | 0 | 0 | 0.0000 | 1 | 5 | 5.0000 |
|