Log in to WHM as root.

Search for "SQL Services" in the left sidebar.

Select "Repair a Database".

Choose the specific database that needs optimization and click Repair.

Alternatively, use "Check a Database" to identify any corruption or tables that need maintenance.

Pro Tip (Command Line): For a deeper optimization, log in via SSH and run: mysqlcheck -o --all-databases This command will optimize all tables in all databases on your server at once.