Web Hosting Talk







View Full Version : MySQL tuning - HW or SW


MongoHosting
05-19-2004, 11:25 PM
top shows a boatload (25) of this:

9599 mysql 0 0.0 2.8 /usr/local/mysqld --basedir=/ --datadir=var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/hostingco.com.pid --skip-locking

First off, is this normal? Cpu usage has been pushing the server load up and down all night, some major spikes. Mem is the real nag, been high b/c of these entries like above.

Any clues? There is one very active vB forum on this server.

Should I just up the mem and re assess or is there something I'm missing?

pizzaboy_au
05-20-2004, 03:30 AM
I had the same problem when i updated cpanel to the 9.2 stable release.

Before upgrading cpanel it did not do this.

So i am guessing it maybe the latest implementations of cpanel that have some memory leaks.

John D
05-20-2004, 11:46 AM
Any update on this with cPanel?
Just started noticing this today with a similar problem on mysql

MongoHosting
05-20-2004, 12:36 PM
Standard stuff....we didn't do it. Tune MySQL.