After installing MySQL 5.5 under Debian 6 eats more than 300 MB of memory

Question

MySQL

There is a VPS - 1GHz percent, 512MB memory, 20GB hard, OpenVZ virtualization technology, 32-bit Debian 6 operating system. Burst.net hoster

Installed nginx, php-fpm, memcache without problems from dotdeb.org packages .

After a typical installation ( apt-get install mysql-server mysql-client ) of MySQL 5.5 under Debian 6, more than 300 MB of memory is consumed, in top , the mysql process shows a memory consumption of 6.5%. If you kill the MySQL process, then the memory is freed. It's the first time I've had this, and I usually don't have any problems.

Tell me how to reduce memory consumption for MySQL? Where to look?

Answer 1

The reason is OpenVZ and how memory is calculated in it: habrahabr.ru/blogs/hosting/53236/.

Answer 2

If you don't need innoDB, you can disable it.

Answer 3

Today I just dealt with this problem on one VPS.
I really love Ubuntu and Debian, but the client had centOS selected,
and after starting the muscle, there were 20 descendants ...
this helped me, from the bourgeois site
cp /etc/my.cnf /etc/my .cnf.bak
cp /usr/share/mysql/my-small.cnf /etc/my.cnf
There you go, we have copied the small configuration for mysql. Now, we need to tweak our my.cnf configuration because we need to skip innodb. You could use vi to edit the file.
vi /etc/my.cnf
We need to add these two following line under [mysqld]
default-storage-engine = myisam
skip-innodb
and this helped 2 descendants work, nginx and apache get along at 300 meters