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 | 197 | 954817347264 | 4846788408 | 29281055232 | 1039289328 | 18762869136 | 935015188800 | 8 | 70656 | 8832.0000 | 111 | 158720 | 1429.9099 | |
innodb/innodb_data_file | 1903 | 920757195072 | 483844944 | 189355468896 | 166498465056 | 17468104896 | 736790625120 | 1321 | 27836416 | 21072.2301 | 291 | 19415040 | 66718.3505 | |
innodb/innodb_temp_file | 107 | 423680302848 | 3959628816 | 28535898864 | 0 | 1860808752 | 421819494096 | 0 | 0 | 0.0000 | 41 | 1720320 | 41959.0244 | |
sql/binlog | 171 | 73324179984 | 428796192 | 16857269616 | 2377431936 | 1244962752 | 69701785296 | 44 | 71617 | 1627.6591 | 6 | 1035 | 172.5000 | |
sql/ERRMSG | 45 | 33873803040 | 752751120 | 3278072688 | 18445369536 | 0 | 15428433504 | 27 | 2772763 | 102694.9259 | 0 | 0 | 0.0000 | |
sql/io_cache | 50 | 3536239872 | 70724544 | 1454891856 | 112033680 | 1266585408 | 2157620784 | 18 | 1241324 | 68962.4444 | 22 | 1241324 | 56423.8182 | |
sql/binlog_index | 23 | 1905983376 | 82868808 | 1276998096 | 226020960 | 0 | 1679962416 | 5 | 160 | 32.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 814425216 | 54294768 | 713752512 | 0 | 0 | 814425216 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 231193248 | 77064240 | 206145456 | 206145456 | 0 | 25047792 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 209423280 | 41884656 | 184578768 | 186120000 | 0 | 23303280 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/misc | 2 | 167170080 | 83585040 | 162687888 | 0 | 0 | 167170080 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 48384864 | 16128288 | 37736688 | 0 | 7765824 | 40619040 | 0 | 0 | 0.0000 | 1 | 5 | 5.0000 |
|