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 | 1665 | 1213524535344 | 0 | 728843544 | 244353626352 | 1201 | 24788992 | 20640.2931 | 256 | 18071552 | 70592.0000 | 42860544 | |
sql/ERRMSG | 55 | 43046797200 | 2845392 | 782668920 | 6249837792 | 33 | 3379687 | 102414.7576 | 0 | 0 | 0.0000 | 3379687 | |
innodb/innodb_temp_file | 101 | 420766995264 | 0 | 4166009760 | 26408086320 | 0 | 0 | 0.0000 | 37 | 1523712 | 41181.4054 | 1523712 | |
innodb/innodb_log_file | 179 | 1030802288208 | 231792 | 5758671864 | 83887098768 | 8 | 70656 | 8832.0000 | 98 | 101888 | 1039.6735 | 172544 | |
mysys/charset | 3 | 286418352 | 2224992 | 95472696 | 272584224 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/dfile | 80 | 8297326224 | 84480 | 103716360 | 8205714000 | 50 | 2973 | 59.4600 | 0 | 0 | 0.0000 | 2973 | |
sql/binlog | 147 | 66451485408 | 0 | 452050896 | 31498031136 | 33 | 728 | 22.0606 | 4 | 406 | 101.5000 | 1134 | |
myisam/kfile | 4 | 1217033136 | 1215984 | 304258152 | 1194966432 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 51369430464 | 0 | 1351827048 | 27985089264 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 504982896 | 155760 | 100996368 | 486435312 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 45614448 | 2536512 | 15204816 | 35258256 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 780922560 | 0 | 52061328 | 714407760 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 18843264 | 0 | 9421632 | 15159408 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|