Questions tagged [innodb]

InnoDB is the main ACID-compliant Storage Engine used in MySQL.

3 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
69 views

Trying to change database tables storage engine to innodb gives error “invalid default value for 'post_date'”

I have a live WordPress website. Most of the tables are using MyISAM storage engine with UTF-8 encoding. I need to switch their storage engine to innodb. But when I try to change the engine, I get ...
1
vote
0answers
648 views

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 screenshot you can see that it is a mix and match of MyISAM and InnoDB tables. ...
0
votes
0answers
44 views

Wordpress UPDATE queries on MySQL database stuck

I have an Amazon 24XL server 96 Cores 378 GB RAM Database size 5.7G Debian GNU/Linux 9 (stretch) PHP 7.3.16 mysql Ver 15.1 Distrib 10.3.22-MariaDB I have only one WordPress site where users read ...