Contributed by: Tony Monday, March 24 2003 @ 11:56 pm EST
set-variable = query_cache_type=1
set-variable = query_cache_limit=2M
set-variable = query_cache_size=64MB
If you want to see how the cache is helping, from mysql client type "show status;" and look for the QCache_* variables. This took my page loads (from footer of GL page which isn't the best benchmark but works) from .94 seconds down to .54 seconds.