Tweaking For Less vs Tweaking For Max
The fun of a tiny vps is tweaking everything to use less resource, just do the bare minimum, but at the same time, do what you want it to do.
This is the opposite of running a “normal” server, tuning it to growth, have all features available, and readying it for years of services.
Welcome to a tiny world.
DB tuning is a big topic, a profession, a complicated process … well, if you are doing performance tuning. Tuning MySQL to use less memory, turn out to be pretty simple.
A simple googling on this topic will give you lot of pages, either blog or forum post, with a common trick
Add following in /etc/mysql/my.cnf [mysqld] section
This works … before MySQL 5.1. Turn out that the option skip-bdb was deprecated in 5.0, and removed completely from 5.1. If it is added to 5.1 my.cnf, mysqld won’t even start. For 5.1 and later (5.5.28 as of today), only use skip-innodb.
So how much memory are we saving with skip-innodb? Lets test.
Memory usage with no mysql running
Memory usage with mysql running, not using skip-innodb
Memory usage with mysql running, using skip-innodb
This option is definitely staying!!