magento mysql

Improving Magento Performance -Status of Query Caching – Part 3

Here we’ll check the Magento MySQL server regarding query caching status of the host – either enabled or disabled. For checking the same, please put on the following commands in Magento MySQL server command prompt:

Magento MySQL-Status of Query Caching

mysql> SHOW VARIABLES LIKE ‘have_query_cache’;

Variable_name Value
have_query_cache YES

As we can see the value is always YES for the Standard Magento MySQL binary regardless of the query caching status. Either enable or disabled.

Now enjoy technical support in different Mage issues absolutely free with the Mage hosting plans. Hence many more to come. So, keep an eye on our regular special offer updates.

Just put on the following command line into the Magento MySQL server command prompt. So, we can verify the query cache is really operational or not.

mysql> SHOW VARIABLES LIKE ‘query_cache_size’;

Variable_name Value
query_cache_size 67108864

1 row in set (0.00 sec)

Now we can see enough amount of memory which is 64 MB available for our query cache size. Next following is a server and the MySQL query cache disabled. Here notice the value is also set to zero.

mysql> SHOW VARIABLES LIKE ‘query_cache_size’;

Variable_name Value
query_cache_size 0

1 row in set (0.00 sec)

Hence making changes to this value has little importance if you’ve got root access. Further in the [mysqld] section add the following line in my.conf file. Next restart Magento MySQL server.


In sum, we can easily improve our Mage store performance by using query caching method. Also it is the most efficient and easy way to improve Mage site performance. But while configuring Magento MySQL server it is advised to consider few other parameters such as:




However, Aspiration Hosting’s tech team highly recommends you to reconsider these parameters before making any changes regarding query cache configuration. For more support & information contact our technical team. Also enjoy discount up to 28% in your first month bill with Aspiration Hosting in the month of December, 2017. Happy Holidays!

Here I would like to wrap up the topic in this note that query caching might be your ultimate weapon for your Mage store. Hence it can improve both speed and performance at same time in few minutes.

Currently viewing : Part 03|Part 02|Part 01