On Wed, 2007-08-01 at 20:38 +0200, MESHine Team wrote:
May be, someone in this list could advise me how to optimize mysql for the given task.
The problem is that you're using InnoDB and reindexing at every insert.
Disable the keys on page/text/revision before you import, and enable them when you're done, and you should see a significant speedup.
My en.wiki import takes about 45 minutes total, for 5.3 million rows.