Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: bakedjake
both are normal but when i checked # CPU/Memory/MySQL Usage from WHM so its showing MYSQL in RED
... any idea what the issue is and how do i check if mysql is taking much load so which database is ?
mysqladmin processlist, just don't pipe it's output into wc. you'll see what's running in mysql right now.
as for optimization of mysql and apache: that may fix the issue. unfortunately, you cannot just set "optimize = 1" in some config file, you will have to tune the system and the configuration to fit your special situation and needs.
i have tried the basic optimize of mysql+httpd.
please give me other ways with details and command lines i am new ;) its important for me :S
I typically start with MySQL.
There is a tool called mysqltuner.pl that can give you some initial indications of problems but it is no substitute for having handle on MySQL tuning.
Sysstat is very useful in spotting hardware resource limits and depending on the limits being hit, there are different tuning paths.