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 | 528 | 70519008384 | 0 | 133558656 | 32065074624 | 244 | 12723877 | 52147.0369 | 214 | 12723877 | 59457.3692 | 25447754 | |
innodb/innodb_temp_file | 497 | 1192282708320 | 0 | 2398959024 | 169687511664 | 0 | 0 | 0.0000 | 405 | 9388032 | 23180.3259 | 9388032 | |
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 | 1243 | 70814532624 | 0 | 56970408 | 15738382704 | 307 | 1824 | 5.9414 | 4 | 426 | 106.5000 | 2250 | |
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 |
|