My 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?

    Your insights and shared experiences would be immensely valuable as I navigate this situation. Together, we can better understand the actions of hosting providers and advocate for fair and transparent policies in the WordPress community.

    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;

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Assuming nothing’s wrong with the server’s MySQL server (and we don’t know that to be true), you can do a few things to optimize the database.

    1. Via PHPMYADMIN from your hosting control panel, analyze and optimize the database. Note: Make a backup (export) of the db first!
    2. If your hosts lets you restart WordPress, install the plugin https://www.ads-software.com/plugins/wp-optimize/ and remove expired transients and any other optimizations it suggests.
    3. Install the plugin https://www.ads-software.com/plugins/index-wp-mysql-for-speed/ and add additional keys to the database. This will speed up database queries and a slight cost of making writes to the db a little bit slower.

    Please note that questions about hosts get spammy fast, so for anyone reading, please do not get into a discussion of what hosts are good, bad, and/or ugly. Such replies will be removed and not help this user.

    I had a similar problem with one of my huge news portals, website was spending resources and I got a soft warning from host. What I did was just split my website into sections, archives via subdomains. For example 2023.mywebsite.com etc.

    You can ask your host if that would help if you split your website in multiple databases etc.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘My hosting provider has suspended my website for slow queries’ is closed to new replies.