No default DB engine set for multiple tables
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 Morton Jonuschat about 5 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.