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 | 128 | 800704400496 | 6255502968 | 48256272240 | 1544949120 | 73792814304 | 725366637072 | 8 | 70656 | 8832.0000 | 69 | 79360 | 1150.1449 | |
innodb/innodb_data_file | 1541 | 744548333760 | 483159072 | 245795673024 | 241766488656 | 12066973248 | 490714871856 | 1186 | 24543232 | 20694.1248 | 176 | 15679488 | 89088.0000 | |
innodb/innodb_temp_file | 90 | 348439042512 | 3871544688 | 24608782704 | 0 | 2144534304 | 346294508208 | 0 | 0 | 0.0000 | 30 | 1146880 | 38229.3333 | |
sql/binlog_index | 38 | 61992295200 | 1631376120 | 34984824336 | 2042821440 | 0 | 59949473760 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 45 | 33936463968 | 754143456 | 15483938976 | 1527840336 | 43776480 | 32364847152 | 8 | 628 | 78.5000 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 30 | 16892707392 | 563090088 | 2654190000 | 11574442176 | 0 | 5318265216 | 18 | 1833960 | 101886.6667 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1635813696 | 327162528 | 1615728048 | 1616957232 | 0 | 18856464 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1163767440 | 77584320 | 1089348480 | 0 | 0 | 1163767440 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 252908832 | 84302856 | 240450144 | 240450144 | 0 | 12458688 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 51047040 | 17015592 | 38546112 | 0 | 9200928 | 41846112 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 5676528 | 5676528 | 5676528 | 0 | 0 | 5676528 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|