Tweaking SQL on cPanel server
You guys are prob. tired of all the "tweaking sql" posts, but I seem to miss som crucial info. I'm running a Dual Xeon 2.4GHz server with 1GB of RAM and cPanel/WHM. I have about 230 active domains on each server, some very busy sites.
My SQL loads are really bugging me and I would like to tweak the settings so far..
This is my my.cnf file as of today :
[mysqld]
set-variable = max_connections=500
set-variable = connect_timeout=10
set-variable = wait_timeout=20
safe-show-database
Any other tweaking you reccomend? And are there special issues to consider since this is an cPanel server?
