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 | 3736 | 6439883760816 | 0 | 1723737576 | 261511009584 | 1382 | 27754496 | 20082.8480 | 1657 | 62734336 | 37860.1907 | 90488832 | |
sql/ERRMSG | 95 | 60500875776 | 3150576 | 636851160 | 5407560048 | 57 | 5827242 | 102232.3158 | 0 | 0 | 0.0000 | 5827242 | |
innodb/innodb_log_file | 1918 | 10279997854896 | 243408 | 5359748592 | 176926562736 | 8 | 70656 | 8832.0000 | 1214 | 1854976 | 1527.9868 | 1925632 | |
innodb/innodb_temp_file | 111 | 523038357072 | 0 | 4712057064 | 27861872544 | 0 | 0 | 0.0000 | 44 | 1835008 | 41704.7273 | 1835008 | |
mysys/charset | 3 | 286894608 | 2195952 | 95631360 | 267625248 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 687 | 543132087168 | 0 | 790585224 | 28273244736 | 152 | 1204 | 7.9211 | 36 | 12685 | 352.3611 | 13889 | |
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 | 7 | 114237024 | 0 | 16319424 | 31725408 | 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 |
|