Mysql uses too much memory? How to configure

skoral    Low Memory VPS     mysql, optimization

So if you are running a low memory webserver ( I use Virpus VM512 plan – 512MB/1024burst | 40GB space | 2IPs | 1000GB bandwidth) and squeezing every ounce of performance is key, you will want to look at the MySQL resource usage. It is no secret that this is one of the biggest hogs on any server, and in fact, a lot of professional webhosters will recommend that you use a separate server dedicated to your MySQL databases.

Problem for us small time guys is that we don’t generally have enough cash to buy large VPS servers to accomplish this landscape. So, in order to slim down your resource usage, go to your SSH client, such as Putty and access your server. It is best practice to login as an unprivileged user and elevate your permissions to Root for certain commands. I will use the original Chunk Server that I learned how to do this on for this example.

read more