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 | 3300 | 17650038009648 | 5348496120 | 275769921504 | 1269729120 | 752408976000 | 16896359304528 | 8 | 70656 | 8832.0000 | 2111 | 2914816 | 1380.7750 | |
innodb/innodb_data_file | 4935 | 9416216555328 | 1908047856 | 293455665888 | 328063909008 | 157529119968 | 8930623526352 | 1568 | 30801920 | 19644.0816 | 2411 | 87212032 | 36172.5558 | |
sql/binlog | 739 | 2430760393776 | 3289256256 | 36272093616 | 2146266672 | 10867202544 | 2417746924560 | 98 | 988 | 10.0816 | 170 | 58317 | 343.0412 | |
innodb/innodb_temp_file | 105 | 472978075680 | 4504553064 | 30567478656 | 0 | 3054186432 | 469923889248 | 0 | 0 | 0.0000 | 41 | 1589248 | 38762.1463 | |
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 | 4 | 2239868928 | 559967232 | 2007973968 | 0 | 0 | 2239868928 | 0 | 0 | 0.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 | |
myisam/kfile | 4 | 572049456 | 143012232 | 549737232 | 551936880 | 0 | 20112576 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 274623888 | 91541208 | 264225456 | 264225456 | 0 | 10398432 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 8 | 127774944 | 15971736 | 32025312 | 0 | 0 | 127774944 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 6 | 31933968 | 5322240 | 12348336 | 0 | 0 | 31933968 | 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 |
|