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 | 828 | 5348452140768 | 6459483096 | 125345993520 | 1515307200 | 203510168400 | 5143426665168 | 8 | 70656 | 8832.0000 | 494 | 539648 | 1092.4049 | |
innodb/innodb_data_file | 2773 | 4189215748080 | 1510715976 | 212448793920 | 309997633440 | 69321061920 | 3809897052720 | 1324 | 26804224 | 20244.8822 | 997 | 41074688 | 41198.2828 | |
innodb/innodb_temp_file | 140 | 750023403360 | 5357310024 | 43840240752 | 0 | 4590946800 | 745432456560 | 0 | 0 | 0.0000 | 63 | 2801664 | 44470.8571 | |
sql/binlog | 1127 | 241188534576 | 214009224 | 27133951152 | 2871631488 | 1109355456 | 237207547632 | 273 | 1688 | 6.1832 | 14 | 3590 | 256.4286 | |
sql/binlog_index | 38 | 54171776208 | 1425572808 | 34925882640 | 1522812192 | 0 | 52648964016 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 65 | 44121477312 | 678791784 | 3892895424 | 28909023792 | 0 | 15212453520 | 39 | 3990721 | 102326.1795 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 2849513568 | 356189064 | 1304128320 | 1929643584 | 0 | 919869984 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 12 | 1793905344 | 149492112 | 896368704 | 1740866160 | 0 | 53039184 | 6 | 1261 | 210.1667 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 884434320 | 176886864 | 862491696 | 864065136 | 0 | 20369184 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/data | 4 | 730369728 | 182592432 | 627460416 | 0 | 0 | 730369728 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 711160560 | 47410704 | 652884672 | 0 | 0 | 711160560 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 295128768 | 98376168 | 281382288 | 281382288 | 0 | 13746480 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 6 | 76801824 | 12800304 | 24477024 | 0 | 0 | 76801824 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 41827632 | 13942368 | 32765568 | 0 | 6381936 | 35445696 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
myisam/dfile | 6 | 26127552 | 4354416 | 9081072 | 0 | 0 | 26127552 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|