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 | 2234 | 1961023039008 | 0 | 877807920 | 266102164944 | 1400 | 28049408 | 20035.2914 | 535 | 26820608 | 50131.9776 | 54870016 | |
sql/ERRMSG | 85 | 41840054256 | 2672736 | 492235920 | 2537423856 | 51 | 5217088 | 102295.8431 | 0 | 0 | 0.0000 | 5217088 | |
innodb/innodb_temp_file | 126 | 609358125552 | 0 | 4836175344 | 32953412976 | 0 | 0 | 0.0000 | 54 | 2326528 | 43083.8519 | 2326528 | |
innodb/innodb_log_file | 333 | 2269009908000 | 231792 | 6813843432 | 258773418816 | 8 | 70656 | 8832.0000 | 189 | 192000 | 1015.8730 | 262656 | |
sql/binlog | 498 | 97069626720 | 0 | 194918856 | 22617796608 | 119 | 1072 | 9.0084 | 9 | 23956 | 2661.7778 | 25028 | |
mysys/charset | 3 | 315836400 | 2091936 | 105278712 | 301353360 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/kfile | 4 | 1608140688 | 2556048 | 402035040 | 1539140592 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 49484360112 | 0 | 1302219864 | 24144116304 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 913985424 | 260832 | 182797032 | 897612672 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 1662676752 | 524304 | 415669056 | 1382174640 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 59686176 | 2962608 | 19895304 | 36177504 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 758696928 | 0 | 50579760 | 691420224 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 12910656 | 0 | 12910656 | 12910656 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 6 | 192698880 | 0 | 32116392 | 164969904 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 3 | 43339296 | 305712 | 14446344 | 33435600 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|