InnoDB?

[Ask Bjørn Hansen]

On Apr 15, 2008, at 2:58, Michael A. Toth wrote:

> I plain to use two node master-master mysql-5.0 replication for db
> nodes (these are already configured), I'm going to handle more than
> five million files on mogilefs (with ~5-8 MB/file size). What should I
> prefer: myisam or innodb, and why?

InnoDB.

Because it won't lock on a high number of queries.   Because it's much  
harder to corrupt when the server crashes.  Because it's much easier  
to use the resources the box provides.  Because it is easier to backup.

Etc etc.


  - ask

-- 
http://develooper.com/ - http://askask.com/