MySQL™: The World’s Most Popular Open Source Database 159 4.0: Query Cache • Improves the speed of queries on read mostly tables. Most (all?) websites has some query that will run many times a second • 3x speed improvement for web sites not uncommon • Does not change semantics at all! • To enable add a line to my.cnf – query_cache_size = 128MB – Or set it on a running server • SET @@GLOBAL.QUERY_CACHE_SIZE=128*1024*102 4 – Turns the Query Cache on with 128 MB memory Copyright 2003 MySQL AB