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.fai...@gmail.com> 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 <anan...@gmail.com> 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.fai...@gmail.com>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 >>> >> >> >