Hi Scott, I believe something wrong with innodb parameters. It should be optimum. In your case it might be too high or too low. Take a look at log file size. Please send your show variables and show status data to reach at conclusion.
On Tue, Jan 13, 2009 at 3:35 AM, Scott Edwards <my...@foss.daxal.com> wrote: > 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 > > ------------------------------------------------------- > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com > > -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 500003 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: prajapat...@gmail.com