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 | 495 | 2926488032688 | 5912096784 | 69535840704 | 1544949120 | 118560484944 | 2806382598624 | 8 | 70656 | 8832.0000 | 290 | 326144 | 1124.6345 | |
innodb/innodb_data_file | 2431 | 2740801147920 | 1127437608 | 245795673024 | 545072754336 | 38391518352 | 2157336875232 | 1464 | 29097984 | 19875.6721 | 633 | 29868032 | 47184.8847 | |
innodb/innodb_temp_file | 90 | 348439042512 | 3871544688 | 24608782704 | 0 | 2144534304 | 346294508208 | 0 | 0 | 0.0000 | 30 | 1146880 | 38229.3333 | |
sql/binlog | 129 | 131855843328 | 1022138304 | 48126104400 | 1582482000 | 6477108000 | 123796253328 | 27 | 704 | 26.0741 | 7 | 1322 | 188.8571 | |
sql/binlog_index | 38 | 61992295200 | 1631376120 | 34984824336 | 2042821440 | 0 | 59949473760 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 45 | 28203515472 | 626744712 | 3179963424 | 17361482688 | 0 | 10842032784 | 27 | 2758133 | 102153.0741 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1635813696 | 327162528 | 1615728048 | 1616957232 | 0 | 18856464 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 1522012800 | 190251600 | 581744064 | 1079282160 | 0 | 442730640 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1163767440 | 77584320 | 1089348480 | 0 | 0 | 1163767440 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 599560368 | 149889960 | 582401424 | 584351856 | 0 | 15208512 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
sql/misc | 4 | 275290224 | 68822424 | 219130032 | 0 | 0 | 275290224 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 252908832 | 84302856 | 240450144 | 240450144 | 0 | 12458688 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 13 | 188570448 | 14505216 | 82334736 | 25598496 | 0 | 162971952 | 4 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 51047040 | 17015592 | 38546112 | 0 | 9200928 | 41846112 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
myisam/dfile | 2 | 9516672 | 4758336 | 9003456 | 0 | 0 | 9516672 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|