MySQL Forums :: Database Design and Data Modelling :: MyISAM vs InnoDB in several applications
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
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
| 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.
© 2013, Oracle Corporation and/or its affiliates