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 | 2900 | 3360836041200 | 0 | 1158908784 | 204021059616 | 1453 | 28917760 | 19902.1060 | 986 | 40517632 | 41092.9331 | 69435392 | |
sql/io_cache | 108 | 4683361584 | 0 | 43364376 | 2474985744 | 42 | 2545592 | 60609.3333 | 46 | 2536844 | 55148.7826 | 5082436 | |
innodb/innodb_temp_file | 164 | 695207466624 | 0 | 4239069912 | 34104722256 | 0 | 0 | 0.0000 | 89 | 3096576 | 34792.9888 | 3096576 | |
sql/ERRMSG | 30 | 12518282832 | 3494832 | 417276024 | 2490819408 | 18 | 1849990 | 102777.2222 | 0 | 0 | 0.0000 | 1849990 | |
innodb/innodb_log_file | 995 | 6163327550688 | 239712 | 6194298792 | 466196995968 | 8 | 70656 | 8832.0000 | 590 | 560640 | 950.2373 | 631296 | |
mysys/charset | 3 | 233185920 | 2714448 | 77728464 | 216497952 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/SDI | 11 | 675060144 | 0 | 61368912 | 472344576 | 0 | 0 | 0.0000 | 3 | 13499 | 4499.6667 | 13499 | |
sql/binlog | 135 | 203352067776 | 0 | 1506311400 | 22907804832 | 25 | 696 | 27.8400 | 14 | 2975 | 212.5000 | 3671 | |
myisam/kfile | 17 | 103310828544 | 0 | 6077107344 | 99480483696 | 6 | 1296 | 216.0000 | 0 | 0 | 0.0000 | 1296 | |
sql/binlog_index | 38 | 52591469568 | 0 | 1383985944 | 35795482800 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 33 | 28686721008 | 709632 | 869294448 | 17457201168 | 5 | 175 | 35.0000 | 3 | 105 | 35.0000 | 280 | |
mysys/cnf | 5 | 532517568 | 243408 | 106503408 | 514925664 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 14502048 | 719136 | 4833840 | 10322928 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
csv/data | 74 | 969083808 | 0 | 13095720 | 541106544 | 24 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 4 | 367762560 | 0 | 91940640 | 325993536 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/casetest | 15 | 888910176 | 0 | 59260608 | 805959264 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 15 | 2311665312 | 0 | 154110792 | 2226854256 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|