In your my.conf or configuration file look for an attribute that says "LOG_SLOW_QUERIES " , that should point to the path of your slow query log.
On Tue, May 8, 2012 at 10:19 AM, abhishek jain <abhishek.netj...@gmail.com> wrote: > Hi > Thanks, > Where can i find query log for previous one,or i have to do some config in > my.ini file, please let me know, > Thanks > Abhi > > -----Original Message----- > From: Darryle [mailto:dstepli...@gmail.com] > Sent: 08 May 2012 19:42 > To: abhishek jain > Cc: <mysql@lists.mysql.com> > Subject: Re: One table gets locked by itself > > Chech your query log for queries hitting that tables. Myisam tables dont > have row level locking. There is probably a slow query somewhere. > > Sent from my iPhone > > On May 8, 2012, at 10:04 AM, "abhishek jain" <abhishek.netj...@gmail.com> > wrote: > >> Hi >> >> I am facing a strange problem, from the last few days in one of my >> projects in production, i find that one of my table fails to retrieve >> or insert records, >> >> I think it gets locked somehow, certainly my code doesn't have code to >> do so explicitly. All / rest of tables are fine, only one table creates > problem. >> All is well after i restart mysqld. >> >> >> >> Dont know what to check! >> >> >> >> Details are: >> >> Mysqld version: 5.0.x >> >> Linux - Centos 5 >> >> Table : MyISAM >> >> >> >> Please help me asap, >> >> Thanks, >> >> Abhi >> >> >> > -- ---------------------------------------------- "May the Source be with you." -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
