SELECT * FROM `x$io_global_by_wait_by_bytes`
|
event_name | total | total_latency | min_latency | avg_latency | max_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | total_requested | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_data_file | 4284 | 8127057875376 | 0 | 1897072320 | 277333751376 | 1525 | 30097408 | 19736.0052 | 1889 | 68567040 | 36298.0625 | 98664448 | |
sql/ERRMSG | 60 | 43224891072 | 3537600 | 720414816 | 3525186720 | 36 | 3685521 | 102375.5833 | 0 | 0 | 0.0000 | 3685521 | |
innodb/innodb_temp_file | 153 | 769105444272 | 0 | 5026832712 | 30927318048 | 0 | 0 | 0.0000 | 73 | 3162112 | 43316.6027 | 3162112 | |
innodb/innodb_log_file | 1969 | 10897739843760 | 227568 | 5534657040 | 135250366416 | 8 | 70656 | 8832.0000 | 1189 | 1340416 | 1127.3474 | 1411072 | |
mysys/charset | 3 | 252861840 | 4012272 | 84287280 | 231961488 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 437 | 451351340880 | 0 | 1032840336 | 32280357120 | 93 | 968 | 10.4086 | 29 | 10308 | 355.4483 | 11276 | |
myisam/dfile | 83 | 1884774144 | 77088 | 22707960 | 1831283520 | 50 | 2973 | 59.4600 | 0 | 0 | 0.0000 | 2973 | |
myisam/kfile | 4 | 690102864 | 717024 | 172525584 | 671177760 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 55563448512 | 0 | 1462195944 | 27100689264 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 3088228704 | 618288 | 386028456 | 1887575712 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 494212224 | 159984 | 98842392 | 475391664 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 55859232 | 2970000 | 18619656 | 39141696 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 885287568 | 0 | 59019048 | 802069488 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 4 | 286226160 | 0 | 71556408 | 229767648 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 43 | 324631824 | 0 | 7549344 | 65974128 | 17 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|