List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:January 11 2010 10:07am
Subject:Re: mysqld occupies 100$ cpu
View as plain text  
SHOW ENGINE innodb STATUS\G

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

> i try this
> mysql> SHOW ENGINE STATUS\G;
> ERROR 1286 (42000): Unknown table engine 'STATUS'
> ERROR:
> No query specified
>
> after setting the parameter in my.cnf which u provided. it is not showing
>
> mysql> show engine status;
> ERROR 1286 (42000): Unknown table engine 'status'
>
> what i have to do now?
>
>
> Cheers
> Faizal S
> GSM : 9840118673
> Blog: http://oradbapro.blogspot.com
>
>
>   On Mon, Jan 11, 2010 at 3:27 PM, Ananda Kumar <anandkl@stripped> wrote:
>
>> 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