By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,961 Members | 2,492 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,961 IT Pros & Developers. It's quick & easy.

Advantages/disadvantages InnoDB over MyISAM?

P: n/a
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!

Jonathan

--
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?
Jul 23 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.