Memory and CPU spikes, loading problems, and access to the administration panel

toyah.es

Thanks!

Good afternoon! I’m proceeding with the update. I’ve managed to stabilize the admin panel a bit, and it seems it will now allow me to update without problems…

I’ve attached the information I received from server support regarding wp_options, in case you have any suggestions.

Hello,

We are writing to you regarding the issue you reported with the VPS server vl26649.dinaserver.com. After reviewing it, we see that the problem lies in the server running out of available RAM to handle the load generated by the hosting accounts on it continuously.

The systems department has made some adjustments to reduce RAM consumption, which should help improve server stability.

We would also recommend that you review the optimization of the website toyah.es, as it is by far the hosting account that consumes the most resources on the server.

Specifically, we see that it is sending a high number of slow queries, especially related to the wp-options table.

We attach some examples below:

# User@Host: wp-3f304d9f9a887[wp-3f304d9f9a887] @ localhost []
# Thread_id: 507279 Schema: wp_3f304d9f9a8877ca QC_hit: No
#Query_time: 4.782024 Lock_time: 2.577724 Rows_sent: 0 Rows_examined: 0
#Rows_affected: 0 Bytes_sent: 112
SET timestamp=1768986558;
SELECT option_value FROM wp_options WHERE option_name = ‘etheme_ajax_search_analytics’ LIMIT 1;

# User@Host: wp-3f304d9f9a887[wp-3f304d9f9a887] @ localhost []
# Thread_id: 507277 Schema: wp_3f304d9f9a8877ca QC_hit: No
#Query_time: 4.606576 Lock_time: 1.082004 Rows_sent: 0 Rows_examined: 0
#Rows_affected: 0 Bytes_sent: 112
SET timestamp=1768986558;
SELECT option_value FROM wp_options WHERE option_name = ‘etheme_custom_sidebars’ LIMIT 1;

Good morning! The problems have been resolved with the current website configuration. One of the tests was the one you suggested, but because the page was failing, the changes didn’t take effect when activated.

What worked best was installing Redis on the hosting provider, at least for now…

Thanks for your help.