How do I set query cache under MySQL running under UNIX / Linux / BSD or Windows operating systems?
MySQL has a great feature called "Query Cache". It allows you to improve MySQL server performance. It is quite useful to speed up third party application and/or low load applications.
Enabling MySQL Query Cache
Edit MySQL config file such as /etc/my.cnf:
# vi /etc/my.cnf
Append /modify config directives as follows:
query_cache_size = 268435456 query_cache_type=1 query_cache_limit=1048576
In above example the maximum size of individual query results that can be cached set to 1048576 using query_cache_limit system variable. Memory size in defined in Kb. The query_cache_size defines the amount of memory allocated for caching query results. The default value is 0, which disables the query cache. The allowable values are multiples of 1024; other values are rounded down to the nearest multiple. Once done restart mysql server. Please note that this is not distributed caching solution.
Distributed MySQL Caching Solution
Memcached is one of most popular distributed caching system. This software is highly recommend if you got busy website or mysql server. See how to install and configure Memcached caching under RHEL / CentOS /operating systems.
- 30 Handy Bash Shell Aliases For Linux / Unix / Mac OS X
- Top 30 Nmap Command Examples For Sys/Network Admins
- 25 PHP Security Best Practices For Sys Admins
- 20 Linux System Monitoring Tools Every SysAdmin Should Know
- 20 Linux Server Hardening Security Tips
- Linux: 20 Iptables Examples For New SysAdmins
- Top 20 OpenSSH Server Best Security Practices
- Top 20 Nginx WebServer Best Security Practices
- 20 Examples: Make Sure Unix / Linux Configuration Files Are Free From Syntax Errors
- 15 Greatest Open Source Terminal Applications Of 2012
- My 10 UNIX Command Line Mistakes
- Top 10 Open Source Web-Based Project Management Software
- Top 5 Email Client For Linux, Mac OS X, and Windows Users
- The Novice Guide To Buying A Linux Laptop