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 | 3577 | 19279563716160 | 5389869408 | 275769921504 | 1269729120 | 768037685184 | 18510256301856 | 8 | 70656 | 8832.0000 | 2267 | 3039232 | 1340.6405 | |
innodb/innodb_data_file | 5437 | 10805579090592 | 1987415496 | 293455665888 | 345760173264 | 181850624208 | 10277968293120 | 1602 | 31358976 | 19574.8914 | 2714 | 96092160 | 35406.1017 | |
sql/binlog | 1139 | 2491498904400 | 2187444072 | 36272093616 | 2438399568 | 11293247856 | 2477767256976 | 196 | 1380 | 7.0408 | 174 | 60157 | 345.7299 | |
innodb/innodb_temp_file | 126 | 621094950960 | 4929324840 | 37386295056 | 0 | 3836218320 | 617258732640 | 0 | 0 | 0.0000 | 56 | 2228224 | 39789.7143 | |
sql/ERRMSG | 80 | 52127088816 | 651588432 | 4418422272 | 29298312912 | 0 | 22828775904 | 48 | 4912111 | 102335.6458 | 0 | 0 | 0.0000 | |
sql/binlog_index | 38 | 42213142224 | 1110872136 | 24221401776 | 953006208 | 0 | 41260136016 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 15285507072 | 1910688384 | 10825816848 | 2533668192 | 0 | 12751838880 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
csv/data | 17 | 2709988512 | 159410856 | 2007973968 | 411509472 | 0 | 2298479040 | 5 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 39 | 2395906656 | 61433328 | 1917992736 | 2313179616 | 0 | 82727040 | 26 | 1936 | 74.4615 | 0 | 0 | 0.0000 | |
myisam/kfile | 12 | 1462064736 | 121838640 | 550711392 | 1396983984 | 0 | 65080752 | 6 | 1296 | 216.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1042968960 | 69531264 | 985233216 | 0 | 0 | 1042968960 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 667676592 | 133535160 | 637329792 | 639298704 | 0 | 28377888 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 274623888 | 91541208 | 264225456 | 264225456 | 0 | 10398432 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 9 | 139334448 | 15481488 | 32025312 | 0 | 0 | 139334448 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 22614240 | 7537992 | 15075984 | 0 | 6195552 | 16418688 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|