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 | 819 | 5367048297072 | 6553172472 | 398995159728 | 1355344848 | 263677079952 | 5102015872272 | 8 | 70656 | 8832.0000 | 493 | 512512 | 1039.5781 | |
innodb/innodb_data_file | 2650 | 3875112225600 | 1462306296 | 524990971824 | 1523723427600 | 45239203152 | 2306149594848 | 1323 | 26787840 | 20247.8005 | 1030 | 43073536 | 41818.9670 | |
innodb/innodb_temp_file | 231 | 758327055552 | 3282800928 | 70915918128 | 0 | 2837134608 | 755489920944 | 0 | 0 | 0.0000 | 151 | 4440064 | 29404.3974 | |
sql/ERRMSG | 55 | 126065054016 | 2292091824 | 67664871120 | 90920891952 | 0 | 35144162064 | 33 | 3376937 | 102331.4242 | 0 | 0 | 0.0000 | |
sql/binlog | 99 | 97480711680 | 984653472 | 17220794448 | 1669169568 | 1903506000 | 93908036112 | 19 | 672 | 35.3684 | 8 | 1970 | 246.2500 | |
sql/binlog_index | 38 | 71333736144 | 1877203416 | 36688196160 | 3213065328 | 0 | 68120670816 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 310 | 40499827104 | 130644360 | 16847941968 | 940643088 | 4199660784 | 35359523232 | 132 | 7404642 | 56095.7727 | 128 | 7404642 | 57848.7656 | |
csv/metadata | 4 | 10543248672 | 2635812168 | 6359604240 | 4166058864 | 0 | 6377189808 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 2131779936 | 426355776 | 2108416464 | 2110432368 | 0 | 21347568 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/data | 2 | 1307380800 | 653690400 | 1263702528 | 0 | 0 | 1307380800 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1264089552 | 84272496 | 1191444672 | 0 | 0 | 1264089552 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 197447712 | 65815728 | 185371824 | 185371824 | 0 | 12075888 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 27559488 | 9186408 | 15838416 | 0 | 10519872 | 17039616 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 2 | 18519072 | 9259536 | 13305072 | 0 | 0 | 18519072 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|