Delete Expired Transients vs NHR Advanced Options Table Manager & Autoload Optimizer

Delete old, expired transients from the WordPress options table (wp_options), to prevent them from bloating your database and even slowing down your website. Unless you are using an object cache (like memcached), WordPress stores transient records in the options table. Many transients are given an expiration time, so in theory they should disappear after some time. In practise, because old transients are only deleted when requested again after they’ve expired, many transients stay in the database. After a while, there can be thousands or even millions of expired transients needlessly taking up space in your options table, depending on what your plugins are doing. Delete Expired Transients schedules a daily task to delete any expired transients from the options table. It performs this operation with a single SQL query, and then runs a second query to find any orphaned expiration records and deletes them too. There are a few other plugins around that clean up expired transients. This one is written for fast performance, set-and-forget scheduled housekeeping, and maximum compatibility. It uses the PHP time to determine whether transients are expired, not the database time (which can be different). It does only one job, and it does it well with the minimum of resources. Now optimised for WordPress Multisite. Translations Many thanks to the generous efforts of our translators: English (en_CA) — the English (Canadian) translation team English (en_GB) — the English (British) translation team English (en_ZA) — the English (South African) translation team French (fr_FR) — the French translation team Hungarian (hu_HU) — the Hungarian translation team Norwegian: Bokmål (nb_NO) — neonnero Norwegian: Nynorsk (nn_NO) — neonnero Russian (ru_RU) — the Russian translation team Spanish (es_ES) — the Spanish translation team If you’d like to help out by translating this plugin, please sign up for an account and dig in. Contributions Translate into your preferred language Fork me on GitHub Privacy Delete Expired Transients does not collect any personally identifying information, and does not set any cookies. It removes some old information from the database, potentially reducing a website’s exposure to leakage of personally identifying information.

🚀 GitHub Repository – Found a bug or have a feature request? Let us know! 💬 Slack Community – Got questions or just want to chat? Come hang out with us on Slack! Are you fed up with the size of wp otions table? You are not alone! Install this plugin and get a fine view of the table and analytics. 🚀 A Powerful Yet Simple Solution to Manage wp_options Tired of an overloaded wp_options table slowing down your WordPress site? NHR Options Table Manager provides a clean, organized, and optimized way to view and manage your options table efficiently. Get detailed analytics, edit and delete options, and keep your database lean and performant. ✨ Key Features Option History & Rollback – Track all changes to individual options and restore previous versions instantly. Autoload Health Check – Analyze total autoloaded data size and identify heavy options that slow down your site. Automated Daily Cleanup – Schedule automated daily deletion of expired transients via WP Cron. Scalable Tab Architecture – Unified interface that seamlessly supports third-party tables like Better Payment and WP Recipe Maker. Manage Options – Add, edit, and delete options easily using a secure, optimized modal system. Usermeta Table Support – Edit and delete user meta entries just like options. Serialized Data Handling – Edit serialized data seamlessly; it appears as a structured object or array. Options Usage Analytics – Get visual insights into which prefixes dominate your options table. Live Search & Pagination – High-performance DataTables with server-side processing. Security & Optimization – Protection for core WordPress options to prevent accidental data loss. Import / Export – Move settings between sites easily with JSON support. Global Search & Replace – Safely replace strings across the database with dry-run preview. Orphan Scanner – Find and clean up leftovers from uninstalled plugins. WP-CLI Support – Manage options (wp nhr-options list, wp nhr-options delete) from the command line. 🚀 Coming Soon We’re constantly improving NHR Options Table Manager! Here’s what’s on the way: – Scheduled Backups – Automatically backup your wp_options table before major changes. ⚡ Easy Installation & Instant Setup No complex configurations needed! Just install, activate, and head to Tools → Options Table for a detailed DataTable view of your options. 🎯 Optimize Performance & Reduce Bloat Analyze, clean, and optimize your database by removing unnecessary options, improving site performance significantly. 🌟 Join Thousands of Happy Users Get started today and take control of your WordPress options like never before!