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 | 4029 | 5496811630992 | 0 | 1364311608 | 260930042736 | 1311 | 26591232 | 20283.1670 | 2173 | 78135296 | 35957.3382 | 104726528 | |
sql/ERRMSG | 65 | 37636970976 | 2812128 | 579030144 | 5902461312 | 39 | 3988885 | 102279.1026 | 0 | 0 | 0.0000 | 3988885 | |
innodb/innodb_temp_file | 126 | 598216865136 | 0 | 4747752768 | 41151824208 | 0 | 0 | 0.0000 | 54 | 2326528 | 43083.8519 | 2326528 | |
innodb/innodb_log_file | 1945 | 10542497664864 | 236544 | 5420307024 | 64113849360 | 8 | 70656 | 8832.0000 | 1166 | 923136 | 791.7118 | 993792 | |
mysys/charset | 3 | 344316192 | 1445136 | 114771888 | 330950928 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 239 | 223952390112 | 0 | 937039224 | 31602059280 | 51 | 800 | 15.6863 | 14 | 3050 | 217.8571 | 3850 | |
sql/binlog_index | 38 | 51666919392 | 0 | 1359655704 | 32769960432 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 3593651952 | 670560 | 449206296 | 1890788064 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 1362985536 | 231792 | 272596896 | 1344145968 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 46878480 | 2699664 | 15626160 | 36913536 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 766368240 | 0 | 51091128 | 704028336 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 6 | 313698528 | 0 | 52283088 | 225640800 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 46 | 668803872 | 0 | 14539008 | 417266256 | 18 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|