how we can decrease mysql CPU load

--0016361e7efe3d5b3a0482ff1b19
Content-Type: text/plain; charset=ISO-8859-1

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

--0016361e7efe3d5b3a0482ff1b19--

Re: how we can decrease mysql CPU load

--000e0cd287888999ab04830138ca
Content-Type: text/plain; charset=ISO-8859-1

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.
>
> 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

--000e0cd287888999ab04830138ca--