TEC Causing High RAM Usage?

  • Resolved Rosso Digital

    (@roberthemsing)


    1 year, 6 months ago

    We recently had a spike in our server RAM usage (twice the usual amount) and it seems to be related to the below slow query. Any idea why this is using so much RAM?

    Given the mention of ‘tribe-ea’ we assume it has to do with TEC Event Aggregator, however it also mentions ‘popup_theme’ which might be related to the Popup-Maker Plugin, too? We can’t see why there would be a query for both of those things given that they aren’t related at all?

    # Time: 2023-05-05T08:40:26.556320Z
# User@Host: redacted[redacted] @ localhost [redacted]  Id: 693725
# Schema: redacted  Last_errno: 0  Killed: 0
# Query_time: 2.101115  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0  Rows_affected: 0  Bytes_sent: 2110
use redacted;
SET timestamp=1683276026;
SELECT   une_posts.*
			FROM une_posts 
			WHERE 1=1  AND ((une_posts.post_type = 'popup_theme' AND (une_posts.post_status = 'publish' OR une_posts.post_status = 'tribe-ea-success' OR une_posts.post_status = 'tribe-ea-failed' OR une_posts.post_status = 'tribe-ea-schedule' OR une_posts.post_status = 'tribe-ea-pending' OR une_posts.post_status = 'tribe-ea-draft')))
			
			ORDER BY une_posts.post_modified DESC;
Viewing 2 replies - 1 through 2 (of 2 total)

  • Hi @roberthemsing

    Glad you reached out.

    Please go through the steps below to isolate performance issues to help narrow down the cause.

    First, follow the steps in this Conflict Testing guide exactly as instructed to eliminate any possible conflicts from other sources.

    If you have narrowed it down to a specific plugin, you’ll want to disable all plugins except The Events Calendar, or any other the plugin in question. Make sure to use the WordPress 2020 theme.

    Install Query Monitor and load the page with the issue. While on the page, click on the queries menu in the Admin Toolbar at the top of the page. This will open a menu. Inside that menu, click on the Queries tab. The list of queries on the tab will help with further research.

    If the queries involve the Events Calendar, please let us know.

    And if you are a premium user, please reach out to us via your Account and submit a support ticket.

    Plugin Support Darian

    (@d0153)

    Hi @roberthemsing

    We haven’t heard from you in a while, so I’m going to mark this as resolved. Feel free to start a new thread if you have any more questions.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘TEC Causing High RAM Usage?’ is closed to new replies.