[Mediawiki-l] Extremely slow import of pagelinks

[Rolf Lampa [RIL]]

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