SQL Tuning

Slutfört Publicerat Jul 12, 2011 Betalades vid leverans
Slutfört Betalades vid leverans

**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

Projekt-id: #3440174

About the project

3 offerter Distansprojekt Aktivt Jul 14, 2011

Tilldelades:

aelyoussoufi

See private message.

$127.5 USD inom 5 dagar
(18 omdömen)
3.7

3 frilansare har lagt bud på i genomsnitt $105 för det här jobbet

kram3r

See private message.

$85 USD inom 5 dagar
(2 omdömen)
3.2
Cyntax

See private message.

$102 USD inom 5 dagar
(1 omdöme)
2.2