How to examine or optimize a database in DirectAdmin?
1. log in to your DirectAdmin Account.
2. In the Account Manager section, click on the MySQL Management icon or type MySQL Management in the navigation filter box. The option will appear. Click on it.
3. Under database text, select the database. You can select multiple databases for examining or optimizing them.
4. Click on the Check button to examine or click on Optimize to optimize your database.
This will display a result.