Be careful with the cache size. The query_cache_size define the size of a unique query. Not the size of all the queries.
And the best way to boost a website loading speed is to use a caching system. Because it will reduce the number of queries. MySQL system will never be fast enough even with an huge queries cache.
What caching solution would you recommend for the OP?
I heard that there is a way to optimize/enable MySQL Query cache to boost website loading speed.
It is possible and how to do that?
If you want to Optimize MySQL Query Cache then applying these steps here and its simple.
Login into your MySQL
You will be prompted this, enter your password to continue
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 333
Server version: 5.5.50-38.0 Percona Server (GPL), Release 38.0, Revision b05b24c
Copyright (c) 2009-2016 Percona LLC and/or its affiliates
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
Check current status of Mysql cache
Code:
show variables like 'query_cache_%';
My result is
mysql> show variables like 'query_cache_%';
+------------------------------+---------+
| Variable_name | Value |
+------------------------------+---------+
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 0 |
| query_cache_strip_comments | OFF |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
+------------------------------+---------+
6 rows in set (0.00 sec)
mysql> Ctrl-C -- exit!
How to edit MySql cache
query_cache_size: the size cache (bytes), should not give too big.
query_cache_type: ON or OFF
query_cache_limit: The limitation of a cache query
To configure MySQL Query cache, you need to edit in file /etc/my.cnf (Red Hat) or /etc/mysql/my.cnf (Debian)
Edit according to your sizes
Code:
query_cache_limit = 3M
query_cache_size = 128M
Restart mysql
Check current status of Mysql cache after restarted
Code:
mysql> show status like 'Qc%';
Hope it helps!
