database - Is it safe to convert tables from MyISAM to InnoDB?

I have inherited a WP site (with WP5.1 and WooCommerce 2.6.14, LearnDash 2.5.4 and few other smaller plugins). From scre

I have inherited a WP site (with WP5.1 and WooCommerce 2.6.14, LearnDash 2.5.4 and few other smaller plugins).

From screenshot you can see that it is a mix and match of MyISAM and InnoDB tables.

We are experiencing table locking related problems (which essentially slow site down and result in 503 errors).

Even on such a simple table as wp_options we seem to have up to 10seconds lock times. Also on wp_posts.

Is it safe to convert tables from MyISAM to InnoDB? (we think that avoiding MyISAM table-level locking and switching to InnoDB row-level locking may help solve our issues).

ps. MySQL version 5.6.36-82.1-log - Percona Server (GPL), Release 82.1, Revision 1a00d79 (SiteGround)

发布者:admin,转转请注明出处:http://www.yc00.com/questions/1742286872a4415477.html

相关推荐

  • database - Is it safe to convert tables from MyISAM to InnoDB?

    I have inherited a WP site (with WP5.1 and WooCommerce 2.6.14, LearnDash 2.5.4 and few other smaller plugins). From scre

    16小时前
    40

发表回复

评论列表(0条)

  • 暂无评论

联系我们

400-800-8888

在线咨询: QQ交谈

邮件:admin@example.com

工作时间:周一至周五,9:30-18:30,节假日休息

关注微信