Turn on MySQL query cache to speed up query performance

[DMA2Superman]

I know there are different way to speed up performance of web based application, but i want some information on query cache of database to speed up web application.

[Zecho]

Query cache is great for certain applications, typically simple applications deployed on limited scale or applications dealing with small data sets. query_cache_size – This is the size of the cache in bytes. Setting this value to 0 will effectively disable caching. When using a standard MySQL binary, this value is always YES, even if query caching is disabled.The query cache is also controlled by the setting of the query_cache_type variable.

[Walby]

To speed up query, enable the MySQL query cache, before that you need to set few variables in mysql configuration file (usually is my.cnf or my.ini). It can be seen worse if your query cache size is in GigabytesQuery caching can be enabled by setting the server variables query_cache_type, query_cache_size, and query_cache_limit. If any of these three variables is set to 0, query caching will be disabled.

[Aberto]

To enable mysql query cache write the following command in to cache.cnf file :

query_cache_size = 268435456
query_cache_type=1
query_cache_limit=1048576