Add Index To Autoload Plugin

Important: since WordPress 5.3, WordPress already has an index on the autoload field: https://core.trac.wordpress.org/ticket/24044

You don’t need this plugin if you run WP >= 5.3

Add Index To Autoload Plugin

This tool will speed up your database queries by adding an index to the “autoload” field.
With this index the query time for the autoload option will not increase with growing table size.
Therefore it helps speeding things up – especially with big option-tables.

Plugin-Overview

This plugin offers four options:

• A one-click check mechanism to check if indexes on the autoload field exist
• An option that adds an index to the autoload field
• One-click index removal
• Adding a simple wp-cronjob, that periodically checks if the index still exists and notifies you, if it doesn’t.

Support

If you encounter any issues, please leave a support ticket on the WordPress.org Forum

Bug reports

Bug reports for this Plugin are welcomed on GitHub.
Please note GitHub is not a support forum, and issues that aren’t properly qualified as bugs will be closed.

From within WordPress

1. Visit ‘Plugins > Add New’
2. Search for ‘Add Index To Autoload’
3. Activate Add Index To Autoload from your Plugins page.
4. Go to “after activation” below.

Manually

1. Upload the add-index-to-autoload folder to the /wp-content/plugins/ directory
2. Activate the Add Index To Autoload through the ‘Plugins’ menu in WordPress
3. Go to “after activation” below.

How to

1. After activation you should see a new subpage under Tools > Add Index To Autoload
2. Backup your WordPress database (optional but recommended!)
3. Go to the “Options” Section below and click the Add Index button
4. Click the Check button: You should see a success message after a couple of seconds.
   4a. If you don’t, please issue a support ticket on the WordPress.org Forum
5. Specify a periodic check for the autoload field (optional but recommended!)

1. 

   Screenshot of the management page of the plugin.

1.1.1

• Update: Checked with WordPress 5.7

1.1

• Added a check if the WordPress version is >= 5.3 if so, display a notice, that this plugin is not needed.

1.0

• Initial release