SQL Tuning

Completed Posted Jul 12, 2011 Paid on delivery
Completed Paid on delivery

**Coders,**

We have a huge database stored in MySQL. One of these tables has 2 million registries. Another one has 10 million registries.

We have also 300 robots on different computers doing inserts and updates on the database (both tables) everytime.

**What's our problem?

** The robot get one registry and update this registry to (robotname = name of the robot and registrystatus = running), so others 299 robots wouldn?t get the same registry. After completed the process, the robot update all the information back and set (registrystatus = completed). Our problem is when we are updating the information, some robots get error "[url removed, login to view] (0x80004005): Deadlock found when trying to get lock; try restarting transaction". We need to fix that, either tuning our MySQL server configurations or changing our proccess of retriving/updating the information.

PS: Our server has 4GB RAM and are running windows with MySQL. We need an solution ASAP.

MySQL

Project ID: #3440174

About the project

3 proposals Remote project Active Jul 14, 2011

Awarded to:

aelyoussoufi

See private message.

$127.5 USD in 5 days
(18 Reviews)
3.7

3 freelancers are bidding on average $105 for this job

kram3r

See private message.

$85 USD in 5 days
(2 Reviews)
3.2
Cyntax

See private message.

$102 USD in 5 days
(1 Review)
2.2