Azure database for MySQL Avisor recommendations reasons

sandeep pigilam 116 Reputation points
2021-06-19T03:41:56.08+00:00

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.

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
708 questions
0 comments No comments
{count} votes

Accepted answer
  1. Anurag Sharma 17,566 Reputation points
    2021-06-21T07:11:49.12+00:00

    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'

    0 comments No comments

0 additional answers

Sort by: Most helpful