I was able to greatly reduce the severity of the problem by installing/activating the PHP extension file-info, which was flagged by WordPress as a configuration issue. While it didn’t eliminate the issue completely, the lockup only happened once more during my post migration and the unavailability was much shorter than previous occurrences.
Now that the migration is complete, I don’t ever expect to make so many edits to posts in the future, so I doubt I will see this problem again.
Related Posts:
- How can I find the source of slow queries in WordPress?
- WordPress MySQL & PHP Performance
- Is it useful to turn on MySQL query cache for performance
- Universal problem: first request after ~25 second inactivity always slower (~1 second) than subsequent requests (~1/10sec)
- Concurrent / simultaneous MySQL connections
- Slow Mysql Queries
- Best settings for MySQL to speed up site? [closed]
- How do I join a $wpdb query with user meta using default value if not exist?
- Alter wp_post table vs. post_meta performance/speed
- Slow wp-admin due to “SELECT DISTINCT post_mime_type FROM wp_posts WHERE post_type = ‘attachment'”
- WordPress plugin overloading with tmp tables
- How to simulate web traffic to test performance of a website
- XML RPC post produces immediate revision with odd post_date_gmt
- mysql running over 200% CPU according to atop – pt-query-digest suggests slow running query is a lookup in wp_options for ‘autoload’ = yes
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- How to use mysqli_query() in PHP?
- Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
- Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
- ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
- Column count doesn’t match value count at row 1
- ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
- MySQL string replace
- Cannot add or update a child row: a foreign key constraint fails
- ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
- String concatenation in MySQL
- What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
- Cannot add or update a child row: a foreign key constraint fails
- MySQL Error “Operand should contain 1 column”
- How to use MySQL DECIMAL?
- Access denied for user ‘root@localhost’ (using password:NO)
- Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
- How to make MySQL table primary key auto increment with some prefix
- Access denied for user ‘root@localhost’ (using password:NO)
- MySQL ERROR 1290 (HY000) –secure-file-priv option
- MySQL error 2006: mysql server has gone away
- Which MySQL data type to use for storing boolean values
- sql query with multiple where statements
- ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
- ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
- Cannot delete or update a parent row: a foreign key constraint fails
- Cannot delete or update a parent row: a foreign key constraint fails
- ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
- MySQL server startup error ‘The server quit without updating PID file’
- Rename a column in MySQL
- “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
- Cannot delete or update a parent row: a foreign key constraint fails
- MySQL server startup error ‘The server quit without updating PID file’
- How do I restore a dump file from mysqldump?
- Syntax error due to using a reserved word as a table or column name in MySQL
- ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
- MySQL root password change
- Installation of MySQL for Visual Studio 1.2.8 failed
- Not unique table/alias
- How do I import an SQL file using the command line in MySQL?
- PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
- #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
- MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
- Your password does not satisfy the current policy requirements
- How do I quickly rename a MySQL database (change schema name)?
- What does SQL Select symbol || mean?
- Install mysql-python (Windows)
- MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
- PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
- SQL – Update multiple records in one query
- Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
- What is the definition of cardinality in SQL
- How to restart remote MySQL server running on Ubuntu linux?
- Authentication plugin ‘caching_sha2_password’ cannot be loaded
- MySQL DROP all tables, ignoring foreign keys
- #1055 – Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by
- When to use SELECT … FOR UPDATE?
- Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
- Setting up foreign keys in phpMyAdmin?
- Select from multiple tables without a join?
- PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
- ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
- SQL Query Where Field DOES NOT Contain $x
- Create a new database with MySQL Workbench
- Duplicating a MySQL table, indices, and data
- Disable ONLY_FULL_GROUP_BY
- what does “/index.php?admin/admin_dashboard” in my url mean
- Column ‘user_id’ in field list is ambiguous
- How to join two tables by multiple columns in SQL?
- How to get size of mysql database?
- mysql Foreign key constraint is incorrectly formed error
- Database sharding vs partitioning
- Selecting data from two different tables without using joins
- MySQL WHERE IN ()
- Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
- Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
- ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
- SQL – Update multiple records in one query
- Difference between VARCHAR and TEXT in MySQL
- mysql is not recognised as an internal or external command,operable program or batch
- 1052: Column ‘id’ in field list is ambiguous
- Escape string Python for MySQL
- 1052: Column ‘id’ in field list is ambiguous
- MySQL Error 1093 – Can’t specify target table for update in FROM clause