Forum Replies Created

Viewing 6 replies - 1 through 6 (of 6 total)
  • @crobbinsdg: Great! ??

    Thread Starter Dexterity

    (@dexterity)

    It may have gotten flagged because you changed other lines and URLs in the readme file as well, not just the version number.

    Thread Starter Dexterity

    (@dexterity)

    Thanks, Devin.

    FYI it looks like you pasted the wrong link at Github when you reported it there. You probably wanted to paste a link to this thread, not to the Check Email plugin.

    I found out what was causing this problem and how to solve it. It was caused by a common issue of runaway transient entries in the wp_options table.

    I couldn’t believe those simple queries should take so long to run, so I looked at the wp_options table and was amazed that it had ballooned to more than 360,000 entries. All but about 500 of them were expired transients.

    So I ran the following SQL command:

    DELETE FROM wp_options WHERE option_name LIKE ('\_transient\_%');

    Then I defragmented the table, and after that my New Blog Post page loaded in 0.84 seconds instead of 12.5 seconds.

    I also verified with Query Monitor that the Yoast queries are now running in about 0.0003 seconds. Much better!

    For a long-term solution to clean up runaway transients every day, you can use the plugin Delete Expired Transients, which will run a query once a day like the one above to keep expired transients from getting out of control:
    https://www.ads-software.com/plugins/delete-expired-transients/

    Hope this solution helps others who are having the same problem.

    I’m having a similar problem with Yoast’s slow queries (as measured by Query Monitor). The New Blog Post page normally takes 1.5 seconds to load. With Yoast SEO activated, it takes 12.5 seconds to load. The slow queries all look like this:

    DELETE
    FROM wp_options
    WHERE option_name LIKE '\_transient\_%\_6p6aw'
    OR option_name LIKE '\_transient\_timeout\_%\_6p6aw'
    
    DELETE
    FROM wp_options
    WHERE option_name LIKE '\_transient\_%\_6p6yG'
    OR option_name LIKE '\_transient\_timeout\_%\_6p6yG'
    
    ... 
    
    DELETE
    FROM wp_options
    WHERE option_name LIKE '\_transient\_%\_6tPNF'
    OR option_name LIKE '\_transient\_timeout\_%\_6tPNF'

    There are several of these queries, and each one takes 1.3 to 1.4 seconds to execute. Most of the other queries execute in much less than 0.1 seconds.

    They’re all coming from WPSEO_Sitemaps_Cache_Validator::cleanup_database().

    I’m running the latest version of the plugin (3.2.3).

    How to fix these ultra-slow Yoast queries?

    I started getting blog-spammed by this poker jerk too. It turns out his site is an affiliate of Empire Poker, and he’s violating their affiliate agreement by spamming blogs like this on their behalf. So I suggest everyone here send an email to [email protected] (email address grabbed from their web site) to complain about this spammer and ask that they terminate his affiliate account immediately. His affiliate ID is apparently 1710078. I’ve already done this myself, so I suggest all of you do the same — the more complaints they receive, the better. At least we should be able to keep this jerk from continuing to make money from such annoying behavior.

Viewing 6 replies - 1 through 6 (of 6 total)