Not Solved MyISAM vs InnoDB for MyBB?
#5
Not Solved
MyISAM has always supported FULLTEXT search, but lacks per-row locking. Additionally, MyISAM lacks support for transactions and foreign keys.
InnoDB supports transactions and foreign keys. It has supported FULLTEXT since MyQL 5.6.4 (MariaDB 10.0).

Which engine should be used for which table depends on the table's needs and your version of MySQL. If you have MySQL 5.6.4 or higher, use InnoDB for most tables. One possible exception is the session table can be sped up with the MEMORY engine if you have enough RAM.

You should use MyISAM for tables that need FULLTEXT (such as posts) and you are using an older version of MySQL; InnoDB for everything else.
Reply


Messages In This Thread
MyISAM vs InnoDB for MyBB? - by Eldenroot - 2016-12-11, 07:31 PM
RE: MyISAM vs InnoDB for MyBB? - by dragonexpert - 2016-12-12, 01:03 PM
RE: MyISAM vs InnoDB for MyBB? - by Eldenroot - 2016-12-12, 04:15 PM
RE: MyISAM vs InnoDB for MyBB? - by laie_techie - 2016-12-12, 06:48 PM
RE: MyISAM vs InnoDB for MyBB? - by Eldenroot - 2016-12-12, 06:50 PM
RE: MyISAM vs InnoDB for MyBB? - by laie_techie - 2016-12-12, 07:12 PM
RE: MyISAM vs InnoDB for MyBB? - by Eldenroot - 2016-12-12, 07:21 PM
RE: MyISAM vs InnoDB for MyBB? - by laie_techie - 2016-12-13, 04:56 PM
RE: MyISAM vs InnoDB for MyBB? - by Eldenroot - 2016-12-13, 05:05 PM
RE: MyISAM vs InnoDB for MyBB? - by laie_techie - 2016-12-13, 07:37 PM
RE: MyISAM vs InnoDB for MyBB? - by Eldenroot - 2016-12-13, 08:08 PM
RE: MyISAM vs InnoDB for MyBB? - by laie_techie - 2016-12-13, 09:20 PM
RE: MyISAM vs InnoDB for MyBB? - by Hewret - 2016-12-13, 08:19 PM
RE: MyISAM vs InnoDB for MyBB? - by Eldenroot - 2016-12-14, 04:12 PM
RE: MyISAM vs InnoDB for MyBB? - by dragonexpert - 2016-12-14, 10:08 PM
RE: MyISAM vs InnoDB for MyBB? - by Eldenroot - 2016-12-15, 05:40 AM
RE: MyISAM vs InnoDB for MyBB? - by Eldenroot - 2017-01-15, 02:55 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)