Optimize All WP Databases (WebUI Method)
- Log into cPFence WebUI and select the server you want to tune.
- Open Tools & Utilities ➜ WP-AutoShield Bulk Tools.
- In Database Tools, click Optimize All WordPress Databases.
- Hit Run Database Optimization; cPFence runs
OPTIMIZE TABLEacross every WordPress database to defragment tables and reclaim space. - Review the log output for any tables that require manual fixes.
Schedule this daily if needed to keep MySQL performance consistent.
Command Line (CLI) Method
- SSH into the server.
- Run the optimization:
cpfence --bulk-optimize-wp-databases
Follow up with LiteSpeed cache clears to keep front-end performance aligned with the optimized database.
Need Further Assistance?
Visit our Knowledgebase or contact our support team for help.
