mysql

cbtshare · 12-06-2010, 08:12 PM

my mysql is hogging my server resources andd sometimes crash it.Is there a way to increase memory it uses?

I get this message alot..

Time: Mon Dec 6 08:21:33 2010 -0600
Account: mysql
Resource: Virtual Memory Size
Exceeded: 280 > 200 (MB)
Executable: /usr/libexec/mysqld
Command Line: /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql/ --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/lib/mysql/mysql.sock
PID: 2451
Killed: No

AlucardZero · 12-06-2010, 08:39 PM

I'm not familiar with messages of that type, but a quick Google of some of the strings leads me to believe it's from something called "ConfigServer Security & Firewall" which might be integrated into your cPanel install. I would poke around in there.

More Googling leads me to believe you should increase the value of PT_USERMEM in /etc/csf/csf.conf.

cbtshare · 12-06-2010, 11:55 PM

yea, it was the csf firewall, monitoring the processes of the server.I optimized mysql server config and now watching stuff....

thanks for replying