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 | 1138 | 6379570867296 | 5605949712 | 111088269072 | 1529397936 | 229123250400 | 6148918218960 | 8 | 70656 | 8832.0000 | 673 | 571904 | 849.7831 | |
innodb/innodb_data_file | 3219 | 4139054170944 | 1285819656 | 223074797616 | 271497622176 | 42037533120 | 3825519015648 | 1330 | 26902528 | 20227.4647 | 1443 | 55164928 | 38229.3333 | |
innodb/innodb_temp_file | 252 | 1286552389056 | 5105366376 | 54622378800 | 0 | 61318886640 | 1225233502416 | 0 | 0 | 0.0000 | 149 | 5914624 | 39695.4631 | |
sql/binlog | 407 | 229010560416 | 562679304 | 23757151440 | 632622672 | 1771242000 | 226606695744 | 92 | 964 | 10.4783 | 16 | 3431 | 214.4375 | |
sql/binlog_index | 38 | 49367233872 | 1299137664 | 25897829760 | 542698992 | 0 | 48824534880 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 55 | 30612479040 | 556590408 | 2116245648 | 16448880096 | 0 | 14163598944 | 33 | 3381351 | 102465.1818 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1626003984 | 325200744 | 1601333712 | 1603475280 | 0 | 22528704 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 965857200 | 64390392 | 901338240 | 0 | 0 | 965857200 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 939061728 | 117382584 | 529160016 | 729897696 | 0 | 209164032 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 295831536 | 73957752 | 255767952 | 0 | 0 | 295831536 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 234933072 | 78310848 | 221570976 | 221570976 | 0 | 13362096 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 8 | 120546624 | 15068328 | 21667008 | 0 | 0 | 120546624 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 47110272 | 15703248 | 36738768 | 0 | 7673952 | 39436320 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|