[OT} MyISAM vs. InnoDB

Yahoo Archive
1
Good thing you asked this question here and not on one of the MySQL forums.
I did that once when the InnoDB technology was younger and it turned into a
huge flame war.



I prefer to use InnoDB for 99% of what I've done with MySQL. Neither of the
options will give you issues with batching. Crash recovery is way better
with InnoDB than MyISAM. I would pick InnoDB on that alone. MyISAM isn't
supported on MySQL 5, so if that is what you will be using then the decision
is made for you.



Here is a little Wikipedia entry on MyISAM.
http://en.wikipedia.org/wiki/MyISAM



HTH,



Ted Kitch

Information Technology Manager

Astro Machine Corporation

www.astromachine.com



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Michael McWilliams
Sent: Thursday, July 24, 2008 3:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] [OT} MyISAM vs InnoDB



We are creating a mill downtime application that logs all of our
delays into a MySql DB in a batch at the end of each shift. Any
suggestions in using MyISAM vs InnoDB for batching?





[Non-text portions of this message have been removed]
2
We are creating a mill downtime application that logs all of our
delays into a MySql DB in a batch at the end of each shift. Any
suggestions in using MyISAM vs InnoDB for batching?