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 | 622 | 3478687445376 | 5592744960 | 60191385408 | 1544254272 | 53467885680 | 3423675305424 | 8 | 70656 | 8832.0000 | 359 | 280064 | 780.1226 | |
innodb/innodb_data_file | 2677 | 2633691187248 | 983821872 | 240706295808 | 219401110896 | 27707491152 | 2386582585200 | 1515 | 29933568 | 19758.1307 | 754 | 33406976 | 44306.3342 | |
innodb/innodb_temp_file | 121 | 444112721712 | 3670352928 | 34396759056 | 0 | 4282666608 | 439830055104 | 0 | 0 | 0.0000 | 57 | 1851392 | 32480.5614 | |
sql/binlog | 1439 | 77430070080 | 53808216 | 24485953008 | 4195075632 | 5098024272 | 68136970176 | 356 | 2020 | 5.6742 | 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 |
|