A SELECT from wpxv_aioseo_cache SLOW query

  • Resolved thejosephmiller2000

    (@thejosephmiller2000)


    7 months, 3 weeks ago

    • Timestamp: 2024-03-30T12:17:32.389740Z
    • User: redacted
    • Query Time: 12.028176 seconds
    • Lock Time: 5.582144 seconds
    • Rows Sent: 1
    • Rows Examined: 1
    • Query: A SELECT from wpxv_aioseo_cache, part of the All in One SEO plugin for WordPress, filtering by expiration and a specific key.

    Time: 2024-03-30T12:17:32.389740Z User@Host: redacted[redacted] @ localhost [] Id: 9803 Query_time: 12.028176 Lock_time: 5.582144 Rows_sent: 1 Rows_examined: 1

    SET timestamp=1711801052;
    SELECT
    key, value
    FROM wpxv_aioseo_cache
    WHERE 1 = 1 AND
    ( expiration IS NULL OR expiration > ‘2024-03-30 12:17:19’ )
    AND key = ‘attachment_url_to_post_id_d99ed2ddbeefba28910cca4100f73b401b38bc49’
    /* 1 = 1 */;

    It took 12 seconds to execute the query, and at the end it crashed the database… Not sure why this query had any issue. Just investigating the issue and what is causing the database crash. Please look into this error.

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Ali Darwich

    (@tokyobiyori)

    SUPER-O EL MOPO

    Hi @thejosephmiller2000,

    Thanks for this report. We’re looking into this and we’ll follow up with you soon.

    Please let us know if there’s anything else we can do for you in the meantime.

    Plugin Support Ali Darwich

    (@tokyobiyori)

    SUPER-O EL MOPO

    Hi @thejosephmiller2000,

    Thanks for your patience while I checked this. Are you familiar with phpMyAdmin?

    If so, can you try running this by yourself via phpMyAdmin to see how long it takes?

    Plugin Support Ali Darwich

    (@tokyobiyori)

    SUPER-O EL MOPO

    Hi @thejosephmiller2000,

    We haven’t heard back from you in a couple of days. I’m going to go ahead and close this thread for now. But if you’d like us to assist, please feel welcome to continue the conversation.

    Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘A SELECT from wpxv_aioseo_cache SLOW query’ is closed to new replies.