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 | 4757 | 7468141551552 | 0 | 1569926688 | 223256767536 | 1559 | 30654464 | 19662.9019 | 2194 | 77971456 | 35538.4941 | 108625920 | |
sql/io_cache | 585 | 76025749536 | 0 | 129958488 | 57086390064 | 260 | 14196870 | 54603.3462 | 245 | 14196870 | 57946.4082 | 28393740 | |
innodb/innodb_temp_file | 710 | 1009200585888 | 0 | 1421409264 | 56986880544 | 0 | 0 | 0.0000 | 619 | 12828672 | 20724.8336 | 12828672 | |
sql/ERRMSG | 70 | 45755767200 | 3130512 | 653653704 | 3204840144 | 42 | 4294869 | 102258.7857 | 0 | 0 | 0.0000 | 4294869 | |
innodb/innodb_log_file | 2780 | 14650756957056 | 233376 | 5270056440 | 919739915952 | 8 | 70656 | 8832.0000 | 1797 | 2880000 | 1602.6711 | 2950656 | |
sql/binlog | 791 | 1252466907120 | 0 | 1583396760 | 26263278624 | 152 | 1204 | 7.9211 | 88 | 22805 | 259.1477 | 24009 | |
mysys/charset | 3 | 183878112 | 2346432 | 61292616 | 168486912 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog_index | 38 | 48583662336 | 0 | 1278517416 | 24830393808 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 993954720 | 230208 | 198790944 | 974273520 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 914356608 | 1790448 | 228589152 | 552098976 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 65127744 | 3475296 | 21709248 | 39290064 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1047102144 | 0 | 69806616 | 983417952 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 22 | 2182124208 | 0 | 99187440 | 1708138080 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 582596784 | 0 | 291298392 | 548523888 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 4 | 30992544 | 0 | 7748136 | 12073776 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/kfile | 4 | 269514432 | 0 | 67378608 | 198157872 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|