On Thu, 2003-05-01 at 15:56, Lee Daniel Crocker wrote:
Moving only the old data to the filesystem would also be less of a problem than moving the cur records, because we don't have the problem of losing MySQL's fulltext index, which we need to keep for the cur table to implement the search function.
Actually, that's not the case. We've always used a separate, munged text field for the searchable text (stripping HTML markup, accounting for things like changing "[[foobar]]s" to "foobar foobars", massaging Unicode chars for the non-Latin wikis to make search work right in Esperanto, Polish, Japanese, Chinese, etc).
Originally these were fields in cur, but now they're in a separate table (searchindex) since cur is InnoDB and we can only do fulltext searches on MyISAM tables.
-- brion vibber (brion @ pobox.com)