Over time databases collect bloat - old revisions, spam, expired transients - that slows queries. To clean it up:
- On WordPress, the LiteSpeed Cache plugin has a Database tab that removes post revisions, trashed items, spam comments and expired transients in one click.
- For any site, open phpMyAdmin from cPanel, select your database, tick the tables and choose Optimize table to reclaim space and rebuild indexes.
Also limit how many post revisions WordPress keeps, and uninstall plugins that leave large unused tables. Always take a backup before bulk cleaning - you can create one in cPanel's Backup tool first. A leaner database means faster page loads and lower CPU use, helping you stay within your account's resource limits. Unsure which tables are safe to clean? Open a ticket.
