I just upgraded my RAM on my server from 4 GB to 16 GB and I'm told that I can utilize this memory to a huge advantage with certain MySQL settings if I get then just right. Do you know of any guides that could walk me through some steps I need to look into? What are the biggest settings I should research?
Where can I find a simple explination of MySQL's cache optimization features....
My current configuration:
query_cache_limit = 1M query_cache_size = 16M