Database performance analysis
Perform the following steps to troubleshoot MySQL performance:
- Check if there are enough hardware resources for the database server.
- Check the configuration and status as described in [MySQL status and variables]https://doc.workfusion.com/enterprise/docs/9.0/iac/support/database/mysql-status-and-variables/).
- Check slow queries for the DB server as described in MySQL slow queries.
- Execute Data Purge for optimizing the database size. Refer to Database Data Purge.
- Analyze MySQL performance as described in MySQL configuration tuning.