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 | 506 | 3291571825872 | 6505082496 | 256323311904 | 1602517488 | 236075851968 | 3053893456416 | 8 | 70656 | 8832.0000 | 296 | 249856 | 844.1081 | |
innodb/innodb_data_file | 2184 | 2024020440288 | 926749032 | 223922870688 | 347164862352 | 34948447776 | 1641907130160 | 1354 | 27295744 | 20159.3383 | 521 | 26230784 | 50346.9942 | |
innodb/innodb_temp_file | 126 | 617754501936 | 4902813432 | 33169371840 | 0 | 3780997440 | 613973504496 | 0 | 0 | 0.0000 | 55 | 2277376 | 41406.8364 | |
sql/binlog | 545 | 60509226096 | 111025992 | 31820943264 | 836396352 | 77597520 | 59595232224 | 133 | 1128 | 8.4812 | 3 | 156 | 52.0000 | |
sql/binlog_index | 38 | 56676621408 | 1491489912 | 31915880832 | 1126806384 | 0 | 55549815024 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 80 | 38687982960 | 483599688 | 2347538160 | 24971640672 | 0 | 13716342288 | 48 | 4904515 | 102177.3958 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 2017951056 | 252243816 | 1431819840 | 515056608 | 0 | 1502894448 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1700192208 | 340038336 | 1682324688 | 1683602976 | 0 | 16589232 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
myisam/kfile | 8 | 746276784 | 93284400 | 456878928 | 701343456 | 0 | 44933328 | 4 | 834 | 208.5000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 716577312 | 47771592 | 656827776 | 0 | 0 | 716577312 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 337864560 | 84466008 | 285583056 | 0 | 0 | 337864560 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 318642720 | 106214064 | 307660848 | 307660848 | 0 | 10981872 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 58441680 | 19480560 | 38369232 | 0 | 16963584 | 41478096 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
myisam/dfile | 5 | 21315360 | 4263072 | 8646528 | 0 | 0 | 21315360 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 1 | 13584912 | 13584912 | 13584912 | 0 | 0 | 13584912 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|