PHP + MySQL : Track down what's causing my InnoDB gridlocking

This project was successfully completed by saurabhapandey for $150 USD in 2 days.

Get free quotes for a project like this
Employer working
Completed by:
Project Budget
$30 - $250 USD
Completed In
2 days
Total Bids
Project Description

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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online