SHOW ENGINE innodb STATUS\G On Mon, Jan 11, 2010 at 3:35 PM, F.A.I.Z.A.L <sac.fai...@gmail.com> wrote:
> 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 >>>>> >>>> >>>> >>> >> >