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
log-slow-queries = </var/lib/slowqueries.log.
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?
> # Default to using old password format for compatibility with mysql 3.x
> # clients (those using the mysqlclient10 compatibility package).
> 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:
>>> mysqld process taking high cpu utilization (100%), how to reduce the cup
>>> it is running under solaris 8 with 16GB ram and 1 multicore cpu (2 core)
>>> anyone help please?
>>> Faizal S
>>> GSM : 9840118673
>>> Blog: http://oradbapro.blogspot.com