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 | 3478 | 5652156779280 | 0 | 1625116944 | 261511009584 | 1377 | 27672576 | 20096.2789 | 1479 | 57229312 | 38694.5991 | 84901888 | |
sql/ERRMSG | 90 | 57777878400 | 3150576 | 641976192 | 5407560048 | 54 | 5523094 | 102279.5185 | 0 | 0 | 0.0000 | 5523094 | |
innodb/innodb_log_file | 1740 | 9131992485264 | 243408 | 5248271424 | 176926562736 | 8 | 70656 | 8832.0000 | 1108 | 1707520 | 1541.0830 | 1778176 | |
innodb/innodb_temp_file | 102 | 461168321328 | 0 | 4521257928 | 27681074784 | 0 | 0 | 0.0000 | 38 | 1540096 | 40528.8421 | 1540096 | |
mysys/charset | 3 | 286894608 | 2195952 | 95631360 | 267625248 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 467 | 444839431872 | 0 | 952546848 | 28273244736 | 100 | 996 | 9.9600 | 30 | 10996 | 366.5333 | 11992 | |
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 | 6 | 99115632 | 0 | 16519272 | 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 |
|