While working on MariaDB Dialects, I realize that we should also refactor the MySQL ones.
The problem is that we introduced the InnoDB hierarchy.

Since the only difference between those two is related to 3 methods, I think we should hide them behind a MySQLStorageEngine hierarchy with InnoDB being the default one.
This way, we'll have a single MySQL Dialect hierarchy, and users can switch to MyISAM via a configuration property which defines what MySQLStorageEngine implementation we are using.