[Escalated to 2nd Tier] Slow website and large wp_option autoload

It looks like the REST API might be disabled on your site. To check this, we ping the REST endpoint and store the result as a transient. If that transient isn’t being set, the system keeps trying to ping repeatedly. This could be a sign there's an issue with the wp_options table in your database that's preventing transients from being saved correctly.

Can you please try the following:

1. Manually set a transient named `_transient_wp-rest-enabled-ping` with the value `enabled`. You can do this by temporarily adding the following code to your theme’s `functions.php` file or via a plugin like Code Snippets:

   add_action('init', function() {
       set_transient('wp-rest-enabled-ping', 'enabled', 12 * HOUR_IN_SECONDS);
   });

After adding it, visit your site in a browser to trigger the code, then you can safely remove it.

Alternatively, if you're using WP-CLI, run:

 wp transient set wp-rest-enabled-ping enabled 43200

2. Confirm that the transient was successfully set:
- Via database: Check your `wp_options` table and run the following SQL query:

SELECT * FROM wp_options WHERE option_name = '_transient_wp-rest-enabled-ping';

If you see a row with the value `enabled`, it’s confirmed.

- Via plugin: Install a plugin like https://wordpress.org/plugins/transients-manager, search for `wp-rest-enabled-ping`, and check if the value is set to `enabled`.

Let me know about the results!

To confirm, the transient was successfully set?

This code:

SELECT * FROM wp_options WHERE option_name = '_transient_wp-rest-enabled-ping';

returned something?