WF and MySQL problem?

There have been some intermittent outages on a site hosted on Dreampress. Their support says the following. Are there any WF parameters I should tweak?

Thanks for contacting DreamHost! We’ve checked into the site settings and
logs for pluggedingolf.com to see what we could find to help for the
reported intermittent site downtime. The server was not reflecting errors
regarding maxing out the resource usage. The site logs were reflecting
database errors caused by the WordFence plugin. One example of these
errors is:

[Sun Dec 23 16:46:53 2018] [error] [client 68.205.230.65] FastCGI: server
“/var/run/php-wp_sywf63.fcgi” stderr: PHP message: WordPress database
error Deadlock found when trying to get lock; try restarting transaction
for query INSERT IGNORE INTO gwf_wfConfig (name, val, autoload)
VALUES (‘wfSyncGeoIP.lock’, ‘1545612412’, ‘no’) made by
require(‘wp-blog-header.php’), require_once(‘wp-load.php’),
require_once(‘wp-config.php’), require_once(‘wp-settings.php’),
do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters,
wordfence::veryFirstAction, wfConfig::createLock, referer:
https://pluggedingolf.com/kbs-tour-v-wedge-shaft-review/

The plugin causing the database processes to lock up, which would cause
intermittent errors on the site. We recommend troubleshooting the
WordFence plugin and reaching out to the WordFence support team, as
needed, to assist.

To help with the overall performance, we’ve taken steps to help optimize
the site’s database and PHP process limits. To help with the overall site
performance, we’ve run the WordPress database repair tool. We’ve also
optimized the WordPress database and cleared expired transients. We’ve
flushed the database cache to clear any previously stored settings. 92
expired transients deleted from the database. The database size was
reduced from 220MB to 207MB.

To help with the future site performance, we’ve added optimized PHP
limits for the PHP processes to the .user.ini file.

• This topic was modified 5 years, 11 months ago by Steven Stern (sterndata).