Advantages/disadvantages InnoDB over MyISAM?

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Some one suggested me to alter my tables to InnoDB instead of myISAM
type to improve speed for select queries. Is this really true. I read
some article that stated that myISAM was optimized for select queries
over update/insert because of most of the queries for web based
applications are select queries.

Can anyone tell me what the advantages or disadvantegs are of InnoDB
over myISAM?

Is there anythging I should keep in mind when I alter my tables apart
from thorough and good backup before I start?

How much time does it take to alter a database of lets say about 200MB
of mission critical data?

I've read the MySQL manual, considering table structures and upgrading
already and am particularly interested in user experiences.

Thanks in advance!


A: Because it messes up the order in which people normally read text.
Q: Why is it such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet and in e-mail?

Site Timeline