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

Closed

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.

Skills: Database Administration, MySQL, PHP

See more: mysql gridlock, php fix bug, what to do if you can't find a job, what job to get, what c++ programmer should know, what a programmer should know, what a php programmer should know, tell me about myself, programmer can t find a job, get job as a php programmer, time track app, dba job, what, what if, php app, mysql dba, find bug with my, find a php programmer, app php mysql, app time lock, dumps, fix bug app, mysql lock, lock app time, php mysql bug fix

Project ID: #4168738

Awarded to:

saurabhapandey

I am ready to work.

$150 USD in 2 days
(4 Reviews)
4.0

3 freelancers are bidding on average $197 for this job

bistanil98

Ready to start this project.Check my portfolio in PM.

$190 USD in 7 days
(15 Reviews)
5.5
GandalfTheGrey

I am experienced Linux system and database administrator. I can help you find out source of your issues. More details sent privately.

$250 USD in 1 day
(12 Reviews)
4.5