Mike Perham

On Ruby, software and the Internet

MySQL lock debugging

May 28th, 2008 · No Comments

I submitted my first Rails patch this weekend. We’ve been seeing occasional lock contention, timeout and deadlock in our mysql database but without SHOW INNODB STATUS at the time of the error, it’s difficult to track down the cause of the contention. So I added lock error logging to ActiveRecord’s MysqlAdapter class. It was also good to learn the patch submission process as I’m sure this will be just one of many.

http://rails.lighthouseapp.com/projects/8994/tickets/250-mysql-deadlock-debugging

Tags: Rails

0 responses so far ↓

  • There are no comments yet...Kick things off by filling out the form below.

Leave a Comment