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 | 2900 | 3776637151750 | 0 | 1302288440 | 225206598830 | 1506 | 29786112 | 19778.2948 | 940 | 38813696 | 41291.1660 | 68599808 | |
innodb/innodb_temp_file | 306 | 1595056116260 | 0 | 5212601675 | 551813438430 | 0 | 0 | 0.0000 | 224 | 5767168 | 25746.2857 | 5767168 | |
sql/io_cache | 108 | 24794261780 | 0 | 229576390 | 22438578200 | 40 | 2862056 | 71551.4000 | 48 | 2862056 | 59626.1667 | 5724112 | |
sql/ERRMSG | 40 | 25845725600 | 2407260 | 646143140 | 4338084980 | 24 | 2466220 | 102759.1667 | 0 | 0 | 0.0000 | 2466220 | |
innodb/innodb_log_file | 837 | 5573384067350 | 235320 | 6658762325 | 148444844890 | 8 | 70656 | 8832.0000 | 481 | 400384 | 832.3992 | 471040 | |
mysys/charset | 3 | 293442450 | 1446900 | 97814150 | 269986240 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 159 | 146528877930 | 0 | 921565060 | 23960646510 | 34 | 732 | 21.5294 | 8 | 1829 | 228.6250 | 2561 | |
myisam/kfile | 4 | 568548490 | 752070 | 142136990 | 549412310 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 53512641440 | 0 | 1408227225 | 31794243140 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 857624800 | 623810 | 107203100 | 490349640 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 1049331100 | 140450 | 209866220 | 1028687070 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 61312520 | 3372920 | 20437330 | 36045830 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 732532610 | 0 | 48835260 | 674010540 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 543278090 | 0 | 271639045 | 533978180 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 16 | 308200830 | 0 | 19262320 | 217542210 | 5 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 8441310 | 331250 | 4220655 | 8110060 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|