-
Notifications
You must be signed in to change notification settings - Fork 4
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
All my tables are still MyISAM #9
Comments
bump |
Hey, interesting question. Switching between myISAM and InnoDB is not a problem. InnoDB is the new default engine since mySQL 5.5, but that doesn't mean you should always use it. There exist different engines for different purposes and performance reasons. We have not made any specific optimisations towards any of these engines yet, but we'll get to that (https://github.com/projectfork/Generator will assist with this - dont use it, its for devs only ✋) I have never looked at how Joomla processes the mysql install instructions in detail. Could be that they set the default engine, because Projectfork does not instruct mysql to use any particular engine. It just uses the default...which may be myISAM for J 2.5, and InnoDB in J3+. That being said, there's nothing to fix here actually, except for performance optimisations on our end :) |
joomla has specific made changes to the database tables so they are innodb. From a joomla tracker post i made: ALTER TABLE From what i read innodb can have some perfomance issues but has a lot more functionality and is safer for data and everyone seems to be moving to it. Its a bit like the collation type, there is hundreds of them but which one (i use with ut8_general_ci) I am going to migrate my PF4 tables to innodb, but with joomla core all moving to innodb, perhaps it would keep things neater having PF4 actually check to make sure it's tables are innodb. All K2 will be moving to innodb shortly. All my extensions unless they specify otherwise now install with innodb including PF4. cheers |
Hi,
i migrated my site from PF3 to PF4 on a 2.5 install and then upgraded to J3.x
While looking at my MySQL tables i have dicovered some of my tables are still MyISAM. All the PF4 tables are MyISAM. However when i do a fresh install of PF4 on a fresh copy of J3.1.1 all the tables install as InnoDB.
InnoDB seems to becomning the new default and as such i am trying to unify my tables.
so the 2 things that come out of this are
thanks
The text was updated successfully, but these errors were encountered: