MySQL Forums
Forum List  »  Partitioning

Re: Thoughts on partitioning by hour - and which partition type?
Posted by: Phil Hildebrand
Date: June 07, 2008 04:57PM

InnoDB supports transactions, so that should go into the decision as to which engine you need (MyISAM is not transactional with 5.1)

A decent comparison is here:

Another reason for InnoDB is the ability to have row level locking.

In general, if you're working on a datawarehouse, which are often used almost exclusively for reads and aggregation, with most bulk loads / updates off hours, then MyISAM is a great engine, as it doesn't have a lot of the overhead needed to support transactions and multi-version non-locking consistent reads, etc.

MyISAM also has some nice features for separating partitions and indexes over separate disks (which, depending on your disk architecture can have significant I/O performance improvements).

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.