My WordPress hosting provider has suspended my website for slow queries
I’m reaching out to share a recent experience with my hosting provider, which resulted in the suspension of my account due to slow MySQL queries. Despite maintaining the latest WordPress version and diligently updating plugins, my account faced suspension, prompting me to question the legitimacy of such actions.
I’m curious to hear if any fellow WordPress users have encountered similar situations with their hosting providers, particularly those utilizing FastComet services. Has anyone experienced account suspension due to performance-related concerns, and if so, how was the issue resolved?
Upon examination, it appears that the queries primarily stem from specific WordPress tables within the databases. These queries involve actions such as deleting transient options, inserting transient timeouts, and selecting data from various WordPress tables such as wp\_options
, wp\_postmeta
, wp\_wc\_admin\_notes
, wp\_wc\_admin\_notes
, and wp\_woocommerce\_sessions
. While some queries exhibit longer execution times, they do not appear to be excessive or indicative of a systemic issue that warrants the suspension of my account.
Some queries they sent me in the logs.
Query\_time: 20.594261 Lock\_time: 0.000015 Rows\_sent: 263 Rows\_examined: 279
SET timestamp=1711016199;
SELECT name, val FROM wpqz\_wfconfig WHERE autoload = ‘yes’; Time: 2024-03-21T10:17:00.139324Z
Query\_time: 3.335211 Lock\_time: 0.000010 Rows\_sent: 0 Rows\_examined: 124
SET timestamp=1711024261;
SELECT note\_id FROM wp\_wc\_admin\_notes WHERE name = ‘ppcp-disable-ppxo-note’ ORDER BY note\_id ASC;
Query\_time: 4.785822 Lock\_time: 0.000003 Rows\_sent: 0 Rows\_examined: 0
SET timestamp=1711024897;
SELECT option\_value FROM wp\_options WHERE option\_name = ‘as\_has\_wp\_comment\_logs’ LIMIT 1;
Query\_time: 3.604230 Lock\_time: 0.000045 Rows\_sent: 6 Rows\_examined: 18
SET timestamp=1711043582;
SELECT t.term\_id
FROM wpqz\_terms AS t INNER JOIN wpqz\_term\_taxonomy AS tt ON t.term\_id = tt.term\_id
WHERE tt.taxonomy IN (‘ocean\_sidebars’)
ORDER BY t.name ASC;
While you might need to do some database optimization, this sounds like a hosting issue. Underpowered database servers. I had Fast Comet, once. Once. It was cheap, hot garbage.
I recommend Cloudways, Flywheel, Siteground…anywhere with solid support and reputable uptime, performance.
Well, you hear of something new under the sun every other day
I ve had enough with all the big hosting providers and their performances issues ..
i ve learnt to build a vps with an open source panel , I ve learnt how to optimize and started hosting website myself and giving access to clients myself
That way , I ve absolutely no problem ..
Is there any indexes on the values being queries? Seems abnormally high for simple equals queries.