tony spencer

One of my servers is receiving a large number of full text queries so I’ve been thinking of ways to minimize the load. The current CPU load is quite low but for future scalability it makes sense to whip up a caching system. Fortunately I read the mySql manual before inventing my own wheel:

When in use, the query cache stores the text of a SELECT query together with the corresponding result that was sent to the client. If the identical query is received later, the server retrieves the results from the query cache rather than parsing and executing the query again.

C’est facile!

query_cache_size = 1000000

query_cache_type = 1

From: MySQL Query Cache