Questions tagged [innodb]
InnoDB is the main ACID-compliant Storage Engine used in MySQL.
13 questions
2
votes
0
answers
242
views
Is MariaDB's Aria storage engine suitable for WordPress?
MySQL sites are steadily migrating away from the older MyISAM storage engine to InnoDB. That's because InnoDB has better recovery and row-by-row transaction locking support.
At the same time, many ...
- 481
1
vote
0
answers
558
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 ...
- 139
0
votes
0
answers
120
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 ...
- 1
2
votes
0
answers
2k
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.
...
- 121
0
votes
1
answer
1k
views
Set default Database Storage Engine when creating tables with plugins?
Referring to the Codex on "Creating Tables with Plugins", I can't find any reference on specifying the table storage engine during creation.
Consider the below function to create the table initially:
...
0
votes
1
answer
8k
views
Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
I'm transferring a bunch of domains a new host. The site names remain the same, and for the sites I've already migrated, no manipulation was necessary in the database. It just works once name-servers ...
- 121
3
votes
1
answer
821
views
Can I explicitly specify ENGINE=InnoDB in Wordpress?
I converted all my tables to InnoDB, but the MySQL server (which I can't access, as I'm on shared hosting) has MyISAM as the default, so every new table that Wordpress creates (e.g. when I add a new ...
- 135
2
votes
1
answer
3k
views
Large database causes slow load
I have a 2GB WordPress database (using InnoDB Storage Engine) and I noticed my site loads slow when I press the publish button right after I selected a featured image in the media library.
I had a ...
- 543
5
votes
1
answer
226
views
Performance Gains of Relational DB Setup
Our team is working on the 3rd of large WP sites for a client, and contrary to most "typical" WordPress setups, our projects are generally experience lots of requests, data pulls, and general content -...
- 3,174
7
votes
2
answers
7k
views
Does WordPress use the InnoDB engine for MySQL by default?
I just created a new WordPress site in my server. Normally, WordPress uses MyISAM as the database type. But this time, it created all InnoDB tables! Is this normal? Has WordPress switched to InnoDB in ...
- 177
2
votes
2
answers
4k
views
If I consider changing my WordPress DB tables to InnoDB, will it have an effect on the way WordPress works?
I found a superb post here about optimising WordPress for large installs.
One of the steps refers to lighthttpd which sounds excellent but isn't currently supported by DirectAdmin. Last time I messed ...
- 1,237
16
votes
2
answers
15k
views
WordPress (MyISAM) database is slow, should I switch to InnoDB?
I have a WordPress site with well over 10k posts, and things are starting to get very slow whenever I am adding and editing posts. Pages load nice and fast for users, along with the admin lists of ...
- 271
6
votes
1
answer
964
views
Would switching to InnoDB from MyISAM improve performance of comments table?
A site I've built gets lots of comments in a short space of time - so perhaps 100 comments might be left in 5 or 10 minutes.
This seems to cause a pretty heavy load on the database, especially when ...
- 9,562