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 | 333 | 1544514488352 | 4638181416 | 27073727472 | 1212111648 | 26903501856 | 1516398874848 | 8 | 70656 | 8832.0000 | 193 | 178176 | 923.1917 | |
innodb/innodb_data_file | 2008 | 1360272868944 | 677426640 | 195974418288 | 175631767344 | 20304954384 | 1164336147216 | 1231 | 25280512 | 20536.5654 | 543 | 27246592 | 50177.8858 | |
innodb/innodb_temp_file | 233 | 1028296812048 | 4413290904 | 283298567376 | 0 | 494582065296 | 533714746752 | 0 | 0 | 0.0000 | 166 | 3833856 | 23095.5181 | |
sql/binlog_index | 38 | 55336979280 | 1456236144 | 28889379024 | 1524857664 | 0 | 53812121616 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 73 | 37377166464 | 512015856 | 20123708352 | 1079615856 | 20910912 | 36276639696 | 15 | 656 | 43.7333 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 20 | 10823811504 | 541190496 | 2518664016 | 4797884784 | 0 | 6025926720 | 12 | 1218859 | 101571.5833 | 0 | 0 | 0.0000 | |
csv/metadata | 4 | 3376700976 | 844175112 | 1907104848 | 1452371184 | 0 | 1924329792 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 895852848 | 59723400 | 813221904 | 0 | 0 | 895852848 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 423623904 | 84724728 | 405869904 | 407072160 | 0 | 16551744 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 305534064 | 101844600 | 288990768 | 288990768 | 0 | 16543296 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 2 | 18081888 | 9040944 | 11591184 | 0 | 0 | 18081888 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 12032064 | 4010688 | 9714672 | 0 | 1706496 | 10325568 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 4783152 | 4783152 | 4783152 | 0 | 0 | 4783152 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|