MySQL tuning - HW or SW
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?
