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 | 5828 | 11897673707568 | 0 | 2041467648 | 519658791696 | 1495 | 29605888 | 19803.2696 | 3103 | 111099904 | 35804.0296 | 140705792 | |
sql/io_cache | 1617 | 252725376816 | 0 | 156292488 | 43942661136 | 843 | 38272782 | 45400.6904 | 634 | 38272782 | 60367.1640 | 76545564 | |
innodb/innodb_temp_file | 780 | 1120757922768 | 0 | 1436869104 | 82541036688 | 0 | 0 | 0.0000 | 686 | 14123008 | 20587.4752 | 14123008 | |
innodb/innodb_log_file | 4266 | 21568355909760 | 238656 | 5055873240 | 591224951328 | 8 | 70656 | 8832.0000 | 2808 | 5033472 | 1792.5470 | 5104128 | |
sql/ERRMSG | 75 | 68606821536 | 3400320 | 914757360 | 5944207632 | 45 | 4600824 | 102240.5333 | 0 | 0 | 0.0000 | 4600824 | |
sql/binlog | 601 | 1297308617088 | 0 | 2158583328 | 30396075600 | 104 | 1012 | 9.7308 | 89 | 46856 | 526.4719 | 47868 | |
mysys/charset | 3 | 289078416 | 2702832 | 96359472 | 270186048 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/kfile | 4 | 587172960 | 2465232 | 146793240 | 528924000 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 42613047840 | 0 | 1121395968 | 25739955648 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 448626816 | 145728 | 89725152 | 428210640 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 11452945680 | 494208 | 2863236288 | 9103606512 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 14327280 | 726000 | 4775760 | 10661376 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 786055248 | 0 | 52403472 | 707000448 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 7 | 2101390896 | 0 | 300198624 | 1846735440 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 14 | 329001552 | 0 | 23499960 | 246721728 | 5 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 32393328 | 6767904 | 16196664 | 25625424 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|