6

MyISAM Or InnoDB MySQL engine?

view full story
linux-howto

http://linuxers.org – Most people don't bother about what MySQL engine they are using. Generally, it doesn't even matter, the default MyISAM does the job really well but sometimes switching to some other engine or at least knowing what others are capable of, could speed up a lot of things for you. Managing transactions for a Financial website was how I came across InnoDB engine at first. In this article, we will see the difference between MyISAM and InnoDB MySQL engines. So, lets begin by taking a look at all the engines. Type the following command in the mysql prompt. mysql> (General)