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 | 615 | 3429636759120 | 5576644920 | 60191385408 | 1544254272 | 53394189552 | 3374698315296 | 8 | 70656 | 8832.0000 | 355 | 278016 | 783.1437 | |
innodb/innodb_data_file | 2650 | 2582546837904 | 974545968 | 240706295808 | 217435844736 | 27398890992 | 2337712102176 | 1506 | 29786112 | 19778.2948 | 749 | 33275904 | 44427.1081 | |
innodb/innodb_temp_file | 121 | 444112721712 | 3670352928 | 34396759056 | 0 | 4282666608 | 439830055104 | 0 | 0 | 0.0000 | 57 | 1851392 | 32480.5614 | |
sql/binlog | 1435 | 77411986080 | 53945496 | 24485953008 | 4192527504 | 5098024272 | 68121434304 | 355 | 2016 | 5.6789 | 4 | 358 | 89.5000 | |
sql/binlog_index | 38 | 54232770240 | 1427177928 | 36008080416 | 699509184 | 0 | 53533261056 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 60 | 38735699904 | 645594840 | 3137078208 | 24736306848 | 0 | 13999393056 | 36 | 3694919 | 102636.6389 | 0 | 0 | 0.0000 | |
myisam/kfile | 16 | 2410369632 | 150647904 | 1006078128 | 2355268608 | 0 | 55101024 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | |
myisam/dfile | 35 | 1555104672 | 44431464 | 1510759008 | 1516715904 | 0 | 38388768 | 25 | 975 | 39.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 74 | 1487056032 | 20095152 | 301007520 | 216750336 | 673007808 | 597297888 | 32 | 1855800 | 57993.7500 | 32 | 1855800 | 57993.7500 | |
sql/casetest | 15 | 942002160 | 62800056 | 862294224 | 0 | 0 | 942002160 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 550347072 | 110069256 | 530644752 | 531799488 | 0 | 18547584 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 285360240 | 95119992 | 253211904 | 253211904 | 0 | 32148336 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 2 | 33031152 | 16515576 | 28030992 | 0 | 0 | 33031152 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 16789872 | 5596536 | 13792416 | 0 | 2138400 | 14651472 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|