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 | 6313 | 11470217998800 | 0 | 1816920072 | 233296477920 | 1580 | 30998528 | 19619.3215 | 3424 | 118145024 | 34504.9720 | 149143552 | |
sql/io_cache | 1398 | 186709325088 | 0 | 133554432 | 86838969888 | 628 | 32042696 | 51023.4013 | 560 | 32033948 | 57203.4786 | 64076644 | |
innodb/innodb_temp_file | 693 | 1564240583136 | 0 | 2257201320 | 232762062720 | 0 | 0 | 0.0000 | 581 | 13582336 | 23377.5146 | 13582336 | |
sql/ERRMSG | 70 | 37972019184 | 2923008 | 542457168 | 3769126944 | 42 | 4297629 | 102324.5000 | 0 | 0 | 0.0000 | 4297629 | |
innodb/innodb_log_file | 3660 | 19146274941552 | 250272 | 5231222568 | 105948853824 | 8 | 70656 | 8832.0000 | 2259 | 2999296 | 1327.7096 | 3069952 | |
myisam/dfile | 5125 | 13024386144 | 0 | 2541264 | 3564073920 | 1157 | 89871 | 77.6759 | 3340 | 490780 | 146.9401 | 580651 | |
sql/binlog | 821 | 1282304664960 | 0 | 1561881288 | 41573934336 | 145 | 1323 | 9.1241 | 149 | 517717 | 3474.6107 | 519040 | |
sql/SDI | 24 | 861870240 | 0 | 35911128 | 155739408 | 0 | 0 | 0.0000 | 7 | 32069 | 4581.2857 | 32069 | |
mysys/charset | 3 | 273181920 | 3851232 | 91060464 | 252586224 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/kfile | 108 | 3439469088 | 0 | 31846848 | 594682176 | 20 | 3735 | 186.7500 | 48 | 2840 | 59.1667 | 6575 | |
sql/binlog_index | 38 | 42034233120 | 0 | 1106163960 | 22641224496 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 564948384 | 669504 | 70618416 | 287829696 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 419504448 | 208032 | 83900784 | 397463088 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 13537392 | 631488 | 4512288 | 10782288 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
csv/data | 8 | 953889552 | 0 | 119236128 | 344532672 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 27 | 660821568 | 0 | 24474648 | 269687088 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/casetest | 15 | 869730048 | 0 | 57981792 | 788290272 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|