I've got a PHP app that interfaces with MySQL (innodb tables).
Periodically, I find that InnoDB gridlocks. I'm an efficient programmer and I setup the database myself, but I'm not a DBA and I don't have the time to figure out exactly what's causing it.
You are: a DBA proficient enough to get all the info you'll need to figure out what's causing the lock, and what I need to do to fix it ( I can modify the PHP as necessary ).
If you want the job, you have to tell me two things: 1) which tools you'll use to track down the bug 2) tell me one thing about InnoDB that you think other bidders might not know.
I've attached a few dumps of my MYSQL gridlock log. This job is to find and remove all InnoDB gridlocks. I think there should be 5 or less.. if there's more, I'll pay you more in a separate bid.