Turn on MySQL query cache to speed up query performance


To totally unlock this section you need to Log-in


Login

Many times developers looking for ways to speed up query, in mysql we can enable query cache to speed up query performance. Whenever query cache is enable, it will cache the query in memory and boost query performance.

As we know, speed is always the most important element in developing a website especially for those high traffic database driven website. You can try to turn on query cache to speed up query.

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).

1-  set query_cache_type to 1. (There are 3 possible settings: 0 (disable / off), 1 (enable / on) and 2 (on demand).


To totally unlock this section you need to Log-in


Login

1 thought on “Turn on MySQL query cache to speed up query performance”

Comments are closed.