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 | 1794 | 1415521652688 | 0 | 789030792 | 258699486672 | 1235 | 25346048 | 20523.1158 | 302 | 19415040 | 64288.2119 | 44761088 | |
sql/ERRMSG | 75 | 71679134208 | 1807344 | 955721712 | 21996951504 | 45 | 4606038 | 102356.4000 | 0 | 0 | 0.0000 | 4606038 | |
innodb/innodb_temp_file | 127 | 522449885760 | 0 | 4113778416 | 54002606592 | 0 | 0 | 0.0000 | 66 | 1802240 | 27306.6667 | 1802240 | |
innodb/innodb_log_file | 245 | 1573655321040 | 222288 | 6423082776 | 101558825280 | 8 | 70656 | 8832.0000 | 139 | 131584 | 946.6475 | 202240 | |
mysys/charset | 3 | 307153440 | 1512192 | 102384480 | 296683200 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 901 | 40197492192 | 0 | 44614152 | 16595397984 | 222 | 1484 | 6.6847 | 3 | 156 | 52.0000 | 1640 | |
sql/binlog_index | 38 | 56051034336 | 0 | 1475027136 | 31191227232 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 1636274112 | 213312 | 327254664 | 1616338416 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 51596160 | 2922480 | 17198544 | 39492816 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1042401360 | 0 | 69493248 | 984081648 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 10709952 | 0 | 10709952 | 10709952 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|