Loginizer safe to use InnoDB?

  • Resolved Joe Westcott

    (@redredweb)


    3 years, 10 months ago

    Hi folks, is it safe for us to use InnoDB as the table type for the Loginizer database table that you create, “wp_loginizer_logs”?

    Our hosting company is strongly encouraging us to use InnoDB, and they’ve alerted us that Loginizer is using the MyISAM engine type by default and that we should switch to InnoDB if we can.

    I see that some of the downsides to MyISM are as follows:

    * There’s a great risk of index corruption.
    * Updates mean table locks, not just row locks.
    * There’s no support for transactions.

    It seems that InnoDB has become something of a standard since it launched in 2010.

    I can run a MYSQL command to change the table type to InnoDB, but can you tell me whether there would be any problem if I switch the table type to InnoDB?

Viewing 1 replies (of 1 total)
  • Plugin Contributor loginizer

    (@loginizer)

    Yes you can change the table type to InnoDB. It is completely safe and should not cause any issues.

Viewing 1 replies (of 1 total)
  • The topic ‘Loginizer safe to use InnoDB?’ is closed to new replies.