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 | 1403 | 8925337748448 | 6361609056 | 711622532544 | 1927803504 | 145543019952 | 8777866924992 | 8 | 70656 | 8832.0000 | 817 | 692736 | 847.9021 | |
innodb/innodb_data_file | 3938 | 6677519274096 | 1695662496 | 266892107328 | 408757542864 | 103006259664 | 6165755471568 | 1604 | 31391744 | 19570.9127 | 1580 | 58572800 | 37071.3924 | |
innodb/innodb_temp_file | 207 | 603932470944 | 2917547952 | 35035000704 | 0 | 40210032720 | 563722438224 | 0 | 0 | 0.0000 | 137 | 3555328 | 25951.2993 | |
sql/binlog | 289 | 262085872752 | 906871416 | 35352778560 | 1204177920 | 1252809360 | 259628885472 | 62 | 844 | 13.6129 | 17 | 4851 | 285.3529 | |
sql/binlog_index | 38 | 59488653840 | 1565490696 | 27324990528 | 8945675376 | 0 | 50542978464 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 60 | 48285240432 | 804753840 | 5980265280 | 22640292048 | 0 | 25644948384 | 36 | 3685829 | 102384.1389 | 0 | 0 | 0.0000 | |
myisam/kfile | 12 | 6780730176 | 565060848 | 2509270896 | 6656752608 | 0 | 123977568 | 6 | 1311 | 218.5000 | 0 | 0 | 0.0000 | |
sql/io_cache | 146 | 3266209584 | 22371096 | 190022448 | 374675664 | 1961788752 | 929745168 | 68 | 3387866 | 49821.5588 | 58 | 3387866 | 58411.4828 | |
mysys/cnf | 5 | 1897008960 | 379401792 | 1880750256 | 1882199616 | 0 | 14809344 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 742338432 | 92792304 | 389370432 | 565041312 | 0 | 177297120 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 715649088 | 47709816 | 648433632 | 0 | 0 | 715649088 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 61 | 411875904 | 6752064 | 265378080 | 279453504 | 0 | 132422400 | 50 | 1950 | 39.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 300604656 | 100201464 | 279493104 | 279493104 | 0 | 21111552 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 12 | 264611424 | 22050864 | 175740576 | 19649520 | 0 | 244961904 | 3 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 5 | 73586304 | 14717208 | 20865504 | 0 | 0 | 73586304 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 17739216 | 5913072 | 11240064 | 0 | 5728272 | 12010944 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|