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 | 2374 | 3539569519200 | 0 | 1490972736 | 738347057712 | 1401 | 28065792 | 20032.6852 | 616 | 29016064 | 47104.0000 | 57081856 | |
sql/ERRMSG | 75 | 44290768368 | 2311056 | 590543448 | 4129903536 | 45 | 4600249 | 102227.7556 | 0 | 0 | 0.0000 | 4600249 | |
innodb/innodb_temp_file | 122 | 650553274272 | 0 | 5332403736 | 97859525280 | 0 | 0 | 0.0000 | 53 | 2113536 | 39878.0377 | 2113536 | |
innodb/innodb_log_file | 440 | 2706227986176 | 229680 | 6150518088 | 102480608208 | 8 | 70656 | 8832.0000 | 251 | 249344 | 993.4024 | 320000 | |
mysys/charset | 3 | 248289360 | 2090880 | 82762944 | 236422032 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 319 | 76590836256 | 0 | 240096648 | 15651755328 | 75 | 896 | 11.9467 | 6 | 1101 | 183.5000 | 1997 | |
myisam/kfile | 4 | 3921432768 | 1156848 | 980358192 | 3898451568 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 54798326880 | 0 | 1442061192 | 28263998400 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 421543584 | 158928 | 84308664 | 404722032 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 49488384 | 2988480 | 16496040 | 38462160 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 925461504 | 0 | 61697328 | 856153056 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 33117744 | 0 | 11039160 | 11857824 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 13380048 | 673200 | 6690024 | 12706848 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|