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 | 2987 | 4494127485408 | 0 | 1504562136 | 261511009584 | 1375 | 27639808 | 20101.6785 | 1092 | 45039616 | 41245.0696 | 72679424 | |
sql/ERRMSG | 80 | 47101764864 | 3150576 | 588772008 | 5407560048 | 48 | 4913609 | 102366.8542 | 0 | 0 | 0.0000 | 4913609 | |
innodb/innodb_log_file | 1404 | 7276161789600 | 243408 | 5182451208 | 176926562736 | 8 | 70656 | 8832.0000 | 899 | 1458688 | 1622.5673 | 1529344 | |
innodb/innodb_temp_file | 93 | 404726552736 | 0 | 4351898232 | 27681074784 | 0 | 0 | 0.0000 | 32 | 1245184 | 38912.0000 | 1245184 | |
mysys/charset | 3 | 286894608 | 2195952 | 95631360 | 267625248 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 321 | 369933822720 | 0 | 1152441576 | 28273244736 | 66 | 860 | 13.0303 | 25 | 9802 | 392.0800 | 10662 | |
sql/binlog_index | 38 | 64475664528 | 0 | 1696728000 | 37325602512 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 886121280 | 250272 | 177224256 | 867715728 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 1384021056 | 1557072 | 346005264 | 1078552464 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 61153488 | 3144240 | 20384496 | 48392256 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 937529472 | 0 | 62501736 | 874727568 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 4 | 48066480 | 0 | 12016488 | 13334640 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 8 | 591358944 | 0 | 73919736 | 510386976 | 3 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|