Many people have used it in more critical applications, and it's up to the task. Slashdot, for instance, or Yahoo! Finance.
It's around the same speed as MyISAM. One thing it's missing is fulltext searching... but you can't win 'em all....
It's not really all that useful for vpopmail, because all the data's in one table anyway. But using InnoDB wouldn't cause all that much harm.
InnoDB is installed and initialized by default on MySQL 4.x. To use it, just ALTER TABLE table_name TYPE=InnoDB (could take a while if it's a big table -- you might want to create a separate InnoDB table and copy a few thousand rows at a time), or when CREATE-ing, CREATE TABLE table_name (blah blah blah) TYPE=InnoDB.
-- Adam Hooper [EMAIL PROTECTED]
Erik Bourget wrote:
Adam Hooper <[EMAIL PROTECTED]> writes:
I don't quite follow you. Why is it not relational? Note that MySQL's InnoDB table storage supports transactions, row-level locks, and foreign keys.
To be fair, I don't count InnoDB as "mysql". Perhaps I should. Is it
production-ready (I assume so)? How is the speed compared to featureless
myisam?
- Erik
