Description
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
- Visit ‘Plugins > Add New’
- Search for ‘Add Index To Autoload’
- Activate Add Index To Autoload from your Plugins page.
- Go to “after activation” below.
Manually
- Upload the
add-index-to-autoload
folder to the/wp-content/plugins/
directory - Activate the Add Index To Autoload through the ‘Plugins’ menu in WordPress
- Go to “after activation” below.
How to
- After activation you should see a new subpage under Tools > Add Index To Autoload
- Backup your WordPress database (optional but recommended!)
- Go to the “Options” Section below and click the Add Index button
- 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 - Specify a periodic check for the autoload field (optional but recommended!)
Screenshots
FAQ
-
Can this plugin break my database?
-
We have tested this plugin on +10000 WordPress-sites and on none did this plugin break anything.
But, we still recommend to backup your WordPress website, before using it.
Reviews
Contributors & Developers
“Add Index To Autoload” is open source software. The following people have contributed to this plugin.
ContributorsTranslate “Add Index To Autoload” into your language.
Interested in development?
Browse the code, check out the SVN repository, or subscribe to the development log by RSS.
Changelog
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