High memory usage by MySQL?
Did some upgrading on my server including cpanel and kernel upgrade and now the memory used by mysql has gone through the roof (maynot be related to the upgrades). It uses around 30% to 40% of 1 GB ram with no large database sites.top mysql usage is as follows:
4828 mysql 0 0.0 3.6 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/viper.sjrhosting.com.pid --skip-locking
4829 mysql 0 0.0 3.6 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/viper.sjrhosting.com.pid --skip-locking
4830 mysql 0 0.0 3.6 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/viper.sjrhosting.com.pid --skip-locking
4831 mysql 0 0.0 3.6 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/viper.sjrhosting.com.pid --skip-locking
4851 mysql 0 0.0 3.6 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/viper.sjrhosting.com.pid --skip-locking
4912 mysql 0 0.0 3.6 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/viper.sjrhosting.com.pid --skip-locking
6290 mysql 0 0.0 3.6 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/viper.sjrhosting.com.pid --skip-locking
6599 mysql 0 0.0 3.6 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/viper.sjrhosting.com.pid --skip-locking
6600 mysql 0 0.0 3.6 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/viper.sjrhosting.com.pid --skip-locking
6609 mysql 0 0.0 3.6 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/viper.sjrhosting.com.pid --skip-locking
6611 mysql 0 0.0 3.6 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/viper.sjrhosting.com.pid --skip-locking
6612 mysql 0 0.0 3.6 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/viper.sjrhosting.com.pid --skip-locking
6616 mysql 0 0.0 3.6 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/viper.sjrhosting.com.pid --skip-locking
6617 mysql 0 0.0 3.6 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/viper.sjrhosting.com.pid --skip-locking
6618 mysql 0 0.0 3.6 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/viper.sjrhosting.com.pid --skip-locking
6619 mysql 0 0.0 3.6 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/viper.sjrhosting.com.pid --skip-locking
Anyone know where I would look to see what is causing this high memory? There are no sites that should cause this amount of memory unless one has a problem that I cant find. MySQL is all optimized so that is not the issue. Any ideas?