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 | 3802 | 5089078783536 | 0 | 1338526728 | 228903210096 | 1519 | 29999104 | 19749.2456 | 1532 | 57753600 | 37698.1723 | 87752704 | |
innodb/innodb_temp_file | 430 | 2288620018608 | 0 | 5322372000 | 133687210272 | 0 | 0 | 0.0000 | 302 | 10059776 | 33310.5166 | 10059776 | |
sql/ERRMSG | 50 | 25060799808 | 2542848 | 501215880 | 3856888992 | 30 | 3075955 | 102531.8333 | 0 | 0 | 0.0000 | 3075955 | |
innodb/innodb_log_file | 2141 | 9480186770208 | 227568 | 4427924688 | 48131849040 | 8 | 70656 | 8832.0000 | 1471 | 2558464 | 1739.2685 | 2629120 | |
mysys/charset | 3 | 289534080 | 2172720 | 96511272 | 264756096 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 519 | 863561310480 | 0 | 1663894584 | 36012698304 | 103 | 1302 | 12.6408 | 53 | 11631 | 219.4528 | 12933 | |
sql/binlog_index | 38 | 54045764256 | 0 | 1422256704 | 36647350080 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 12981656688 | 628848 | 1622706888 | 12507652608 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 5383107312 | 404448 | 1076621304 | 5353041408 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 20036544 | 1120416 | 6678672 | 15735456 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1109531808 | 0 | 73968576 | 1049000832 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 8 | 110033088 | 0 | 13754136 | 36503808 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 257625456 | 0 | 64406232 | 207160800 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 4 | 109693584 | 0 | 27423264 | 36321120 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/kfile | 4 | 1856496048 | 0 | 464123880 | 1665191088 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|