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 | 2286 | 1525376912400 | 0 | 667268976 | 208518144384 | 1423 | 28426240 | 19976.2755 | 600 | 29147136 | 48578.5600 | 57573376 | |
innodb/innodb_temp_file | 162 | 923198614800 | 0 | 5698756800 | 46568358144 | 0 | 0 | 0.0000 | 69 | 3948544 | 57225.2754 | 3948544 | |
sql/ERRMSG | 45 | 23269645872 | 3716064 | 517103136 | 2182090944 | 27 | 2763851 | 102364.8519 | 0 | 0 | 0.0000 | 2763851 | |
innodb/innodb_log_file | 406 | 2179689112656 | 231792 | 5368692384 | 43972665264 | 8 | 70656 | 8832.0000 | 239 | 237568 | 994.0084 | 308224 | |
mysys/charset | 3 | 292691520 | 2084544 | 97563840 | 260727456 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 227 | 94204173888 | 0 | 414996120 | 27733704768 | 52 | 804 | 15.4615 | 6 | 1287 | 214.5000 | 2091 | |
myisam/kfile | 4 | 1543563648 | 491568 | 385890912 | 1526901024 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 47176761984 | 0 | 1241493528 | 30247199664 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 790313568 | 915024 | 98789064 | 349025952 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 544225440 | 136752 | 108845088 | 527549616 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 12810336 | 608784 | 4269936 | 10283328 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 785356704 | 0 | 52357008 | 696972144 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 252258336 | 0 | 126129168 | 248411856 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 38123184 | 0 | 9530664 | 11968704 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 7024512 | 359568 | 3512256 | 6664944 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|