Hello,
I have migrated my debian server from squeeze to wheezy and mysql to mariadb. The problem is that mysql starts eating up all my RAM and I am not able to run other programs (another app in NodeJS is killed for instance).
I have several services using mysql on it but I am not sure it's even this.
I have tried stopping all other services on the server (apache, varnish, node, prosody, etc.) to be sure it's not used by something else and relaunching mysql
Code:
# free -m
total used free shared buffers cached
Mem: 1981 298 1682 0 0 296
-/+ buffers/cache: 2 1979
Swap: 0 0 0
# service mysql start
Starting MariaDB database server: mysqld . ..
Checking for corrupt, not cleanly closed and upgrade needing tables..
# free -m
total used free shared buffers cached
Mem: 1981 1093 888 0 0 296
-/+ buffers/cache: 796 1184
Swap: 0 0 0
Here there is 888MB free but nothing is left after if other services are running.
Looks like everything goes in the buffers/cache. How can I stop or at least reduce this problematic behaviour ?
/etc/mysql/my.cnf
Thanks