SELECT * FROM `x$io_global_by_wait_by_latency`
|
event_name | total | total_latency | avg_latency | max_latency | read_latency | write_latency | misc_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_log_file | 2030 | 8373050568960 | 4124655216 | 92385013248 | 1121824176 | 256950717408 | 8114978027376 | 8 | 70656 | 8832.0000 | 1374 | 2438144 | 1774.4862 | |
innodb/innodb_data_file | 3526 | 3538190631360 | 1003457136 | 240115417344 | 217877384208 | 53239316592 | 3267073930560 | 1327 | 26853376 | 20236.1537 | 1567 | 59588608 | 38027.1908 | |
innodb/innodb_temp_file | 146 | 680783028816 | 4662897360 | 57687814800 | 0 | 3088543392 | 677694485424 | 0 | 0 | 0.0000 | 69 | 2899968 | 42028.5217 | |
sql/binlog | 571 | 587628026832 | 1029120840 | 29822294304 | 826034352 | 1324751472 | 585477241008 | 119 | 1072 | 9.0084 | 44 | 8744 | 198.7273 | |
sql/binlog_index | 38 | 50958309600 | 1341008064 | 35728366608 | 199711776 | 0 | 50758597824 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 35 | 19306188000 | 551605296 | 3039728208 | 10038257856 | 0 | 9267930144 | 21 | 2142191 | 102009.0952 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 3315075456 | 414384432 | 2833897968 | 3064816656 | 0 | 250258800 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 4 | 796073520 | 199018248 | 773569104 | 0 | 0 | 796073520 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 733906800 | 48927120 | 657744912 | 0 | 0 | 733906800 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 522637104 | 104527368 | 498377616 | 499755168 | 0 | 22881936 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 367472160 | 122490720 | 351983280 | 351983280 | 0 | 15488880 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 360616080 | 90153888 | 258216816 | 0 | 0 | 360616080 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 280035360 | 70008840 | 235224000 | 0 | 0 | 280035360 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 6 | 65183184 | 10863864 | 13703184 | 0 | 0 | 65183184 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 18421392 | 6140376 | 14079648 | 0 | 3105168 | 15316224 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|