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 | 2521 | 2309554297248 | 0 | 916126200 | 234219198576 | 1487 | 29474816 | 19821.6651 | 647 | 30064640 | 46467.7589 | 59539456 | |
sql/ERRMSG | 95 | 48531570384 | 2258256 | 510858480 | 3313036848 | 57 | 5825219 | 102196.8246 | 0 | 0 | 0.0000 | 5825219 | |
sql/io_cache | 108 | 2331099936 | 0 | 21584112 | 174606432 | 44 | 2405376 | 54667.6364 | 44 | 2396628 | 54468.8182 | 4802004 | |
innodb/innodb_temp_file | 148 | 580975658736 | 0 | 3925511040 | 29308729296 | 0 | 0 | 0.0000 | 80 | 2490368 | 31129.6000 | 2490368 | |
innodb/innodb_log_file | 544 | 3807046254000 | 236016 | 6998246640 | 864065632320 | 8 | 70656 | 8832.0000 | 310 | 253440 | 817.5484 | 324096 | |
mysys/charset | 3 | 222057264 | 2041776 | 74019000 | 209158752 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/dfile | 28 | 189263712 | 192192 | 6759192 | 161487744 | 25 | 6525 | 261.0000 | 0 | 0 | 0.0000 | 6525 | |
sql/binlog | 403 | 80904323808 | 0 | 200755104 | 31612018416 | 97 | 984 | 10.1443 | 4 | 414 | 103.5000 | 1398 | |
myisam/kfile | 4 | 490688352 | 601920 | 122672088 | 468077280 | 2 | 462 | 231.0000 | 0 | 0 | 0.0000 | 462 | |
sql/binlog_index | 38 | 52262871936 | 0 | 1375338624 | 30467276400 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 926660592 | 851664 | 115832376 | 447208608 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 661139952 | 211728 | 132227832 | 642417072 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 58175040 | 2982672 | 19391592 | 37443648 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 678900288 | 0 | 45259896 | 619829760 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 13645104 | 0 | 6822552 | 10401072 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 18 | 316523856 | 0 | 17584512 | 184257744 | 6 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|