Bug #78063
closed
No default DB engine set for multiple tables
0%
Description
The table sys_file_reference and many other have no defined engine. So depending on the MySQL setup, they might be created as MyISAM tables.
It happened that the table sys_file_reference crashed, so TYPO3 did not work anymore until the table was repaired.
This could probably be prevented by changing the tables to InnoDB.
Updated by Stephan Großberndt over 7 years ago
We use TokuDB as main engine. I would rather not have InnoDB to be forced for more tables. I propose to rather configure your server differently to use InnoDB as default engine instead.
Updated by Morton Jonuschat over 7 years ago
- Status changed from New to Needs Feedback
I agree with Stephan on this, unless there is a requirement to force a certain engine type (like full text search) the database system should be the one that decides on the best defaults.
Given that InnoDB is the default engine since MySQL 5.5 and TYPO3 requires MySQL 5.5+ I don't see a big problem with keeping things the way they are.
Updated by Riccardo De Contardi over 7 years ago
- Status changed from Needs Feedback to Closed
90 days without feedback => closing this issue
If you think that this is the wrong decision or it is still relevant, please reopen it or open a new issue with a reference to this one.
Thank you