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 | 1846 | 1700176974672 | 0 | 921005712 | 240016267920 | 1272 | 25952256 | 20402.7170 | 325 | 20103168 | 61855.9015 | 46055424 | |
sql/ERRMSG | 55 | 40436471328 | 2905584 | 735208320 | 4129231392 | 33 | 3381469 | 102468.7576 | 0 | 0 | 0.0000 | 3381469 | |
innodb/innodb_temp_file | 93 | 415539815328 | 0 | 4468169904 | 34925346192 | 0 | 0 | 0.0000 | 32 | 1245184 | 38912.0000 | 1245184 | |
innodb/innodb_log_file | 275 | 1655120416752 | 241824 | 6018619464 | 78737548032 | 8 | 70656 | 8832.0000 | 155 | 139776 | 901.7806 | 210432 | |
mysys/charset | 3 | 285729840 | 2407680 | 95243280 | 270125856 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 169 | 38621950224 | 0 | 228532128 | 17657849088 | 39 | 752 | 19.2821 | 3 | 156 | 52.0000 | 908 | |
sql/binlog_index | 38 | 75010258752 | 0 | 1973954136 | 55067144352 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 1520070288 | 184272 | 304013952 | 1500015264 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 57111648 | 2908224 | 19037040 | 33530640 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1158014880 | 0 | 77200992 | 1096131168 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 5816976 | 0 | 5816976 | 5816976 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|