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 | 290 | 1616755971600 | 5575020528 | 114949024608 | 1432685232 | 78399427392 | 1536923858976 | 8 | 70656 | 8832.0000 | 171 | 165888 | 970.1053 | |
innodb/innodb_data_file | 1903 | 1093302564288 | 574515216 | 219869346576 | 184078932576 | 24573551904 | 884650079808 | 1228 | 25231360 | 20546.7101 | 464 | 24920064 | 53707.0345 | |
innodb/innodb_temp_file | 139 | 509389572912 | 3664672968 | 37375926720 | 0 | 19636644720 | 489752928192 | 0 | 0 | 0.0000 | 73 | 2244608 | 30748.0548 | |
sql/binlog_index | 38 | 45986038560 | 1210158840 | 29645548944 | 579655824 | 0 | 45406382736 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 69 | 32711019792 | 474072720 | 15568182960 | 1722749952 | 46778688 | 30941491152 | 14 | 652 | 46.5714 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 25 | 27807625824 | 1112304864 | 7904142576 | 12000421488 | 0 | 15807204336 | 15 | 1523304 | 101553.6000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1803762048 | 360752304 | 1767272496 | 1768633152 | 0 | 35128896 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 857192688 | 57145968 | 777431424 | 0 | 0 | 857192688 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 311792448 | 103930728 | 279432912 | 279432912 | 0 | 32359536 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 17499504 | 5833080 | 13821456 | 0 | 2626800 | 14872704 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 5423088 | 5423088 | 5423088 | 0 | 0 | 5423088 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|