Azure database for MySQL Avisor recommendations reasons

Question

Azure database for MySQL resource is provided with some Avisor(preview) recommendations by microsoft.

My question is on what metrics these recommendations are provided?

Here are the two recommendations .

1. Improve MYSQL connection management
2. Improve MYSQL connection latency.

Are these recommendations provided based on active connections? I mean if database resource (like cpu )is under utilized and then also why these recommendations ?

So wanted to know on what metrics these recommendations are provided.

Answer 1

Hi @sandeep pigilam , welcome to Microsoft Q&A forum.

As per the article, "Advisor analysis can indicate that your application connecting to a MySQL server might not be managing connections efficiently. This condition could lead to unnecessary resource consumption and overall higher application latency. To improve connection management, we recommend that you reduce the number of short-lived connections and eliminate unnecessary idle connections. You can make these improvements by configuring a server-side connection pooler, like ProxySQL"

So, even if the connection is not active(idle connection) or it is short-lived connection or current resource utilization is less
, advisor will provide the recommendation to improve on them as they could result in more resource utilization which could and should be better managed.

Please let me know if this helps.

----------

If answer helps, you can mark it 'Accept Answer'