[Mediawiki-l] Re: FIXED: Ungraceful mysqld shutdown & "Database error"

[Kate Turner]

Matt England wrote in news.gmane.org.wikimedia.mediawiki:
> [...] Mysql can not (seemingly) support full ungraceful 
> recovery and other journaling features (because some applications like 
> MediaWiki need MyISAM for the text-indexing capabilities that InnoDB does 
> not support?).

MyISAM is MySQL's older database format.  as you have found out, it isn't
very good; in addition to the lack of recovery, it's lacking some of the 
locking, transaction and ACID features you would expect in an RDBMS.

MediaWiki doesn't require MyISAM. i would recommend using the Lucene-based
search instead, which as well as not dying when something crashes,
generally provides better search results than MySQL's fulltext search, and
uses less system resources. you can find this in the "lucene-search" module 
in CVS (http://sourceforge.net/cvs/?group_id=34373).

> -Matt

kate.