How to check MySQL query caching status on your linux server?

Login to your server as root.

 

On mysql prompt fire the following command:

 

mysql> SHOW VARIABLES LIKE ‘%query_cache%’;

 

This will result the table as follows :

+——————————+———–+
| Variable_name | Value |
+——————————+———–+
| have_query_cache | YES |
| query_cache_limit | 1248376 |
| query_cache_min_res_unit | 3496 |
| query_cache_size | 134576828 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
+——————————+———–+
6 rows in set (0.20 sec)

 

query_cache_type will be set to ON or OFF as required.

  • 58 Користувачі, які знайшли це корисним
Ця відповідь Вам допомогла?

Схожі статті

Can I use my domain name or must I use my IP address as the hostname for FTP?

Using your IP address (192.168.22.22  is an example IP address) is the preferred entry for...

Can you transfer my sites from my current host to my new VPS?

Yes. We will transfer all of your sites free* of charge and will assure that you experience no or...

Do you allow MP3 files? Do you allow streaming of videos?

Yes we do with our special plans at http://hostripples.in/avs-hosting.php

Do you support Cold Fusion?

We do not support or Cold Fusion on our shared hosting servers, however you are more than welcome...