Reduce MYSQL memory usage
I’m using Postgresql as the main database for my website. I’ve reached this decision after a lot of problems with MYSQL. That however doesn’t mean that MySQL is totally bad, its just not the correct product for my needs. People who are not very savvy or do not intend to research or read a lot in the docs of that database, should use MySQL first. It is much simpler to install and admin.
Although I switched to postgres for good, some services on my website are still running on MySQL, namely twatch for stats, and Wordpress blog. I will be moving Wordpress to postgres in the near future, however, I will still need to continue using twatch for a while until I implement something close that works with my website on postgres.
The problems I have been having lately is huge memory consumption with MySQL. Actually, it used to eat around 100-150MBytes of my servers memory. I’m running this website on an Athlon MP, 1.1GHz, 700MBytes RAM machine. MySQL was basically choking postgres, and I needed that memory to enhance postgres’s cache.
I played with my.cnf configuration file a lot and nothing seemed to resolve this problem. yesterday, I noticed a line skip-innodb somewhere in the file, and a comment beside it You might want to disable InnoDB to shrink the mysqld process by circa 100MB. That line did the trick. MySQL is now using around 10 megs of memory.
I checked both twatch and Wordpress. Both of them seem to work fine after this change, and they are not slower.
Technorati Tags: mysql, postgres, postgresql, memory, usage, reduce, minimize, linux, debian, ubuntu, inno, innodb, database, server
