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 | 8131 | 39428627327232 | 4849173120 | 101935124544 | 1174250352 | 1361229566400 | 38066223510480 | 8 | 70656 | 8832.0000 | 5312 | 9262080 | 1743.6145 | |
innodb/innodb_data_file | 8809 | 18345604975104 | 2082597792 | 247828061712 | 327370259040 | 294001606800 | 17724233109264 | 1505 | 29769728 | 19780.5502 | 5101 | 175489024 | 34402.8669 | |
sql/binlog | 1200 | 2847151465488 | 2372626080 | 95216539968 | 3909287712 | 6274218192 | 2836967959584 | 200 | 1837 | 9.1850 | 201 | 79726 | 396.6468 | |
innodb/innodb_temp_file | 528 | 1769892738768 | 3352069512 | 136008184752 | 0 | 283172310432 | 1486720428336 | 0 | 0 | 0.0000 | 418 | 10780672 | 25791.0813 | |
sql/io_cache | 312 | 79104386064 | 253539528 | 68091256992 | 784172928 | 3935843472 | 74384369664 | 136 | 7231660 | 53173.9706 | 126 | 7231660 | 57394.1270 | |
sql/binlog_index | 38 | 56581699152 | 1488991944 | 35810654352 | 1664281344 | 0 | 54917417808 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 85 | 52895785536 | 622303176 | 4210302096 | 27215602128 | 0 | 25680183408 | 51 | 5217321 | 102300.4118 | 0 | 0 | 0.0000 | |
sql/misc | 21 | 928010160 | 44190960 | 411104496 | 0 | 0 | 928010160 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 922050096 | 184409808 | 905268672 | 906534816 | 0 | 15515280 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 717402576 | 47826768 | 659876976 | 0 | 0 | 717402576 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 364762992 | 91190616 | 234313728 | 0 | 0 | 364762992 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 4 | 300921984 | 75230496 | 278555376 | 0 | 0 | 300921984 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 268474800 | 89491512 | 255227280 | 255227280 | 0 | 13247520 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 14660448 | 4886640 | 11764368 | 0 | 2182224 | 12478224 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|