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 | 3400 | 3474747527856 | 0 | 1021984392 | 236901211536 | 1377 | 27672576 | 20096.2789 | 1426 | 55164928 | 38685.0827 | 82837504 | |
innodb/innodb_temp_file | 278 | 1011192182352 | 0 | 3637381704 | 32375124672 | 0 | 0 | 0.0000 | 183 | 5947392 | 32499.4098 | 5947392 | |
sql/ERRMSG | 55 | 28338965424 | 2743488 | 515253816 | 3267547008 | 33 | 3381096 | 102457.4545 | 0 | 0 | 0.0000 | 3381096 | |
innodb/innodb_log_file | 1883 | 8435428327392 | 224400 | 4479781152 | 134404247472 | 8 | 70656 | 8832.0000 | 1248 | 2324480 | 1862.5641 | 2395136 | |
sql/io_cache | 46 | 2498035584 | 0 | 54305064 | 1657734144 | 16 | 1171216 | 73201.0000 | 20 | 1171216 | 58560.8000 | 2342432 | |
mysys/charset | 3 | 311093376 | 2409264 | 103697616 | 296010528 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 357 | 590891114352 | 0 | 1655156976 | 24624202416 | 66 | 860 | 13.0303 | 43 | 8816 | 205.0233 | 9676 | |
sql/binlog_index | 38 | 52680074832 | 0 | 1386317592 | 33607266000 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 639301344 | 652608 | 79912536 | 210227952 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 5654980320 | 654720 | 1130996064 | 5629308960 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 54112080 | 3019104 | 18037272 | 36891360 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 853561632 | 0 | 56903880 | 793956240 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 6 | 314665296 | 0 | 52444128 | 237231456 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 50111952 | 0 | 12527856 | 28917504 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 4 | 227540544 | 0 | 56885136 | 200920368 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/kfile | 4 | 247708032 | 0 | 61927008 | 168037584 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|