MyISAM table cannot be converted to innobd

  • Resolved rainsey

    (@rainsey)


    10 months, 4 weeks ago

    Hi,

    The plugin creates table wp_abj404_logsv2 as MyISAM.

    Converting the table to InnoDB results in the plugin recreating the table as MyISAM. Is there any reason why the table cannot be saved in the database with the innobd engine?

    Thanks

Viewing 1 replies (of 1 total)
  • Plugin Author Aaron

    (@aaron13100)

    Hello,

    According to my notes: “Use MyISAM because optimize table is slow otherwise.”

    It looks like the optimize table command is run 1. every time the settings page is viewed so the correct disk space usage will be returned and 2. once daily during the maintenance run. The performance in those two cases was probably impacted and my guess is that when there are many lines in the table the ‘view logs’ returned slowly also.

Viewing 1 replies (of 1 total)
  • The topic ‘MyISAM table cannot be converted to innobd’ is closed to new replies.