This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 74%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETD%3C/text%3E%3C/svg%3E)
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?
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
Hi @GeethaThatipatri-MSFT ,
I do as you write. So I switch to configuration: Standard_D2ds_v4 (2 vCores, EUR 62.48 per vCore) - General Purpose (2-64 vCores) - Balanced configuration for most common workloads with 1026 IOPS. Also I added small delay between each call to database like 200ms (with slowdown is about 16 database operations per second - 8 just select and 8 insert to one table).
But it didn't help, after 2 days of processing I also get error "Lost connection to MySQL server during query" (the same as earlier - the only difference was that I do not lost MySQL server instance and message "Failed to load MySQL flexible server databases." - message gone). So it's looks like MySQL engine internal problem.
By the weekend I will make a solution for this case to try reconnect to database in loop until it will be acquired and try to continue the process for the success case (if any).
It is possible to get server logs for flexible instance ? (I found a way to catch server logs for standalone one or binary logs via SQL command for flexible one - but I need a server logs one for flexible azure solutions).
Regards,
Jan
@Terma Developers I would recommend raising a support case to understand what happened at that time. Currently, the support team can check the server logs, for flexible servers we have plans to expose error logs however, we don't have any timeline on when that will be public.
I would also recommend using batching while inserting so that you must not keep the connection live for a longer period.
Regards
Geetha
@Terma Developers We haven't heard back from you. Just wanted to check if you got a chance to raise a support case or please let me know if you need any additional information.
Regards
Geetha
@GeethaThatipatri-MSFT Thank you. I am going to implement it as you wrote. I didn't make a support case yet because as I understand I need to have a Maintenance Plan for it. I would love to have access to logs in the future. I think that such a problem may occur for someone else too so it may be good if you can analyze it from your side.
Edit: I added a support case for it with registered request number: 2207190050000801 .
*for Big Data I am using Azure DB without any problems yet (but here is another project to native connectin with other systems in such technologies - other technology stack)
Regards,
Jan
@Terma Developers Thanks for creating a support case and sharing the case number here.
Regards
Geetha
The case is investigated. As a workaround here I can confirm that it looks that delayed reconnecting to db with the proper level of capacity in the case of "Lost connection to MySQL server during query" works.
@Terma Developers Thanks for updating that your issue is now resolved.
Thank you for visiting the Microsoft QA forums! Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community
Regards
Geetha