How to optimise your WordPress database

Over time your WordPress database fills with post revisions, spam comments, transients and leftover data from deleted plugins. Cleaning it up keeps your site quick and your backups smaller.

Easy method (plugin):

1. Install WP-Optimize from Plugins → Add New.
2. Take a backup first.
3. Run the clean-up to remove old revisions, auto-drafts, trashed and spam comments, and stale transients.
4. Optionally set a weekly automatic clean.

You can also limit future bloat by capping revisions in wp-config.php: define('WP_POST_REVISIONS', 5);

Advanced: in the DirhamHost panel open phpMyAdmin, select your database, tick all tables and choose Optimize table to reclaim space. Always back up before manual work.

If your database has grown very large from an old shop or plugin, our team can help trim orphaned tables safely. Contact us on WhatsApp +971 58 553 6767 or support@dirhamaday.ae.