Return to previous page

SQL slow query eating all RAM capacity in hosting

This topic has 2 replies, 2 voices, and was last updated 10 months, 2 weeks ago ago by Tony Rodriguez

luzactual

Participant

June 5, 2023 at 16:51

Hi. We are experiencing uptime problems with our web and the hosting provider says that this slow query (in private area) is eating all the RAM capacity. I just wanted to know, if possible, if it is something related to the theme or the WP core. ¿Can you please tell me if so, or give me a clue to follow? Thanks!

Please, contact administrator
for this information.

#358660 Copied Theme version: 9.1.6 WooCommerce version: 7.7.0

1 Answer

Tony Rodriguez

Support staff

June 6, 2023 at 06:54

Hello, @luzactual,

The provided information is a slow query log entry from your WordPress database. The query appears to be an update operation on the ‘wp_options’ table. However, without further context, it is challenging to determine whether the query is related to the theme or the WordPress core.

The slow query log entry shows the execution details of the query, including the query time, lock time, and the number of rows examined, sent, and affected. The query seems to be taking a significant amount of time (2.89 seconds) and consuming a considerable amount of RAM, which could be the cause of your uptime problems.

To further investigate the issue, we suggest trying to reach out to your hosting provider and ask them to investigate it more deeply and find the root cause of the issue.

Best Regards,
8Theme’s Team

#358681 Copied
Tagged: hosting, ram capacity, slow query, templates, woocommerce, wordpress
Viewing 2 results - 1 through 2 (of 2 total)