Find it on the Database tab.
A backup is a good idea before your first cleanup. Deleted rows cannot be brought back.
Clean up
Tick what you want to remove. Each item shows how many rows it has.
- Post revisions (the newest ones per post are kept)
- Auto-drafts
- Trashed posts and pages
- Spam comments
- Trashed comments
- Expired temporary data (transients)
- Leftover post data (meta of deleted posts)
- Pingbacks and trackbacks (not ticked by default)
Click Clean, check the number, then confirm with Yes, delete … rows for good. Autosaves are always kept.
Clean automatically
Choose How often: Off, Daily, Weekly or Monthly. The cleanup runs at a quiet hour and removes the items you ticked above. Set Revisions to keep per post: 1, 3, 5, 10 or 20. The default is 5.
Advanced
- Optimise tables frees space inside your tables. A dry run shows what will happen first.
- Convert old MyISAM tables to InnoDB. May break: very large tables can take minutes on shared hosting.