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 | 2186 | 2107757472480 | 0 | 964207200 | 226041508704 | 1313 | 26624000 | 20277.2277 | 569 | 27967488 | 49152.0000 | 54591488 | |
sql/ERRMSG | 45 | 22294083504 | 3701808 | 495423984 | 3674860992 | 27 | 2762609 | 102318.8519 | 0 | 0 | 0.0000 | 2762609 | |
innodb/innodb_temp_file | 93 | 357274601904 | 0 | 3841662264 | 38063283984 | 0 | 0 | 0.0000 | 32 | 1245184 | 38912.0000 | 1245184 | |
innodb/innodb_log_file | 385 | 2082855706800 | 236544 | 5410014720 | 30555704784 | 8 | 70656 | 8832.0000 | 225 | 246784 | 1096.8178 | 317440 | |
mysys/charset | 3 | 285165408 | 2258784 | 95055048 | 270585744 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 105 | 105894861600 | 0 | 1008522240 | 30236500272 | 21 | 680 | 32.3810 | 7 | 1774 | 253.4286 | 2454 | |
sql/binlog_index | 38 | 48653997216 | 0 | 1280368320 | 33253354464 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 1137298272 | 149424 | 227459496 | 1119079632 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 13749648 | 632544 | 4583040 | 10948608 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 894795792 | 0 | 59652912 | 810195408 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 65719632 | 0 | 21906456 | 34612512 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|