Mysql process taking all the memory

centos5MySQL

When I checked my process on VPS, I can see 18 instance of mysql running. What could be wrong? 

1780 mysql     15   0  876M  142M  6744 S  0.0  8.1  0:00.51 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid
 1782 mysql     19   0  876M  142M  6744 S  0.0  8.1  0:00.00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid
 1783 mysql     18   0  876M  142M  6744 S  0.0  8.1  0:00.00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid
 1784 mysql     18   0  876M  142M  6744 S  0.0  8.1  0:00.00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid
 1785 mysql     15   0  876M  142M  6744 S  0.0  8.1  0:00.00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid
 1788 mysql     18   0  876M  142M  6744 S  0.0  8.1  0:01.65 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid
 1789 mysql     18   0  876M  142M  6744 S  0.0  8.1  0:01.36 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid
 1790 mysql     18   0  876M  142M  6744 S  0.0  8.1  0:00.22 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid
 1791 mysql     15   0  876M  142M  6744 S  0.0  8.1  0:00.02 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid
 1792 mysql     15   0  876M  142M  6744 S  0.0  8.1  0:00.04 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid
 1796 mysql     18   0  876M  142M  6744 S  0.0  8.1  0:01.77 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid
 3283 mysql     18   0  876M  142M  6744 S  0.0  8.1  0:02.01 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid
 3284 mysql     18   0  876M  142M  6744 S  0.0  8.1  0:01.75 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid
29973 mysql     18   0  876M  142M  6744 S  0.0  8.1  0:00.45 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid
29974 mysql     17   0  876M  142M  6744 S  0.0  8.1  0:01.50 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid
29976 mysql     17   0  876M  142M  6744 S  0.0  8.1  0:00.75 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid
29978 mysql     18   0  876M  142M  6744 S  0.0  8.1  0:00.57 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid

Best Answer

Nothing is happening.

MySQL has a bunch of processes and is waiting for something to do. Notice how the columns are 0.0% CPU and 8.1% memory. That 8.1% is just the shared about MySQL needs to run, but it isn't really doing anything since it has zero percent CPU usage.

This can also be confirmed by the output of SHOW PROCESSLIST, which shows no-one is connected (so no queries are being run).

Related Topic