Slow queries overloading server

  • Through a lot of research, we’ve found that the below query is causing over 100 minutes of MySQL time / day, which is well above the allowed limit on our hosting.

    SELECT SQL_CALC_FOUND_ROWS  (wp_tec_occurrences.occurrence_id + 10000000) as occurrence_id
            FROM wp_posts LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = '_EventHideFromUpcoming' )
JOIN wp_tec_occurrences ON wp_posts.ID = wp_tec_occurrences.post_id 
            WHERE 1=1  AND ( 
  CAST(wp_tec_occurrences.start_date AS DATETIME) < '2023-12-22 18:00:00' 
  AND 
  wp_postmeta.post_id IS NULL
) AND wp_posts.post_type = 'tribe_events' AND ((wp_posts.post_status = 'publish')) AND (wp_posts.ID NOT IN (58249))
            GROUP BY wp_tec_occurrences.occurrence_id
            ORDER BY wp_tec_occurrences.start_date DESC, wp_posts.post_date DESC
            LIMIT 0, 1

    What is interesting though is that this is not a very complex query, but as per the slow queries log, it sometimes takes up to 30 seconds to return the results.

    Any insights would be greatly appreciated!

    WordPress version: 6.2
    The Events Calendar version: 6.0.12
    PHP version: 8.1.11
    MySQL version: 8.0.26

    • This topic was modified 1 year, 7 months ago by Dan Kobler.

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

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Author Gustavo Bordoni

    (@bordoni)

    Hi @dankobler,

    We are working on a fix for this exact problem, I cannot promise a quick fix, but we have 3 pull requests on this exact problem. We need to ensure the fix applies to all customers and doesn’t break any of the existing behavior.

    Thank you so much for reporting.

    Best Regards,

    Thread Starter Dan Kobler

    (@dankobler)

    Great news. Thank you for the quick response Gustavo. Please keep me posted if there is a workaround in the meantime. Thank you!

    same issue

    Plugin Support Darian

    (@d0153)

    Hi there.

    We will keep you posted with an update in this thread as soon as a fix for this issue is available.

    I appreciate your patience. If you have any other concerns or issues that require assistance, kindly create a new support topic following the guidelines provided in www.ads-software.com support.

    —
    Internal Bug Ticket Reference: TEC-4568

    same issue…any news?

    Plugin Support Darian

    (@d0153)

    Hi @guzza93

    Thanks for the followup. Upon checking, [TEC-4568] is still in progress.

    As soon as we release a fix for this issue, we will post an update here in the thread.

    Appreciate your patience so far. If you do have other concerns or issues you need help with, please create another support topic as indicated in the www.ads-software.com support guidelines.

    Following. This issue is killing my site.

    Currently have 107 Active connections of this taking up to 1115 seconds

    • This reply was modified 1 year, 6 months ago by markbeese.
    Plugin Support Darian

    (@d0153)

    Hi @markbeese @guzza93 @alfredo49

    Please open a new thread and include the necessary details about your issue.

    See- https://www.ads-software.com/support/forum-user-guide/faq/#i-have-the-same-problem-can-i-just-reply-to-someone-elses-post-with-me-too

    Thread Starter Dan Kobler

    (@dankobler)

    Any progress on this issue? My hosting company is being incredibly lenient, but would love to get this resolved before they make me upgrade my account.

    I have updated the plugin to version 6.1.3 and also have TEC Pro version 6.1.1 running but am still having the same issue.

    Thanks for your help!

    Plugin Support Darian

    (@d0153)

    Hi @dankobler

    We understand that you may be experiencing some difficulties with TEC-4568. Please know that we are actively working to resolve this issue and will keep you updated on any progress made in this thread.

    We appreciate your patience during this time. If you have any other concerns or issues that require assistance, unfortunately, we cannot provide support in this forum for premium users.

    For us to help you better, please open a Support Ticket on our Help Desk.

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Slow queries overloading server’ is closed to new replies.