Skip navigation links

MySQL Forums :: Database Design & Data Modelling :: MyISAM vs InnoDB in several applications


Advanced Search

Re: MyISAM vs InnoDB in several applications
Posted by: Rick James ()
Date: February 24, 2012 09:48AM

Use InnoDB.

The advice toward MyISAM is "old". It is still a viable Engine, but InnoDB has gotten better.

If you need FULLTEXT or Spatial indexes, then you must use MyISAM for those tables.

1000 users? Tiny.

A few hints of the subtle Engine differences can be found here:
http://mysql.rjweb.org/doc.php/myisam2innodb

Options: ReplyQuote


Subject Written By Posted
MyISAM vs InnoDB in several applications Alan Kositzke 02/22/2012 07:07AM
Re: MyISAM vs InnoDB in several applications Rick James 02/24/2012 09:48AM
Re: MyISAM vs InnoDB in several applications Alan Kositzke 02/24/2012 07:53PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.