List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:January 11 2010 9:57am
Subject:Re: mysqld occupies 100$ cpu
View as plain text  
looks like u have not setup slow query log parameter.

If this is a non-production db, shut it down and add this parameter, unser
[mysqld]

log-slow-queries = </var/lib/slowqueries.log.

Or execute
SHOW ENGINE  STATUS\G;
You will get to know what all activities are going on ur db and check if
there is any IO contention happening




On Mon, Jan 11, 2010 at 2:47 PM, F.A.I.Z.A.L <sac.faizal@stripped> wrote:

> Hi Kumar,
>
> thanks for your reply.. here is my my.cnf file. i don't see anything here.
> what is this slowquery.log?, where it will be?
> ---
> [mysqld]
> datadir=/var/lib/mysql
> socket=/var/lib/mysql/mysql.sock
> # Default to using old password format for compatibility with mysql 3.x
> # clients (those using the mysqlclient10 compatibility package).
> old_passwords=1
>
> [mysql.server]
> user=mysql
> basedir=/var/lib
>
> [mysqld_safe]
> log-error=/var/log/mysqld.log
> pid-file=/var/run/mysqld/mysqld.pid
> -----
>
> Cheers
> Faizal S
> GSM : 9840118673
> Blog: http://oradbapro.blogspot.com
>
>
>   On Mon, Jan 11, 2010 at 2:17 PM, Ananda Kumar <anandkl@stripped> wrote:
>
>> what is your my.cnf setting.
>> Also did u check slowquery.log for any sql's not using index or not using
>> the right index.
>>
>>
>>
>> On Mon, Jan 11, 2010 at 1:21 PM, F.A.I.Z.A.L <sac.faizal@stripped>wrote:
>>
>>> Hi
>>>
>>> mysqld process taking high cpu utilization (100%), how to reduce the cup
>>> utilization
>>>
>>> it is running under solaris 8 with 16GB ram and 1 multicore cpu (2 core)
>>>
>>> anyone help please?
>>>
>>> Cheers
>>> Faizal S
>>> GSM : 9840118673
>>> Blog: http://oradbapro.blogspot.com
>>>
>>
>>
>

Thread
mysqld occupies 100$ cpuF.A.I.Z.A.L11 Jan
  • Re: mysqld occupies 100$ cpuAnanda Kumar11 Jan
    • Re: mysqld occupies 100$ cpuF.A.I.Z.A.L11 Jan
      • Re: mysqld occupies 100$ cpuAnanda Kumar11 Jan
        • Re: mysqld occupies 100$ cpuF.A.I.Z.A.L11 Jan
          • Re: mysqld occupies 100$ cpuAnanda Kumar11 Jan
  • RE: mysqld occupies 100$ cpuJerry Schwartz11 Jan