phandolin

Sorry, I double posted. Refer here https://www.ads-software.com/support/plugin/woo-donation

Great, again I appreciate the tips. I’ve set up mysql query caching for starters and I’ll keep an eye on things today.

I ran mysql check and got the following results. Could it be wordfence keeping connections open?

.wp_bbpp_thankmelater_opens         OK
.wp_bbpp_thankmelater_opt_outs      OK
.wp_commentmeta                     OK
.wp_comments                        OK
.wp_elp_deliverreport               OK
.wp_elp_emaillist                   OK
.wp_elp_pluginconfig                OK
.wp_elp_sendsetting                 OK
.wp_elp_sentdetails                 OK
.wp_elp_templatetable               OK
.wp_es_deliverreport                OK
.wp_es_emaillist                    OK
.wp_es_notification                 OK
.wp_es_pluginconfig                 OK
.wp_es_sentdetails                  OK
.wp_es_templatetable                OK
.wp_icwp_wpsf_audit_trail           OK
.wp_icwp_wpsf_ip_lists              OK
.wp_icwp_wpsf_user_management       OK
.wp_kads_info                       OK
.wp_links                           OK
.wp_m_communications                OK
.wp_m_coupons                       OK
.wp_m_levelmeta                     OK
.wp_m_member_payments               OK
.wp_m_membership_levels             OK
.wp_m_membership_news               OK
.wp_m_membership_relationships      OK
.wp_m_membership_rules              OK
.wp_m_ping_history                  OK
.wp_m_pings                         OK
.wp_m_subscription_transaction      OK
.wp_m_subscriptionmeta              OK
.wp_m_subscriptions                 OK
.wp_m_subscriptions_levels          OK
.wp_m_urlgroups                     OK
.wp_newsletter                      OK
.wp_newsletter_emails               OK
.wp_newsletter_sent                 OK
.wp_newsletter_stats                OK
.wp_nxs_log                         OK
.wp_opanda_leads                    OK
.wp_opanda_leads_fields             OK
.wp_opanda_stats_v2                 OK
.wp_options                         OK
.wp_postmeta                        OK
.wp_posts                           OK
.wp_simple_history_contexts         OK
.wp_sola_nl_advanced_link_tracking  OK
.wp_sola_nl_campaign_lists          OK
.wp_sola_nl_campaign_subscribers    OK
.wp_sola_nl_campaigns               OK
.wp_sola_nl_css_options             OK
.wp_sola_nl_link_tracking           OK
.wp_sola_nl_list                    OK
.wp_sola_nl_subscribers             OK
.wp_sola_nl_subscribers_list        OK
.wp_sola_nl_themes                  OK
.wp_term_relationships              OK
.wp_term_taxonomy                   OK
.wp_terms                           OK
.wp_translations                    OK
.wp_translations_log                OK
.wp_usermeta                        OK
.wp_users                           OK
.wp_wfBadLeechers                   OK
.wp_wfBlockedIPLog
warning  : 11 clients are using or haven't closed the table properly
status   : OK
.wp_wfBlocks
warning  : 11 clients are using or haven't closed the table properly
status   : OK
.wp_wfBlocksAdv                     OK
.wp_wfConfig
warning  : 14 clients are using or haven't closed the table properly
status   : OK
.wp_wfCrawlers
warning  : 11 clients are using or haven't closed the table properly
status   : OK
.wp_wfFileChanges                   OK
.wp_wfFileMods                      OK
.wp_wfHits
warning  : 1 client is using or hasn't closed the table properly
status   : OK
.wp_wfHoover
warning  : 1 client is using or hasn't closed the table properly
status   : OK
.wp_wfIssues                        OK
.wp_wfLeechers
warning  : 28 clients are using or haven't closed the table properly
status   : OK
.wp_wfLockedOut                     OK
.wp_wfLocs
warning  : 2 clients are using or haven't closed the table properly
status   : OK
.wp_wfLogins
warning  : 13 clients are using or haven't closed the table properly
status   : OK
.wp_wfNet404s
warning  : 14 clients are using or haven't closed the table properly
status   : OK
.wp_wfReverseCache
warning  : 8 clients are using or haven't closed the table properly
status   : OK
.wp_wfScanners
warning  : 15 clients are using or haven't closed the table properly
status   : OK
.wp_wfStatus
warning  : 12 clients are using or haven't closed the table properly
status   : OK
.wp_wfThrottleLog
warning  : 7 clients are using or haven't closed the table properly
status   : OK
.wp_wfVulnScanners                  OK
.wp_wp2crx_registration_table       OK
.wp_wpm_forms                       OK
.wp_wpm_jobs                        OK
.wp_wpm_subscribers                 OK
.wp_wpmarketing_ctas                OK
.wp_wpmarketing_events              OK
.wp_wpmarketing_visitors            OK
.wp_wsluserscontacts                OK
.wp_wslusersprofiles                OK
.wp_wysija_campaign                 OK
.wp_wysija_campaign_list            OK
.wp_wysija_custom_field             OK
.wp_wysija_email                    OK
.wp_wysija_email_user_stat          OK
.wp_wysija_email_user_url           OK
.wp_wysija_form                     OK
.wp_wysija_list                     OK
.wp_wysija_queue                    OK
.wp_wysija_url                      OK
.wp_wysija_url_mail                 OK
.wp_wysija_user                     OK
.wp_wysija_user_field               OK
.wp_wysija_user_history             OK
.wp_wysija_user_list                OK

Hmmm…well the errors have continued a few times this afternoon. Any other ideas?

I think you are probably right. I just ran show status like 'Conn%'; and I see 127 connections, which is very close to 151. I increased to 1000. Thanks!

Thanks for that advice, I see max connections is 151, that seems completely logical that that is the problem. I’m going to increase it and I’ll report back.