InnoDB MySql

Got an email today from Bam4D & he mentioned InnoDB. I did a little google on it, wait, that sounds horrible. So i googled it and found that it is a MySQL table type that can have many advantages over the other types of MySQL tables.

When designing tables in the past, I have never changed the table type. I have known about and always used the default MyISAM, just figured it do what I needed, and it did. But if I’m able to use something faster and something that has useful features, I’m on board.

That is one of the down sides of using a GUI for developing vs. command line. You get to take shortcuts instead of fully learning what you are working with. I checked and do have InnoDB available & ready to go! So I plan to try it out and use some of the features, like the backup. I like the fact that it is faster. This will also allow me to learn more about transactions for more advanced web apps.

Thanks for the info Bam!
Hey, when’s your blog going up? Throw your cryptic stevelish up and see if anyone can decode it…. :) , might get a ton of hits!

InnoDB: Short introduction

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>