Problems with stability of Azure database for MySQL flexible server

Terma Developers 1 Reputation point
2022-07-11T11:08:25.23+00:00

I encounter stability problems with my Azure database for MySQL flexible server instance. I try to add about 1,5 mln records and after about 0,5 mln inserts I lost connection to the server (after one day of inserting). From this time the database was unstable. The queries were timeout and sometimes the connection to the database was not possible. The health status in Azure Platform was Available but from time to time in the Database Settings instead of databases (schemas) list I get failed message "Failed to load MySQL flexible server databases.". I am at the development stage with minimal resources as "Standard_B1ms (1 vCore)".

Restart the server fix it. But I am not sure if this will happen again (I need to repeat such imports and from month to month I will add or update thousands of records like that).

And I need to know what happens so is there any possibility to see server logs about it? If yes, how can I do it?

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

1 answer

Sort by: Most helpful
  1. GeethaThatipatri-MSFT 25,837 Reputation points Microsoft Employee
    2022-07-12T03:25:26.183+00:00

    Hi, @Terma Developers Welcome to the Microsoft Q&A Platform, and thanks for your query.
    You can throttle the query by checking the load on the database so that server can take up the load.
    as you mentioned Standard_B1ms 1v core won't help much.
    Also please try re-connecting the mysql.

    Regards
    Geetha