Error 500 when fetching 1000 plus data in mysql DB

Category: azure database for mysql

Question

BurnzTechnical on Fri, 29 Jun 2018 04:02:58


Query limit < 1000 Okay but took time (a bit acceptable)

Query limit sample Total Count: 1319 (error page 500)



Replies

MohitGarg_MSFT on Fri, 29 Jun 2018 21:10:00


Hi,

Please refer to this article which gives good understanding of Connection Timeout Parameters In MySQL.

Please check this document on How to configure server parameters in Azure Database for MySQL by using the Azure portal and see if adjusting any of the required parameter helps with your issue.