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 | 987 | 5066945683008 | 5133683544 | 30745367136 | 1406014896 | 116345617344 | 4949194050768 | 8 | 70656 | 8832.0000 | 584 | 469504 | 803.9452 | |
innodb/innodb_data_file | 2968 | 2920350097104 | 983945424 | 266339978784 | 215635986192 | 36280910160 | 2668433200752 | 1322 | 26771456 | 20250.7231 | 1300 | 51101696 | 39308.9969 | |
innodb/innodb_temp_file | 90 | 435836061408 | 4842622752 | 42976739520 | 0 | 3402513312 | 432433548096 | 0 | 0 | 0.0000 | 30 | 1146880 | 38229.3333 | |
sql/binlog | 211 | 77876484048 | 369082824 | 22055526240 | 512733408 | 764586240 | 76599164400 | 48 | 788 | 16.4167 | 6 | 928 | 154.6667 | |
sql/binlog_index | 38 | 56662229184 | 1491111072 | 37200763776 | 571225776 | 0 | 56091003408 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 50 | 32787404496 | 655748016 | 2987675328 | 20620159824 | 0 | 12167244672 | 30 | 3077203 | 102573.4333 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 876598272 | 109574784 | 360032640 | 616252032 | 0 | 260346240 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 851156592 | 56743632 | 786105936 | 0 | 0 | 851156592 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 655022016 | 131004192 | 635520336 | 636726288 | 0 | 18295728 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 264019008 | 88006248 | 248145216 | 248145216 | 0 | 15873792 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 4 | 189427392 | 47356848 | 151517520 | 0 | 0 | 189427392 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 40122192 | 13373976 | 25926912 | 0 | 12000384 | 28121808 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
csv/data | 4 | 33392304 | 8347944 | 10098000 | 0 | 0 | 33392304 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|