Re: Strange InnoDB Deadlock Behavior

2007-01-18 Thread Juan Eduardo Moreno
Jason, I assume that your principal databases are INNODB databases. Regards On 1/17/07, Jason J. W. Williams <[EMAIL PROTECTED]> wrote: Hi Juan, Just wanted to touchbase and see if you had any suggestions based on the my.cnf and machine config. Thank you in advance. Best Regards, Jason

Re: Strange InnoDB Deadlock Behavior

2007-01-16 Thread Jason J. W. Williams
Hi Juan, Just wanted to touchbase and see if you had any suggestions based on the my.cnf and machine config. Thank you in advance. Best Regards, Jason On 1/15/07, Juan Eduardo Moreno <[EMAIL PROTECTED]> wrote: Jason, Send me a my.cnf in order to view your configuration ( using innodb storage

Strange InnoDB Deadlock Behavior

2007-01-15 Thread Jason J. W. Williams
Hi Juan, Could the update log purging lagging behind due to a high UPDATE load cause this behavior? I was reading up here: http://dev.mysql.com/doc/refman/5.0/en/innodb-multi-versioning.html If so, would using innodb_max_purge_lag help? Thank you again so much. Best Regards, Jason -- MySQL Gen

Strange InnoDB Deadlock Behavior

2007-01-15 Thread Jason J. W. Williams
Hello All, I have an issue that is seemingly hard to troubleshoot. Every so often transactions/queries on InnoDB tables will stack up such that all the queries appear to be waiting for others to execute. The problem is that the others never finish executing. If you try to kill the "Updating" thre