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 | 2334 | 2344488466320 | 0 | 1004493600 | 219197557920 | 1315 | 26656768 | 20271.3065 | 734 | 32849920 | 44754.6594 | 59506688 | |
sql/io_cache | 373 | 62159749872 | 0 | 166647888 | 33219055056 | 164 | 8747004 | 53335.3902 | 149 | 8747004 | 58704.7248 | 17494008 | |
innodb/innodb_temp_file | 407 | 630705916368 | 0 | 1549645944 | 27144528048 | 0 | 0 | 0.0000 | 338 | 6782976 | 20067.9763 | 6782976 | |
sql/ERRMSG | 25 | 19258938336 | 2547600 | 770357280 | 4233154464 | 15 | 1531208 | 102080.5333 | 0 | 0 | 0.0000 | 1531208 | |
innodb/innodb_log_file | 596 | 3982935234432 | 228624 | 6682777200 | 732075747744 | 8 | 70656 | 8832.0000 | 346 | 291328 | 841.9884 | 361984 | |
mysys/charset | 3 | 311625072 | 2488464 | 103875024 | 297535392 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 143 | 50772126240 | 0 | 355049640 | 16813685856 | 32 | 724 | 22.6250 | 4 | 426 | 106.5000 | 1150 | |
myisam/kfile | 4 | 717290640 | 504240 | 179322528 | 701449584 | 2 | 407 | 203.5000 | 0 | 0 | 0.0000 | 407 | |
sql/binlog_index | 38 | 57926488224 | 0 | 1524381144 | 30399215616 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 575916000 | 180576 | 115183200 | 559968288 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
myisam/dfile | 5 | 762796320 | 1204896 | 152559264 | 751104816 | 1 | 39 | 39.0000 | 0 | 0 | 0.0000 | 39 | |
csv/metadata | 4 | 501719856 | 711216 | 125429832 | 426005712 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 50532768 | 2847504 | 16844256 | 39169680 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 796932576 | 0 | 53128680 | 734420544 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 20904576 | 0 | 10452288 | 10808160 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 16808352 | 0 | 8404176 | 11054736 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|