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 | 3610 | 3576831764352 | 0 | 990812064 | 230358733440 | 1362 | 27426816 | 20137.1630 | 1820 | 67518464 | 37098.0571 | 94945280 | |
sql/io_cache | 678 | 185243144064 | 0 | 273219936 | 127129271280 | 292 | 16075678 | 55053.6918 | 276 | 16075678 | 58245.2101 | 32151356 | |
innodb/innodb_temp_file | 1052 | 1287798998640 | 0 | 1224143448 | 58998639216 | 0 | 0 | 0.0000 | 946 | 19169280 | 20263.5095 | 19169280 | |
sql/ERRMSG | 25 | 17925923664 | 3315312 | 717036936 | 3462545328 | 15 | 1535694 | 102379.6000 | 0 | 0 | 0.0000 | 1535694 | |
innodb/innodb_log_file | 1511 | 7759498284912 | 229152 | 5135339616 | 37966513200 | 8 | 70656 | 8832.0000 | 893 | 691200 | 774.0202 | 761856 | |
mysys/charset | 3 | 247294080 | 3451536 | 82431360 | 227166192 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 185 | 64336006416 | 0 | 347762184 | 17455792464 | 42 | 764 | 18.1905 | 5 | 591 | 118.2000 | 1355 | |
sql/binlog_index | 38 | 53821200048 | 0 | 1416347328 | 35815364640 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 9413016096 | 856944 | 1176626880 | 8554132224 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 859982640 | 210144 | 171996528 | 831023952 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 22796928 | 1093488 | 7598976 | 18620976 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 890187408 | 0 | 59345616 | 788670960 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 42854592 | 0 | 14284776 | 17484192 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 9 | 1619720256 | 0 | 179968800 | 847356576 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|