My plan B was basically what Rick and Claudio said. Check your my.conf file for this variable LONG_QUERY_TIME . That determines how long a query will run before it's considered slow. You may need to adjust that setting, but that will just get rid of the symptom and not the problem at hand. Finding the actual query is the first step.
On Tue, May 8, 2012 at 1:42 PM, nixofortune <nixofort...@gmail.com> wrote: > You might run out of file desciptors. Check your open file limits, open > table limits vars and corresponding syatus values > On 8 May 2012 15:05, "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
