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 | 3126 | 3981730039584 | 0 | 1273745880 | 326474601024 | 1579 | 30982144 | 19621.3705 | 1070 | 43270144 | 40439.3869 | 74252288 | |
sql/ERRMSG | 70 | 51393562176 | 2533344 | 734193504 | 6608534064 | 42 | 4293608 | 102228.7619 | 0 | 0 | 0.0000 | 4293608 | |
innodb/innodb_temp_file | 115 | 567306934656 | 0 | 4933103736 | 36816655392 | 0 | 0 | 0.0000 | 46 | 1998848 | 43453.2174 | 1998848 | |
innodb/innodb_log_file | 1059 | 6059080047504 | 230736 | 5721510696 | 59934542448 | 8 | 70656 | 8832.0000 | 615 | 475136 | 772.5789 | 545792 | |
mysys/charset | 3 | 262153584 | 1997424 | 87384528 | 242450736 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/dfile | 62 | 17486652480 | 425040 | 282042552 | 14763883728 | 29 | 4708 | 162.3448 | 0 | 0 | 0.0000 | 4708 | |
myisam/kfile | 16 | 3808927584 | 682704 | 238057776 | 2326117728 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | 1703 | |
sql/binlog | 589 | 44010267312 | 0 | 74720184 | 20350696608 | 144 | 1172 | 8.1389 | 3 | 156 | 52.0000 | 1328 | |
sql/binlog_index | 38 | 57386636736 | 0 | 1510174512 | 35078650992 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 2498964336 | 634128 | 312370344 | 1283368416 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 1670291040 | 544368 | 334058208 | 1652723424 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 48920784 | 2991648 | 16306752 | 37265184 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 996430512 | 0 | 66428472 | 923386464 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 6930528 | 0 | 6930528 | 6930528 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 57 | 1496846208 | 0 | 26260344 | 1167009360 | 23 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|