Rolf Lampa [RIL] skrev:
Hi all,
only about 13 000 000 rows of data so it shouldn't take many minutes. Now it takes hours. I noticed that time for inserts increase as the table grows. Peeking with SHOW PROGRESSLIST sometimes says:
+------+------------+-------- | time | State | Info | 38 | ** DEAD ** | INSERT INTO 'pagelinks' ... +------+------------+--------------------------------
When I had posted I realized that at only 230 000 rows it now takes up to 76 seconds(unit?) per row, and increasing...
No no, here's something seriously wrong.
// Rolf Lampa