Advisor

Nexaa’s Cloud Database Advisor is tool to help you in optimizing your database, so you can use your resources more efficiently. This is done through analysis on different data. The results of the analysis can be seen in the portal, these results are advices and do not guarantee improvements. Always judge if an advice should be implemented.

The current version of the advisor supports MySQL and PostgreSQL. The advisor executes an analysis on a daily basis at 0:00 UTC time. At the moment the advisor is only reachable through the portal.

Getting started

To get start with the Advisor you just need to enable it in the Advisor tab of the cloud database that you want. Below you can see the advisor is enabled for the cloud database cluster analyser.

Supported advisories

Index Recommendations: The advisor analyzes SELECT queries to identify opportunities for performance improvements through indexing. This analysis is performed on tables with 1,000 or more rows to ensure meaningful recommendations. The system first checks whether queries are already utilizing existing indexes and then provides guidance on whether new indexes should be created to optimize query performance.

It's important to carefully evaluate these recommendations before implementation, as indexes can have trade-offs. While they significantly improve read performance, they may negatively impact write-heavy tables by slowing down INSERT, UPDATE, and DELETE operations. Additionally, indexes consume additional storage space and can affect memory usage, so consider your database's specific workload patterns when deciding whether to implement the suggested indexes.

What to expect in the future

In the future we will expend the area's that we give advice on. Some examples are: memory pooling and caching. We also want to make it possible that the advisor can be enabled from our terraform provider, the nexaa CLI and our GraphQL API.