# How to Optimize Your Database with JetHost Total Care

> Canonical: https://jethost.com/kb/optimize-database-with-jethost-total-care/ · Last modified: 2026-10-23T16:04:07+00:00

Over time your WordPress database fills up with old revisions, auto-drafts, spam comments, and leftover data that quietly slow your site down. The **Database Optimization** tab in [JetHost Total Care](https://wordpress.org/plugins/jethost-total-care/) cleans all of this out and optimizes your tables – no plugins to stack, no phpMyAdmin. This guide shows how to use it safely on any [JetHost WordPress hosting](https://jethost.com/hosting-for-wordpress/) plan.

## Why optimize your database

A leaner database means faster queries and a quicker site. Cleaning it helps you:

- Remove old [post revisions](https://jethost.com/kb/how-to-limit-or-disable-wordpress-post-revisions-with-jethost-total-care/), auto-drafts, and trashed content you no longer need
- Clear spam, unapproved, and trashed comments
- Delete expired transients and reclaim wasted space
- Defragment your tables so queries run faster

## Back up before you optimize

Optimization is an intensive operation. In the rare event the database server is interrupted mid-run, there is a small risk of data corruption, so always take a quick backup first for a safe restore point. You can export your database in a minute from [phpMyAdmin](https://jethost.com/kb/mysql-backup-restore/).

## Check and clean your database

1. In your WordPress dashboard, open **JetHost Total Care → Database Optimization**.
2. Click **Check Now** to scan the database. The tool reports how many items were found.
3. Tick the clean-up options you want – each shows how many items it found.
4. Click **Optimize Selected** to run only the options you chose.

The available clean-up options are:

- Optimize Database Tables
- Clean Post Revisions
- Clean Auto-draft Posts
- Clean Trashed Posts
- Delete Comments Marked as Spam
- Delete Unapproved Comments
- Delete Trashed Comments
- Clean Expired Transients
- Clean All Transients

Only tick what you’re sure about – for example, keep some post revisions if you still rely on them.

![JetHost Total Care Database Optimization tab](https://jethost.com/wp-content/uploads/2026/10/JTC-DA1.png)## Schedule automatic optimization

To keep the database tidy without remembering to do it, turn on **Enable automatic scheduled optimization** in the **Scheduled Database Optimization** panel. The plugin then runs your chosen clean-up on a regular schedule in the background, so your site stays fast over time.

## JetHost Experts Tip

Post revisions are usually the biggest space hog on an older site. Clearing them – then limiting how many WordPress keeps with the Limit Revisions option – keeps the database lean going forward.

## Need More Help?

Optimization not completing, or unsure what’s safe to clean? [Reach out](https://jethost.com/contact-us/) and our team will help keep your database healthy.