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 | 1923 | 1193072777952 | 0 | 620422440 | 245795673024 | 1383 | 27770880 | 20080.1735 | 285 | 19021824 | 66743.2421 | 46792704 | |
sql/ERRMSG | 30 | 16892707392 | 2831664 | 563090088 | 2654190000 | 18 | 1833960 | 101886.6667 | 0 | 0 | 0.0000 | 1833960 | |
innodb/innodb_temp_file | 90 | 348439042512 | 0 | 3871544688 | 24608782704 | 0 | 0 | 0.0000 | 30 | 1146880 | 38229.3333 | 1146880 | |
innodb/innodb_log_file | 244 | 1508850743136 | 231264 | 6183814296 | 69535840704 | 8 | 70656 | 8832.0000 | 136 | 129024 | 948.7059 | 199680 | |
mysys/charset | 3 | 252908832 | 1284096 | 84302856 | 240450144 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 59 | 88494142176 | 0 | 1499900688 | 48126104400 | 11 | 640 | 58.1818 | 4 | 417 | 104.2500 | 1057 | |
myisam/kfile | 4 | 599560368 | 1099296 | 149889960 | 582401424 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 61992295200 | 0 | 1631376120 | 34984824336 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 1635813696 | 165792 | 327162528 | 1615728048 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 51047040 | 3300000 | 17015592 | 38546112 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1163767440 | 0 | 77584320 | 1089348480 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 224806560 | 0 | 112403280 | 219130032 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 9516672 | 513216 | 4758336 | 9003456 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|