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 | 1631 | 9054555797760 | 5551536144 | 429268256208 | 1762230096 | 235254025776 | 8817539541888 | 8 | 70656 | 8832.0000 | 1013 | 1306112 | 1289.3504 | |
innodb/innodb_data_file | 3538 | 6560407758432 | 1854270000 | 454573190016 | 777289242048 | 113206546464 | 5669911969920 | 1415 | 28295168 | 19996.5852 | 1436 | 55492608 | 38643.8774 | |
innodb/innodb_temp_file | 125 | 603062627904 | 4824501000 | 34405054992 | 0 | 3475334016 | 599587293888 | 0 | 0 | 0.0000 | 55 | 2211840 | 40215.2727 | |
sql/binlog | 471 | 579811674288 | 1231022496 | 42609191328 | 2900828304 | 3011923728 | 573898922256 | 96 | 980 | 10.2083 | 40 | 12826 | 320.6500 | |
sql/binlog_index | 38 | 46739872080 | 1229996592 | 28217923008 | 726771408 | 0 | 46013100672 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 45 | 45689910288 | 1015331328 | 6313648176 | 24900718656 | 0 | 20789191632 | 27 | 2771439 | 102645.8889 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 2378109888 | 594527472 | 2279011152 | 2287963920 | 0 | 90145968 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1348322976 | 269664384 | 1329540960 | 1331123904 | 0 | 17199072 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 846022848 | 56401488 | 780393504 | 0 | 0 | 846022848 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 260205264 | 86735088 | 245562240 | 245562240 | 0 | 14643024 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 6 | 112984080 | 18830592 | 27231600 | 0 | 0 | 112984080 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 41869872 | 13956624 | 32558592 | 0 | 6942144 | 34927728 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
myisam/dfile | 2 | 33815760 | 16907880 | 32606112 | 0 | 0 | 33815760 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|