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 | 2136 | 1720949277696 | 0 | 805687608 | 236989496832 | 1260 | 25755648 | 20440.9905 | 617 | 29507584 | 47824.2853 | 55263232 | |
sql/ERRMSG | 50 | 29722632720 | 3360192 | 594452496 | 2431143264 | 30 | 3067508 | 102250.2667 | 0 | 0 | 0.0000 | 3067508 | |
innodb/innodb_temp_file | 99 | 425757021360 | 0 | 4300575840 | 28895705520 | 0 | 0 | 0.0000 | 36 | 1441792 | 40049.7778 | 1441792 | |
innodb/innodb_log_file | 441 | 2194328332416 | 224928 | 4975800984 | 69460488768 | 8 | 70656 | 8832.0000 | 257 | 220672 | 858.6459 | 291328 | |
mysys/charset | 3 | 340026192 | 3411936 | 113342064 | 320246784 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 239 | 65542461600 | 0 | 274236072 | 22624848048 | 56 | 820 | 14.6429 | 4 | 417 | 104.2500 | 1237 | |
sql/binlog_index | 38 | 52519085520 | 0 | 1382081184 | 32431751616 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 1484811504 | 259776 | 296962248 | 1459366656 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 1318728576 | 1613040 | 329682144 | 1035302928 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 47488848 | 2952048 | 15829440 | 37332240 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1296065760 | 0 | 86404296 | 1223740848 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 558532128 | 0 | 279266064 | 545467824 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 43269600 | 0 | 21634800 | 30068016 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|