List:General Discussion« Previous MessageNext Message »
From:F.A.I.Z.A.L Date:January 11 2010 10:05am
Subject:Re: mysqld occupies 100$ cpu
View as plain text  
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