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