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