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 <sac.fai...@gmail.com> wrote: > 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 > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel