Description:
It is widely known that mysql system/grant tables should be myisam. (excluding the logtables). This is a feature request to make mysql_upgrade ensure that when calling mysql_system_tables_fix.sql the tables that should be myisam are indeed myisam.
How to repeat:
preferably not
Suggested fix:
Add the following into mysql_system_tables_fix.sql:
alter table `mysql`.`columns_priv` engine=myisam;
alter table `mysql`.`db` engine=myisam;
alter table `mysql`.`event` engine=myisam;
alter table `mysql`.`func` engine=myisam;
alter table `mysql`.`help_category` engine=myisam;
alter table `mysql`.`help_keyword` engine=myisam;
alter table `mysql`.`help_relation` engine=myisam;
alter table `mysql`.`help_topic` engine=myisam;
alter table `mysql`.`host` engine=myisam;
alter table `mysql`.`ndb_binlog_index` engine=myisam;
alter table `mysql`.`plugin` engine=myisam;
alter table `mysql`.`proc` engine=myisam;
alter table `mysql`.`procs_priv` engine=myisam;
alter table `mysql`.`servers` engine=myisam;
alter table `mysql`.`tables_priv` engine=myisam;
alter table `mysql`.`time_zone` engine=myisam;
alter table `mysql`.`time_zone_leap_second` engine=myisam;
alter table `mysql`.`time_zone_name` engine=myisam;
alter table `mysql`.`time_zone_transition` engine=myisam;
alter table `mysql`.`time_zone_transition_type` engine=myisam;
alter table `mysql`.`user` engine=myisam;