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 | 3063 | 3831287880288 | 0 | 1250828304 | 253694102640 | 1517 | 29966336 | 19753.6823 | 1059 | 42713088 | 40333.4164 | 72679424 | |
sql/io_cache | 484 | 69723260112 | 0 | 144056088 | 32065074624 | 230 | 11547919 | 50208.3435 | 194 | 11547919 | 59525.3557 | 23095838 | |
innodb/innodb_temp_file | 491 | 1155377610288 | 0 | 2353111200 | 169687511664 | 0 | 0 | 0.0000 | 401 | 9191424 | 22921.2569 | 9191424 | |
sql/ERRMSG | 60 | 37722427776 | 2531760 | 628707024 | 2430498576 | 36 | 3694592 | 102627.5556 | 0 | 0 | 0.0000 | 3694592 | |
innodb/innodb_log_file | 821 | 4946784259824 | 256608 | 6025315560 | 147025206768 | 8 | 70656 | 8832.0000 | 476 | 378368 | 794.8908 | 449024 | |
mysys/charset | 3 | 284263056 | 1424544 | 94754352 | 273166080 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 1143 | 70256842656 | 0 | 61466856 | 15738382704 | 282 | 1724 | 6.1135 | 4 | 426 | 106.5000 | 2150 | |
myisam/kfile | 4 | 579117264 | 483648 | 144779184 | 565024416 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 48961349712 | 0 | 1288456488 | 29711564256 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 37634989392 | 1833216 | 4704373608 | 28839385344 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 629578752 | 154704 | 125915592 | 575607120 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 18914544 | 983664 | 6304848 | 14573328 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 848243616 | 0 | 56549328 | 788201040 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 527985216 | 0 | 263992608 | 522086400 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 1722134304 | 0 | 430533576 | 1596590160 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 6 | 41562576 | 295680 | 6927096 | 27404784 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|