Skip to content
Advertisement

Increasing the caching capability of MySQL

My mysql only caters read requests. I thought, it will be a good idea to make use of the cache completely. I am running MySQL in a VM and that is the only application running inside the VM. I am allocating 2GB memory for that VM. I am using a 64 bit centos on the VM. If you think already it is using the maximum memory that can be used, I can also allocate more to that VM. I am not very good in understanding the mysql settings and finding out the memory footprint used by a process but I am interested in learning how to. Thanks a lot for the help.

These are some information regarding my MYSQL :

JavaScript

This is the output of my ulimit -a

JavaScript

Please let me know if you need more information.

Advertisement

Answer

For basic statistics and recommendations you can start with mysqltuner.pl script. Do not apply recommendations blindly, as it might decrease performance.

MySQLTuner Github page

One-liner to fetch latest version of script and run it:

JavaScript
User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement