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_data_file | 1789 | 1323522934800 | 739811424 | 239496389616 | 252733945200 | 21256973760 | 1049532015840 | 1274 | 25985024 | 20396.4082 | 307 | 19611648 | 63881.5896 | |
innodb/innodb_log_file | 242 | 1237785824352 | 5114817312 | 79439192448 | 1752740880 | 16120098720 | 1219912984752 | 8 | 70656 | 8832.0000 | 138 | 130560 | 946.0870 | |
innodb/innodb_temp_file | 101 | 462655804512 | 4580750328 | 28317353856 | 0 | 2495317440 | 460160487072 | 0 | 0 | 0.0000 | 37 | 1523712 | 41181.4054 | |
sql/binlog | 77 | 80049575760 | 1039604808 | 29755189200 | 808311504 | 281929296 | 78959334960 | 15 | 656 | 43.7333 | 5 | 632 | 126.4000 | |
sql/binlog_index | 38 | 70682308224 | 1860060576 | 34603513296 | 1802506464 | 0 | 68879801760 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 20 | 23015369520 | 1150768344 | 7102411536 | 13304991216 | 0 | 9710378304 | 12 | 1218859 | 101571.5833 | 0 | 0 | 0.0000 | |
sql/io_cache | 30 | 1044866064 | 34828728 | 533854464 | 106530336 | 232228128 | 706107600 | 8 | 557824 | 69728.0000 | 12 | 549076 | 45756.3333 | |
sql/casetest | 15 | 1035105984 | 69006960 | 971404368 | 0 | 0 | 1035105984 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 80 | 881550912 | 11019360 | 807489936 | 846910416 | 0 | 34640496 | 50 | 2973 | 59.4600 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 756725904 | 151345128 | 734736816 | 738283920 | 0 | 18441984 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 472894224 | 59111712 | 169859184 | 338257920 | 0 | 134636304 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 291557904 | 72889344 | 261409632 | 263301984 | 0 | 28255920 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 269895120 | 89964864 | 255139632 | 255139632 | 0 | 14755488 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 185964768 | 46491192 | 150643680 | 0 | 0 | 185964768 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 48753408 | 16251048 | 38670720 | 0 | 7634880 | 41118528 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 3 | 25764288 | 8587920 | 12524688 | 0 | 0 | 25764288 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|