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 | 8142 | 16308874967088 | 0 | 2003055120 | 208445228112 | 1486 | 29458432 | 19823.9785 | 4823 | 165298176 | 34272.8957 | 194756608 | |
sql/io_cache | 1078 | 234025617408 | 0 | 217092216 | 115625705712 | 574 | 24576978 | 42817.0348 | 404 | 24576978 | 60834.1040 | 49153956 | |
innodb/innodb_temp_file | 619 | 1156078723008 | 0 | 1867655328 | 101454419088 | 0 | 0 | 0.0000 | 533 | 11091968 | 20810.4465 | 11091968 | |
innodb/innodb_log_file | 5998 | 30791936481504 | 241296 | 5133700440 | 487373194176 | 8 | 70656 | 8832.0000 | 3842 | 5944832 | 1547.3274 | 6015488 | |
sql/ERRMSG | 95 | 51436724592 | 3336960 | 541439184 | 3115452384 | 57 | 5827242 | 102232.3158 | 0 | 0 | 0.0000 | 5827242 | |
sql/binlog | 695 | 1844039754480 | 0 | 2653294512 | 45209465136 | 110 | 1036 | 9.4182 | 124 | 57126 | 460.6935 | 58162 | |
mysys/charset | 3 | 228115008 | 2193840 | 76038336 | 207151296 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/dfile | 162 | 679499568 | 82368 | 4194432 | 327765504 | 101 | 6013 | 59.5347 | 0 | 0 | 0.0000 | 6013 | |
myisam/kfile | 8 | 1660930128 | 703824 | 207616200 | 1419599808 | 4 | 834 | 208.5000 | 0 | 0 | 0.0000 | 834 | |
sql/binlog_index | 38 | 42625691328 | 0 | 1121728608 | 24759077904 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 2429963712 | 748704 | 303745464 | 1138762416 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 1139391792 | 185856 | 227878200 | 1122780384 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 13122912 | 676368 | 4374216 | 10483968 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 729231888 | 0 | 48615336 | 655465536 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 18 | 316032288 | 0 | 17557320 | 35784144 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 9 | 5157882576 | 0 | 573098064 | 3871025136 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|