SeoPageHost

SeoCms Post Archival System lets you move old posts and custom post types to a separate archive database, keeping your main WordPress database lean and fast.
Key Features:
<ul>
<li>Age-based archival rules — Configure per-post-type rules (e.g., archive posts older than 180 days)</li>
<li>Custom post type support — Works with any registered post type</li>
<li>Full data preservation — Archives posts, post meta, and taxonomy relationships</li>
<li>One-click restore — Restore archived posts back to the main database with all metadata intact</li>
<li>Scheduled archival — Automate archival via WP-Cron (hourly, daily, weekly, or monthly)</li>
<li>Manual batch runs — Run archival on-demand from the dashboard</li>
<li>Archive browser — Search, filter, and browse archived posts from the admin panel</li>
<li>Front-end search — Use the <code>[seocpoar_search]</code> shortcode to let visitors search archived content</li>
<li>Activity logging — Full audit trail of all archive and restore actions</li>
</ul>
How It Works:
<ol>
<li>Configure a second MySQL database in Settings</li>
<li>Set up archival rules per post type with age thresholds</li>
<li>Run archival manually or on a schedule</li>
<li>Archived posts are moved to the separate database with all their metadata</li>
<li>Browse and restore archived posts at any time</li>
</ol>
Shortcode Usage:
Display a searchable archive browser on any page:
<pre><code>[seocpoar_search]
[seocpoar_search per_page="20"]
[seocpoar_search per_page="10" post_type="post"]
</code></pre>

SeoCms Post Archival System

Archive old posts and custom post types to a separate database based on configurable age rules.

Joost de Valk

Ari Stathopoulos

Progress Planner

Filip Ilić

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.
<h3>How to use this plugin</h3>
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.

AAA Option Optimizer

And I love the speed in which improvements are made :)

Great tool to minimize autoloaded data size


I wonder how on earth a plugin tha promises to optimize the wp_options tables, stores 25MB of data in the option_value !!!! Maybe the guy who developed it does not understand the fundamentals of the internal database optimizers but such a huge deviation, totally ruins MariaDBs/MySQL internal optimizer. You see optimizers work on the assumption that in a table, the fields have somewhat related sizes. For more details please go to MariaDB Jira and check for cases MDEV-34097 and MDEV 32663If you add records with huge sizes (say > 100k) in wp_options table where each option is usually less than 30Bytes, then you have an issue. In our case the issue was caused by the very plugin that we used to monitor our options (that are by and large incorrect). Avoid it at all costs.


A joke!!!

Plugin that tracks autoloaded options usage and allows the user to optimize them.

SeoCms Post Archival System vs AAA Option Optimizer