SQL Tuning


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.

Keahlian: MySQL

Lihat lebih lanjut: mysqlexception 0x80004005 deadlock found trying lock, robot's name, robot name, name the robot, name that robot, name of the robot, TUNING, deadlock, database tuning, retriving, sql different, mysql lock, sql problem, registry mysql, SQL stored, server tuning, lock windows, need million asap, sql robots, sql transaction

Tentang Pemberi kerja:
( 4 ulasan ) Sao Paulo, Brazil

ID Proyek: #3440174

Diberikan kepada:


See private message.

$127.5 USD dalam 5 hari
(18 Ulasan)

3 freelancer menawar dengan rata-rata $105 untuk pekerjaan ini


See private message.

$85 USD dalam 5 hari
(2 Ulasan)

See private message.

$102 USD dalam 5 hari
(1 Ulasan)