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

Set up a FREE Low Memory VPS with WordPress installer

skoral    Wordpress Tutorials     free vps, hosting, wordpress installer

From my notes for how to set up a cheap, low memory Virtual Private Server that can run multiple instances of the WordPress blogging platform.

Why? Shared hosting is okay, but you are limited in your control over the resources on your account. Sharing a server is also sharing resources, and if someone is using their hosting account for videos, large flash or MP3 streaming, you could see a significant drop in performance. Another significant downside is not having the ability to configure the server based on the applications that you want to run.

A Virtual Private Server, or VPS gives you complete control (known as Root access) over your server. The virtual server sits on a physical server, but acts independently of the physical server, and the other VPS instances also residing on the physical box.

The following instructions show you how to set up your own WordPress blog on a low memory VPS for free. You have root access and you wont have to worry about other shared users hogging all the resources of the server. The following instructions will automatically configure the server for WordPress, and you will be able to set up multiple instances of WordPress on the server. The number of instances can vary depending on how much traffic your websites receive.

read more