开发者

MyISAM alternative that is not InnoDB?

I have issues with using the MyISAM engine in my database. It is constantly corrupting and has severely varying query times. Thus I can not use it any more. I have found the InnoDB to be a good alternatve, but here is the problem:

 Engine         Support     Comment
 MyISAM         DEFAULT     Default engine as of MySQL 3.23 with great perform...
 MEMORY         YES         Hash based, stored in memory, useful for temporary...
 In开发者_如何学JAVAnoDB         DISABLED    Supports transactions, row-level locking, and fore...
 BerkeleyDB     NO          Supports transactions and page-level locking
 BLACKHOLE      YES         /dev/null storage engine (anything you write to it...
 EXAMPLE        NO          Example storage engine
 ARCHIVE        YES         Archive storage engine
 CSV            YES         CSV storage engine
 ndbcluster     DISABLED    Clustered, fault-tolerant, memory-based tables
 FEDERATED      YES         Federated MySQL storage engine
 MRG_MYISAM     YES         Collection of identical MyISAM tables
 ISAM           NO          Obsolete storage engine

Hope that formats correctly

I have no power over the support for the different engines, so this is what I got to work with.

Am I basically in trouble? Or is there any of these that can do the trick? I have a DB that will hold potentially millions of entries and I need to perform "LIKE" operations on a "mediumtext" field (possibly fulltext search), and have a high insert/update rate into the db (at times in excess of 50 entries/second).


I'd say you're in trouble, since you don't have control over engines you can't do anything.

However, for performing full text search on a big database could be done using Apache Lucene. As far as I know, it is faster and more scalable than any sql engine out there. It's implemented in Java, but there are many other implementations including C, C++, .Net, Python, PHP, ...


If you're having corruption with MyISAM, you've got another reliability problem elsewhere -- like your mysql daemon being killed unceremoniously, or a disk error, or a power problem.

Since the good alternatives are disabled, you're pretty stuck there. Time to get a provider that doesn't disable the good things.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜