Why specify MyISAM as the engine?

Any reason that init.php needs to specify “ENGINE=MyISAM” ?

We prefer to keep all our tables the same engine, and InnoDB is the default on our system. Note WP core does not specify engine.

Better practice would be to follow wp-admin/includes/schema.php and make this change:

– $sql[] = “CREATE TABLE ".$wpdb->prefix."loginizer_logs (
– …
– ) ENGINE=MyISAM DEFAULT CHARSET=utf8;”;
+ $charset_collate = $wpdb->get_charset_collate();
+ $sql[] = “CREATE TABLE ".$wpdb->prefix."loginizer_logs (
+ …
+ ) $charset_collate;

• This topic was modified 6 years, 5 months ago by kitchin.
• This topic was modified 6 years, 5 months ago by kitchin.
• This topic was modified 6 years, 5 months ago by kitchin.