List:General Discussion« Previous MessageNext Message »
From:Scott Edwards Date:January 12 2009 10:05pm
Subject:stuck commits
View as plain text  
All too frequently, I see commits stuck in this database.  What can I do to 
speed that up? Or, abort if it takes more than 40 seconds?  This query here 
for example appears to take 443 seconds so far.

From mysqladmin processlist:

Id    | User | Host | db | Command |Time | State | Info
14010 | amavis | mx:53008 | amavis | Query   | 443  | | commit

mysqld  Ver 5.0.32-Debian_7etch8-log for pc-linux-gnu on x86_64 (Debian etch 
distribution)

I recompiled it once, but the debug symbols are still missing.  The build 
transcript didn't include -g during compile.  I'm looking into redoing that 
now.

Thanks in advance,


Scott Edwards

-------------------------------------------------------
Thread
stuck commitsScott Edwards12 Jan
  • Re: stuck commitsBaron Schwartz13 Jan
  • Re: stuck commitsKrishna Chandra Prajapati13 Jan
    • Re: stuck commitsScott Edwards14 Jan
      • Re: stuck commitsKrishna Chandra Prajapati15 Jan