Score:1

Azure App Service to Azure MySQL Flexible Server Latency

sa flag

I have an old ASP.NET MVC website I've moved to Azure that runs super slow on there.

I've set up:

  • App Service (Standard S1 plan)
  • Azure Database for MySQL flexible server (Burstable, Standard B1ms - 1Vcore, 2G mem, 640 iops).

The site is working but there seems to be a huge delay on connecting from the site to the DB then it suddenly springs to life.

  • The App Service is 'Always On'.
  • The DB connection is using SSL.
  • App and DB are in the same Azure region.

Admittedly, the site is quite old now but there is no scope to update it. It was running on a very expensive dedicated Windows server and was (obviously) much faster.

Are there any 'go to' things to check in this setup that could account for the slowness or is it more likely a matter of old obsolete/inefficient code is what it is?

I'm tempted to throw a little more power on the DB side but I don't know if that will make much difference.

Wilson Hauck avatar
jp flag
Additional DB information request, please. Any SSD or NVME devices on MySQL Host server? Post TEXT data on justpaste.it and share the links. From your SSH login root, Text results of: A) SELECT COUNT(*), sum(data_length), sum(index_length), sum(data_free) FROM information_schema.tables; B) SHOW GLOBAL STATUS; after minimum 24 hours UPTIME C) SHOW GLOBAL VARIABLES; D) SHOW FULL PROCESSLIST; E) STATUS; not SHOW STATUS, just STATUS; G) SHOW ENGINE INNODB STATUS; for server workload tuning analysis to provide RAM conserving suggestions.
Score:0
ng flag

The B1 SKU is a burstable VM, and a small one at that. It has 1 core, but when you are not bursting you are only getting 10% of that, which is not very much at all. If you use all your burst credits, or you reboot the VM, which resets the burst count, then you will be running at 10% of a core, nowhere near enough for MYSQL.

You need to increase the VM size.

I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.