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 | 1136 | 5926395260544 | 5216897136 | 31253294160 | 1406014896 | 136602698496 | 5788386547152 | 8 | 70656 | 8832.0000 | 674 | 555008 | 823.4540 | |
innodb/innodb_data_file | 3173 | 3495537177264 | 1101650352 | 266339978784 | 215635986192 | 40885655184 | 3239015535888 | 1322 | 26771456 | 20250.7231 | 1460 | 56082432 | 38412.6247 | |
innodb/innodb_temp_file | 90 | 435836061408 | 4842622752 | 42976739520 | 0 | 3402513312 | 432433548096 | 0 | 0 | 0.0000 | 30 | 1146880 | 38229.3333 | |
sql/binlog | 287 | 116686153056 | 406571880 | 25278922416 | 563569248 | 780072480 | 115342511328 | 66 | 860 | 13.0303 | 8 | 1575 | 196.8750 | |
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 | |
myisam/kfile | 4 | 594807312 | 148701696 | 575697408 | 577885440 | 0 | 16921872 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 264019008 | 88006248 | 248145216 | 248145216 | 0 | 15873792 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 80 | 263263440 | 3290760 | 231025344 | 243023616 | 0 | 20239824 | 50 | 2973 | 59.4600 | 0 | 0 | 0.0000 | |
sql/misc | 5 | 201069264 | 40213800 | 151517520 | 0 | 0 | 201069264 | 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 |
|