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 | 2415 | 1918921186360 | 0 | 794584215 | 218587358340 | 1516 | 29949952 | 19755.9050 | 574 | 28033024 | 48838.0209 | 57982976 | |
sql/io_cache | 84 | 105829963810 | 0 | 1259880490 | 96774428330 | 28 | 1970364 | 70370.1429 | 36 | 1970364 | 54732.3333 | 3940728 | |
sql/ERRMSG | 45 | 13077682160 | 3028420 | 290614900 | 1194970860 | 27 | 2771926 | 102663.9259 | 0 | 0 | 0.0000 | 2771926 | |
innodb/innodb_temp_file | 121 | 1289762455510 | 0 | 10659193845 | 797603721990 | 0 | 0 | 0.0000 | 52 | 2097152 | 40329.8462 | 2097152 | |
innodb/innodb_log_file | 484 | 2640691807690 | 232140 | 5455974760 | 52198752890 | 8 | 70656 | 8832.0000 | 276 | 232448 | 842.2029 | 303104 | |
mysys/charset | 3 | 262329860 | 2171410 | 87443110 | 235102700 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 127 | 76240964280 | 0 | 600322520 | 19327604340 | 27 | 704 | 26.0741 | 6 | 770 | 128.3333 | 1474 | |
myisam/kfile | 4 | 505684130 | 1087030 | 126420900 | 484018260 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 41108337000 | 0 | 1081798105 | 24971620980 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 5724004240 | 691650 | 715500530 | 5121748810 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 1948465500 | 145220 | 389693100 | 1901348500 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 15863430 | 851180 | 5287810 | 12626720 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1021828870 | 0 | 68121695 | 925719730 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 4 | 38481180 | 0 | 9620295 | 13504400 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 214045270 | 0 | 53511185 | 175502080 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 8329480 | 347150 | 4164740 | 7982330 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|