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 | 1340 | 7383607124256 | 5510154408 | 87442273776 | 1431696816 | 168825208464 | 7213350218976 | 8 | 70656 | 8832.0000 | 788 | 609792 | 773.8477 | |
innodb/innodb_data_file | 3377 | 3648754386288 | 1080472008 | 249264631968 | 277089795312 | 44662094928 | 3327002496048 | 1385 | 27803648 | 20074.8361 | 1499 | 57065472 | 38069.0274 | |
innodb/innodb_temp_file | 503 | 1284535359360 | 2553748032 | 46119970512 | 0 | 71348609904 | 1213186749456 | 0 | 0 | 0.0000 | 398 | 10125312 | 25440.4824 | |
sql/binlog | 403 | 82638294288 | 205057776 | 18025179744 | 1741508736 | 1456967424 | 79439818128 | 96 | 980 | 10.2083 | 6 | 902 | 150.3333 | |
sql/ERRMSG | 80 | 61004983248 | 762562152 | 4152585360 | 31392358800 | 0 | 29612624448 | 48 | 4913511 | 102364.8125 | 0 | 0 | 0.0000 | |
sql/binlog_index | 38 | 55647375696 | 1464404568 | 33043272240 | 1829628240 | 0 | 53817747456 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 17193369600 | 2149171200 | 15649651776 | 1189914528 | 0 | 16003455072 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 16 | 3918337632 | 244895904 | 2276250768 | 3860282976 | 0 | 58054656 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1005891216 | 67059168 | 943794720 | 0 | 0 | 1005891216 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 23 | 871818288 | 37905120 | 777377568 | 778248768 | 0 | 93569520 | 2 | 123 | 61.5000 | 0 | 0 | 0.0000 | |
csv/data | 16 | 609798288 | 38112360 | 253297440 | 262950336 | 0 | 346847952 | 5 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 534208752 | 106841592 | 515442048 | 516496464 | 0 | 17712288 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 239110608 | 79703448 | 226944960 | 226944960 | 0 | 12165648 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 4 | 67309440 | 16827360 | 30952416 | 0 | 0 | 67309440 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 54429936 | 18143136 | 34898688 | 0 | 16403904 | 38026032 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|