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.
--
David A. Desrosiers
desrod(a)gnu-designs.com
setuid(a)gmail.com
http://projects.plkr.org/
Office..: 860-271-1642
Skype...: 860-967-3820