question

spigilam avatar image
0 Votes"
spigilam asked AnuragSharma-MSFT answered

Azure database for MySQL Avisor recommendations reasons

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-mysql
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AnuragSharma-MSFT avatar image
0 Votes"
AnuragSharma-MSFT answered

Hi @spigilam, 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'




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.