Set up a local firewall that denies connections to TCP port 3306. Your load
will drop like a stone.
Alternatively, find out what's happening on the server, and start optimizing
from there.
On Tue, Mar 30, 2010 at 8:54 AM, F.A.I.Z.A.L wrote:
> Hi All
>
> please help me to reduce mysqld cpu load.
Hi All
please help me to reduce mysqld cpu load.
mysql 4.1 running on solaris 10 with 4gb ram. front end apps is php (apache
server). everyday mysql reach about 100% cpu load. can one help to fix this
issue...
thank you.
Cheers
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
