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 | 623 | 4522645724784 | 7259463288 | 762569380320 | 1536173232 | 196579541664 | 4324530009888 | 8 | 70656 | 8832.0000 | 370 | 338944 | 916.0649 | |
innodb/innodb_data_file | 2613 | 3753915544896 | 1436630448 | 642420742128 | 966035586384 | 55190241744 | 2732689716768 | 1448 | 28835840 | 19914.2541 | 782 | 34455552 | 44060.8082 | |
innodb/innodb_temp_file | 117 | 577958373696 | 4939815144 | 41034482544 | 0 | 3286402416 | 574671971280 | 0 | 0 | 0.0000 | 48 | 2031616 | 42325.3333 | |
sql/binlog | 251 | 149771341632 | 596698344 | 30321664032 | 1488208656 | 2691899760 | 145591233216 | 56 | 820 | 14.6429 | 10 | 2163 | 216.3000 | |
sql/ERRMSG | 70 | 49130752704 | 701867760 | 6164275920 | 26414873760 | 0 | 22715878944 | 42 | 4302698 | 102445.1905 | 0 | 0 | 0.0000 | |
sql/binlog_index | 38 | 46113163008 | 1213504248 | 24079216656 | 2129482608 | 0 | 43983680400 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 2416487040 | 604121760 | 2357873760 | 2366878800 | 0 | 49608240 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1707207216 | 341441232 | 1691809680 | 1692992400 | 0 | 14214816 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 1429008768 | 178626096 | 552327600 | 1088670000 | 0 | 340338768 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 819016704 | 54601008 | 749450064 | 0 | 0 | 819016704 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 156 | 459173616 | 2943336 | 365110944 | 395436096 | 0 | 63737520 | 100 | 5946 | 59.4600 | 0 | 0 | 0.0000 | |
csv/data | 4 | 358397952 | 89599488 | 273621216 | 0 | 0 | 358397952 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 281665824 | 93888432 | 268739856 | 268739856 | 0 | 12925968 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 47508384 | 15836040 | 37283136 | 0 | 7903632 | 39604752 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 3 | 46419120 | 15473040 | 19296816 | 0 | 0 | 46419120 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|