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 | 3350 | 3973132789824 | 0 | 1186009704 | 220174262352 | 1434 | 28606464 | 19948.7197 | 1407 | 54411264 | 38671.8294 | 83017728 | |
sql/ERRMSG | 65 | 74151371184 | 2442528 | 1140790200 | 31722260592 | 39 | 4001064 | 102591.3846 | 0 | 0 | 0.0000 | 4001064 | |
innodb/innodb_temp_file | 120 | 510728521776 | 0 | 4256070984 | 27228813216 | 0 | 0 | 0.0000 | 51 | 2080768 | 40799.3725 | 2080768 | |
sql/io_cache | 38 | 2399996016 | 0 | 63157776 | 849145968 | 10 | 987224 | 98722.4000 | 18 | 987224 | 54845.7778 | 1974448 | |
innodb/innodb_log_file | 1102 | 5700780057984 | 218592 | 5173121448 | 41118052800 | 8 | 70656 | 8832.0000 | 669 | 721408 | 1078.3378 | 792064 | |
mysys/charset | 3 | 350567184 | 3293664 | 116855640 | 330839520 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 489 | 208191824544 | 0 | 425749896 | 33466219248 | 116 | 1354 | 11.6724 | 12 | 3036 | 253.0000 | 4390 | |
myisam/kfile | 4 | 356274336 | 689568 | 89068584 | 338605344 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 44794263888 | 0 | 1178796168 | 23338890432 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 624240144 | 147840 | 124847976 | 594510048 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 521548896 | 636768 | 130387224 | 447570288 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 46331472 | 2390256 | 15443736 | 36649008 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 705055824 | 0 | 47003616 | 641580720 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 4 | 53204448 | 0 | 13301112 | 18099312 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 175284912 | 0 | 87642456 | 165600336 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 9592704 | 2539152 | 4796352 | 7053552 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|