L
L
Laughboy2012-09-04 23:49:06
PHP
Laughboy, 2012-09-04 23:49:06

Why does MySQL hang after many inserts?

There are 6 sites.
5 sites updates the product catalog from the main site.
Update: a MySQL dump of the product catalog is generated on the main site (18 tables, on average ~ 10th records per table), then the dump is inserted on the updated site. In the dump - a table drop and an insert of records.
Update one takes 12-15 seconds.
MySQL hangs after all updates. Not at the time of the updates, but after, it may take 5 minutes, maybe 10 ... Or it may not freeze.

Can someone tell me which way to dig?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
X
Xander Bass, 2012-09-09
@XanderBass

Probably, in the direction of the architecture of the entire bunch of six sites. I'm sorry if my question seems stupid. However, would it make sense for the five slave sites to simply use the original site's database rather than clone it permanently to itself?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question