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 | 1009 | 5720789252580 | 5669761390 | 113226276520 | 1785995590 | 113878170160 | 5605125086830 | 8 | 70656 | 8832.0000 | 588 | 473600 | 805.4422 | |
innodb/innodb_data_file | 3178 | 3841217301420 | 1208689910 | 252528015090 | 297784049410 | 75453283050 | 3467979968960 | 1539 | 30326784 | 19705.5127 | 1148 | 45891584 | 39975.2474 | |
innodb/innodb_temp_file | 121 | 641503500920 | 5301681690 | 33189347830 | 0 | 3037286370 | 638466214550 | 0 | 0 | 0.0000 | 51 | 2146304 | 42084.3922 | |
sql/binlog | 1411 | 115832700980 | 82092495 | 21781384560 | 2480447170 | 911636040 | 112440617770 | 349 | 2286 | 6.5501 | 7 | 1354 | 193.4286 | |
sql/binlog_index | 38 | 54245101970 | 1427502530 | 35029949320 | 662925060 | 0 | 53582176910 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 65 | 38895898640 | 598398355 | 3097123370 | 26211560750 | 0 | 12684337890 | 39 | 3998973 | 102537.7692 | 0 | 0 | 0.0000 | |
myisam/kfile | 16 | 5437526520 | 339845275 | 2421321960 | 5361006180 | 0 | 76520340 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | |
myisam/dfile | 202 | 2937285440 | 14540815 | 2088253530 | 2720778850 | 0 | 216506590 | 176 | 20792 | 118.1364 | 0 | 0 | 0.0000 | |
sql/io_cache | 90 | 1715070990 | 19056150 | 512310720 | 124871710 | 589432080 | 1000767200 | 24 | 1673472 | 69728.0000 | 36 | 1647228 | 45756.3333 | |
csv/metadata | 8 | 1481134820 | 185141720 | 877718690 | 1095504170 | 0 | 385630650 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
csv/data | 6 | 1133807270 | 188967790 | 1024973360 | 0 | 0 | 1133807270 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 799583970 | 53305545 | 730678140 | 0 | 0 | 799583970 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 732623770 | 146524595 | 714789270 | 716009860 | 0 | 16613910 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 423225670 | 141075135 | 398926760 | 398926760 | 0 | 24298910 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 53960360 | 17986610 | 23782160 | 0 | 0 | 53960360 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 49926530 | 16642000 | 39250210 | 0 | 7809550 | 42116980 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|