AAA Option Optimizer

Description

This plugin tracks which of the autoloaded options are used on a page, and stores that data at the end of page render. It keeps an array of options that it has seen as being used. On the admin page, it compares all the autoloaded options to the array of stored options, and shows the autoloaded options that have not been used as you were browsing the site. If you’ve been to every page on your site, or you’ve kept the plugin around for a week or so, this means that those options probably don’t need to be autoloaded.

How to use this plugin

Install this plugin, and go through your entire site. Best is to use it normally for a couple of days, or to visit every page on your site and in your admin manually. Then go to the plugin’s settings screen, and go through the unused options. You can either decide to remove an unused option (they might for instance be for plugins you no longer use), or to set it to not autoload. The latter action is much less destructive: it’ll still be there, but it just won’t be autoloaded.

Screenshots

  • Screenshot of the admin screen, initial tab.
  • Screenshot of the “ All options” screen, showing you can browse all the options.

Installation

  1. Search for AAA Option Optimizer on the repository.
  2. Install the plugin.
  3. Wait a week or so. Or, if you’re in a hurry, click around on pages on your site, be sure to try and hit every page on your site and in your admin.
  4. Go to the plugin’s admin page and optimize your option usage.

FAQ

Why the AAA prefix in the plugin name?

Because the plugin needs to measure options being loaded, it benefits from being loaded itself first. As WordPress loads plugins alphabetically,
starting the name with AAA made sense.

Do I need to take precautions?

Yes!! Backup your database.

Where can I report bugs?

Please use our GitHub for reporting bugs or making code suggestions. Feel free to use the forums for asking questions too, of course.

For security issues, please see the next question.

How can I add recognized plugins?

Please do a pull request via GitHub on this file in the plugin.

How can I report security bugs?

You can report security bugs through the Patchstack Vulnerability Disclosure Program. The Patchstack team help validate, triage and handle any security vulnerabilities. Report a security vulnerability.

Reviews

ဒီဇင်ဘာ 9၊ 2024
Wordpress 6.6 changed the values used by the autoload field. Instead of yes, there is now on, auto-on & auto. This plugin does not include these options so can’t be used to resolve autoload issues until it is updated.
နိုဝင်ဘာ 4၊ 2024
Very useful plugin, it helped clean quite a lot amount of junks in the options table that I didn’t know existed! So, it’s a good plugin for database junk cleanup!
စက်တင်ဘာ 18၊ 2024
One of the most useful plugin ever. Thank you
စက်တင်ဘာ 12၊ 2024
This plugin could be great if you could do batch deletion. Be able to tick off the lines to be deleted and then click on a button to remove the whole thing. Also, with a search (example: “ ar_%” ), we could delete everything a plugin has left in the options at once. In short, a recently used plugin has left me dozens of useless options, and having to delete them one by one is time-consuming.
Read all 14 reviews

Contributors & Developers

“AAA Option Optimizer” is open source software. The following people have contributed to this plugin.

Contributors

“AAA Option Optimizer” has been translated into 4 locales. Thank you to the translators for their contributions.

Translate “AAA Option Optimizer” into your language.

Interested in development?

Browse the code, check out the SVN repository, or subscribe to the development log by RSS.

Changelog

1.2.1

  • Fix error in known-plugins.json.
  • Prevent fatal error when there’s an error in known-plugins.json.

1.2

Enhancements:

  • Overhaul of the UX, implementing proper tabs, better buttons and more.
  • Added a new “ All options” tab, which, when you hit the button, loads all the options from the database and allows you to manage them.
  • Added a “ Reset data” button which resets the tracking data.
  • Added a link to the Optimize Options page from the Plugins page.
  • Much improved recognition of core WordPress options, themes and plugins under “ Source” , thanks in part to pull requests from Rogier Lankhorst and system4pc.
  • You can now also filter all tables by Source so you can more easily find the options you’re looking for.
  • Many code and speed improvements under the hood, including adding a class autoloader and some i18n fixes.

1.1.1

Implement the missing functionality to create an option with value false when it’s being loaded but doesn’t exist.

1.1

The plugin now recognizes plugins from which the options came (thanks to a great pull by Rogier Lankhorst). If you’re a plugin developer and want your plugin’s options
properly recognized, please do a pull request on this file.

Small enhancements:

  • Column width is now automatically determined which leads to better spacing.
  • Action buttons are now centered in their columns.

Bugs fixed:

  • If you removed autoload from or deleted an option, it’d be removed from the table but would be back when you paginated, that’s fixed – thanks to Jono Alderson for reporting.
  • Fixed sorting by filesize by moving the KB to the table heading, so that you can now properly sort numbers.
  • Fixed issue where an empty option would result in weird size output.

1.0.2

  • Fixed a bug where the buttons wouldn’t work in a paginated state.
  • Show the value of an option in a popover, as suggested with a great pull request by @rogierlankhorst.

1.0.1

Fixed an error with values that are objects, not strings, which also caused sorting not to work for some people.

1.0

Initial release on GitHub and WordPress.org.