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 | 3005 | 4220093266752 | 0 | 1404356976 | 224877456144 | 1416 | 28311552 | 19994.0339 | 996 | 42024960 | 42193.7349 | 70336512 | |
sql/ERRMSG | 95 | 49127690304 | 3221856 | 517133496 | 3273623232 | 57 | 5828025 | 102246.0526 | 0 | 0 | 0.0000 | 5828025 | |
innodb/innodb_temp_file | 154 | 618483136128 | 0 | 4016124024 | 25545606240 | 0 | 0 | 0.0000 | 78 | 2981888 | 38229.3333 | 2981888 | |
innodb/innodb_log_file | 1673 | 8145655051248 | 238128 | 4868891016 | 86062213776 | 8 | 70656 | 8832.0000 | 1056 | 1644544 | 1557.3333 | 1715200 | |
mysys/charset | 3 | 322235760 | 2320032 | 107411832 | 307915344 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 931 | 355391742816 | 0 | 381731064 | 18488844528 | 217 | 1464 | 6.7465 | 28 | 8976 | 320.5714 | 10440 | |
myisam/kfile | 8 | 1554638976 | 1047024 | 194329872 | 922501008 | 4 | 904 | 226.0000 | 0 | 0 | 0.0000 | 904 | |
sql/binlog_index | 38 | 45504647232 | 0 | 1197490536 | 27821921952 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 468547200 | 187968 | 93709440 | 445125120 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 417009120 | 625152 | 104252280 | 357303408 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 41814960 | 2147904 | 13938144 | 35743488 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 732768960 | 0 | 48851088 | 651666576 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 5 | 64790880 | 0 | 12958176 | 24207216 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 214380672 | 0 | 107190336 | 206878320 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 8 | 76211520 | 362208 | 9526440 | 49265568 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|