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 | 3318 | 4408723551936 | 0 | 1328729160 | 242575698816 | 1524 | 30081024 | 19738.2047 | 1275 | 50184192 | 39360.1506 | 80265216 | |
sql/io_cache | 836 | 127200638400 | 0 | 152153760 | 36552420432 | 408 | 20339568 | 49851.8824 | 338 | 20339568 | 60176.2367 | 40679136 | |
innodb/innodb_temp_file | 872 | 1301313669744 | 0 | 1492332072 | 96750811344 | 0 | 0 | 0.0000 | 770 | 16023552 | 20809.8078 | 16023552 | |
sql/ERRMSG | 80 | 41504944272 | 2535984 | 518811744 | 6476849280 | 48 | 4913838 | 102371.6250 | 0 | 0 | 0.0000 | 4913838 | |
innodb/innodb_log_file | 1109 | 5863189248048 | 233904 | 5286915216 | 108253357344 | 8 | 70656 | 8832.0000 | 666 | 680448 | 1021.6937 | 751104 | |
mysys/charset | 3 | 216930384 | 1490544 | 72310128 | 205299072 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 443 | 222345174480 | 0 | 501907824 | 25443187968 | 102 | 1004 | 9.8431 | 14 | 5263 | 375.9286 | 6267 | |
myisam/kfile | 4 | 1677040464 | 1247136 | 419259984 | 1643137056 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 50658173808 | 0 | 1333109712 | 30410630448 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 2018423616 | 864336 | 252302952 | 1153277664 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 576402288 | 137280 | 115280352 | 553091616 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 55697136 | 2973168 | 18565536 | 36339600 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 929455296 | 0 | 61963440 | 866185584 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 5 | 459521040 | 0 | 91904208 | 224358288 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 71382960 | 0 | 17845608 | 38238816 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 14393280 | 630960 | 7196640 | 13762320 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|