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 | 3073 | 3098915823696 | 0 | 1008433272 | 257144420016 | 1594 | 31227904 | 19590.9059 | 950 | 39337984 | 41408.4042 | 70565888 | |
sql/ERRMSG | 90 | 44516796192 | 2986368 | 494630928 | 5482193904 | 54 | 5521354 | 102247.2963 | 0 | 0 | 0.0000 | 5521354 | |
sql/io_cache | 120 | 3807446544 | 0 | 31728576 | 636047280 | 32 | 2231296 | 69728.0000 | 48 | 2196304 | 45756.3333 | 4427600 | |
innodb/innodb_temp_file | 155 | 688098318336 | 0 | 4439343744 | 33627060720 | 0 | 0 | 0.0000 | 76 | 3145728 | 41391.1579 | 3145728 | |
innodb/innodb_log_file | 913 | 5519993157360 | 245520 | 6045994680 | 401036126832 | 8 | 70656 | 8832.0000 | 531 | 415232 | 781.9812 | 485888 | |
mysys/charset | 3 | 311044800 | 3703920 | 103681512 | 288396240 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/dfile | 74 | 1264718400 | 185856 | 17090568 | 751670304 | 51 | 2017 | 39.5490 | 0 | 0 | 0.0000 | 2017 | |
myisam/kfile | 16 | 1604565600 | 513216 | 100285152 | 589410096 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | 1703 | |
sql/binlog | 698 | 46670245776 | 0 | 66862752 | 20608325760 | 172 | 1431 | 8.3198 | 3 | 156 | 52.0000 | 1587 | |
sql/binlog_index | 38 | 57556736160 | 0 | 1514650896 | 38714797968 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 2332897248 | 812592 | 291612024 | 1676556816 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 658543248 | 255024 | 131708544 | 639557424 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 56113728 | 2895024 | 18704400 | 34063392 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1757603760 | 0 | 117173496 | 1654189152 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 12440736 | 0 | 12440736 | 12440736 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 51520656 | 0 | 12880032 | 28599648 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|