Thanks a lot, David,
I left it running now for approx. 5 days !!! Finally it finished : 17 pages/sec (only)
The problem is that you're using InnoDB and reindexing at every insert.
No, i used MyISAM tables. I need to use MyISAM for fulltext indexing. See my next post.
But you are probably right:
Disable the keys on page/text/revision
will resolve the problem.
I won't try that now, as i am happy enough to be able to go on with enwiki.
Btw. perl mwimport worked like a charm for dewiki, itwiki, frwiki , but not for enwiki.
Alex
On Mon, 2007-08-06 at 01:25 +0200, MESHine Team wrote:
I won't try that now, as i am happy enough to be able to go on with enwiki. Btw. perl mwimport worked like a charm for dewiki, itwiki, frwiki , but not for enwiki.
In the interest of not duplicating similar efforts, might I ask what your project is?
On 06/08/07, MESHine Team alerts@meshine.info wrote:
No, i used MyISAM tables. I need to use MyISAM for fulltext indexing. See my next post.
If you only need to use MyISAM for full-text matching, then use it for the "searchindex" table, and use InnoDB for the other tables.
Rob Church
wikitech-l@lists.wikimedia.org