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 | 1383 | 7939506391344 | 5740785336 | 82936939536 | 1211636448 | 256268988624 | 7682025766272 | 8 | 70656 | 8832.0000 | 852 | 1182720 | 1388.1690 | |
innodb/innodb_data_file | 3066 | 5295714787440 | 1727238744 | 211257660768 | 160318126848 | 82249190496 | 5053147470096 | 1207 | 24887296 | 20619.1350 | 1290 | 50675712 | 39283.4977 | |
innodb/innodb_temp_file | 123 | 538352244144 | 4376847288 | 31770094224 | 0 | 2151433152 | 536200810992 | 0 | 0 | 0.0000 | 52 | 2228224 | 42850.4615 | |
sql/binlog | 793 | 533156895744 | 672328800 | 36380286096 | 6923784912 | 912226656 | 525320884176 | 179 | 1312 | 7.3296 | 35 | 12656 | 361.6000 | |
sql/binlog_index | 38 | 60694074672 | 1597212408 | 38233983216 | 4717910208 | 0 | 55976164464 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 65 | 44744174112 | 688371816 | 3117465648 | 24715956144 | 0 | 20028217968 | 39 | 3990265 | 102314.4872 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1665658368 | 333131568 | 1637255664 | 1639907280 | 0 | 25751088 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 744547584 | 49636488 | 673336224 | 0 | 0 | 744547584 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 9 | 423668784 | 47074104 | 323934864 | 0 | 0 | 423668784 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 286954800 | 95651424 | 260524704 | 260524704 | 0 | 26430096 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 21727728 | 7242576 | 16472544 | 0 | 3945216 | 17782512 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|