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 | 1805 | 1449808030704 | 0 | 803217624 | 230494455840 | 1214 | 25001984 | 20594.7150 | 331 | 20365312 | 61526.6224 | 45367296 | |
sql/ERRMSG | 75 | 34577652912 | 2748768 | 461035344 | 2398293216 | 45 | 4606964 | 102376.9778 | 0 | 0 | 0.0000 | 4606964 | |
innodb/innodb_temp_file | 93 | 369038265552 | 0 | 3968153376 | 38776641024 | 0 | 0 | 0.0000 | 32 | 1245184 | 38912.0000 | 1245184 | |
innodb/innodb_log_file | 249 | 1406227181040 | 242880 | 5647498560 | 115587376608 | 8 | 70656 | 8832.0000 | 140 | 147456 | 1053.2571 | 218112 | |
mysys/charset | 3 | 332853840 | 2286240 | 110951280 | 317843856 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 119 | 88530756336 | 0 | 743955696 | 19627009248 | 25 | 696 | 27.8400 | 6 | 980 | 163.3333 | 1676 | |
myisam/kfile | 4 | 620867280 | 824208 | 155216688 | 598253568 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 50078690112 | 0 | 1317860016 | 29538603600 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 1701140496 | 151008 | 340227888 | 1681173648 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 46516272 | 2675904 | 15505248 | 35574000 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 766087872 | 0 | 51072384 | 694079760 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 35024352 | 0 | 11674608 | 13657776 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 1 | 8784336 | 8784336 | 8784336 | 8784336 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|