On Tue, 2007-08-07 at 19:34 +0200, MESHine Team wrote:
I issued this command on mysql (v5.0.45) command line: ALTER TABLE dewiki.text ADD FULLTEXT (old_text);
Let me give this a try on my local Wikimedia mirror here... because (as many here already know), I've had some really great success with performance tweaking the mw install and backend SQL database.
I'm currently importing the 81 dumps per-project (486 separate dumps), and working on the performance of automating that. When that's done, I'll try to add a full text index to dewiki and see how long it takes.