Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
757 questions
1 answer
What tools can I use to identify the cause of high CPU utilization on Azure Database for MySQL
I have an instance of Azure Database for MySQL server which the azure portal reports has a fairly constant 35% CPU utilization. I've tried running show processlist; to see if there is a query running that might explain the CPU usage, but it's all…
asked 2020-08-26T18:06:32.6+00:00
![](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(172.8, 73%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBH%3C/text%3E%3C/svg%3E)
Bjorn Hansen
1
Reputation point
answered 2020-09-01T03:46:28.243+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
unable to connect local db in linked service in data factory
make sure the SQL Database firewall allows the integration runtime to access. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance…
asked 2020-08-26T09:20:51.777+00:00
![](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(153.6, 38%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
JasperJoshua
1
Reputation point
commented 2020-08-28T06:02:37.163+00:00
Mike Ubezzi
2,776
Reputation points
2 answers
One of the answers was accepted by the question author.
Azure Database for MySQL | Recovery time objective guarantees with GRS backup replication
This question is loosely related with a previous question which was about RPO while this is about RTO. We want to understand if there are any RTO guarantees when we use the GRS backup of Azure Database for MySQL to restore in a secondary region. Let…
asked 2020-08-21T03:07:08.177+00:00
Sayan Ghosh
316
Reputation points Microsoft Employee
commented 2020-08-27T05:27:45.507+00:00
Sayan Ghosh
316
Reputation points Microsoft Employee
0 answers
What is taking up so much backup storage
My database size is ~100GB, but when I check the backup storage used it shows 1TB. The backup retention policy is on the lowest value possible. Is Azure really storing 10 copies of the database or is something else going on I'm not understanding? Thanks.
asked 2020-08-14T15:47:20.063+00:00
![](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(288, 60%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Adrian Guzman
1
Reputation point
commented 2020-08-18T16:44:20.403+00:00
![](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(281.6, 93%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
5 answers
One of the answers was accepted by the question author.
Azure Container Instance failing to connect to Azure DB for MySQL Instance
I have spun up an ACI based off a custom image hosting a strapi application, that uses the mysql js client to interface with the DB. When accessing the Azure DB for MySQL instance via a local MySQL client or a local docker container, the connection to…
asked 2020-07-20T11:36:39.34+00:00
![](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(128, 38%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENB%3C/text%3E%3C/svg%3E)
Naomi Beckford
21
Reputation points
accepted 2020-07-21T18:31:14.387+00:00
Naomi Beckford
21
Reputation points
2 answers
One of the answers was accepted by the question author.
All my apps on Azure App Service on Linux suddenly began to have error on start up
Beginning June 27(UTC), All my apps on Azure App Service on Linux began to fail to start up due to the following error. /tmp/bundle/gems/bootsnap-1.4.5/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:22:in `require': libmariadbclient.so.18:…
![](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(201.6, 72%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYY%3C/text%3E%3C/svg%3E)
1 answer
Unknown Host when connecting to MySQL Azure from Azure VM in PHP
I have an Azure Windows Server 2016 VM and a database hosted in MySQL Azure. I have the connection information from the Azure portal, and can connect to the database from MySQL workbench on the VM, as well as through powershell. However, I'm struggling…
asked 2020-07-07T07:36:41.26+00:00
![](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(294.40000000000003, 31%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Alistair Henderson
1
Reputation point
answered 2020-07-16T07:48:00.043+00:00
![](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(310.4, 12%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Alistair Henderson
1
Reputation point
2 answers
Can not perform requested operation on nested resource. Parent resource not found
Hi, When I tried to use az SQL import, I'm getting the following error, what might be the cause and solution for this? I went through this https://video2.skills-academy.com/en-us/azure/azure-resource-manager/templates/error-parent-resource but…
asked 2020-07-15T06:14:50.94+00:00
![](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(249.60000000000002, 76%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
pragadeesh.raju
41
Reputation points
commented 2020-07-16T06:47:04.923+00:00
![](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(297.6, 97%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Anurag Sharma
17,586
Reputation points
1 answer
Saving MS form attachment in sharepoint using power automate
I'd like to save MS form attachment in sharepoint by using power automate. I created the flow as below. Now there is one issues in apply to each in part of add the attachment. I get the error message as below. The error message as below: The…
asked 2020-07-13T06:19:25.653+00:00
![](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(160, 56.00000000000001%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Piyanan
1
Reputation point
answered 2020-07-13T06:29:12.517+00:00
Leon Laude
85,716
Reputation points
2 answers
One of the answers was accepted by the question author.
Azure Database for MySQL | Fail-back to primary region
Let us say we have a general purpose Azure Database for MySQL instance in a primary region (lets say AU East) with geo-replication set up on backups and the region went down went down. This resulted a customer executing their fail over process, which…
asked 2020-07-07T06:28:13.053+00:00
Sayan Ghosh
316
Reputation points Microsoft Employee
commented 2020-07-09T02:04:57.447+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
It's possible create a MASTER/Replica from Azure Database for MySQL server to MySQL on-premise?
Hello My main database is in an Azure database for MySQL server and I want it to be my MASTER and I want my on-premise base to be a REPLICA Master : Azure database for MySQL (principal database) Replica: Database On-Premise Centos (replica…
asked 2020-06-26T02:35:43.443+00:00
![](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(208, 21%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
Ligarius
21
Reputation points
commented 2020-07-08T22:12:34.71+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
How to increase pricing tier or server performance in MySQL Azure server?
I had created a mysql server with basic pricing tier of 2vCores and 10GB Storage to use it for hosting a wordpress site. But seems that the server is too slow with a loading time of more than 10 secs everytime i open a page in my. Wordpress. I can't…
asked 2020-07-07T12:18:48.923+00:00
![](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(163.2, 16%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
ROSHAN SHRIVASTAVA
1
Reputation point
answered 2020-07-07T12:36:03.703+00:00
Vaibhav Chaudhari
38,681
Reputation points
1 answer
One of the answers was accepted by the question author.
Set up Incremental Refresh in power BI
I am trying to use Incremental refresh in Power BI, bu I have these message "Before you can set up incremental refresh on this table you need to set up parameters". But the parameters was already set up before using incremental refresh
asked 2020-07-03T14:26:05.82+00:00
![](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(198.4, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
Ricardo Grijalva
21
Reputation points
accepted 2020-07-07T00:14:38.227+00:00
Ricardo Grijalva
21
Reputation points
1 answer
End of suppoet for Azure DB for mysql 5.6
May I know the mysql 5.6 end of support date of Azure DB for mysql ??
asked 2020-06-22T02:24:59.65+00:00
![](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(268.8, 27%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECK%3C/text%3E%3C/svg%3E)
Cheung, Kai Fung
1
Reputation point
answered 2020-07-01T01:25:13.563+00:00
Mike Ubezzi
2,776
Reputation points
2 answers
How do we utilize INFILE with Azure Database for MySQL?
Hello, we're using Azure Database for MySQL and would like to utilize LOAD DATA INFILE. Based on the documentation here, a current limitation is that Azure Storage must be mounted and a UNC path should be specified in the query. We have two questions: …
asked 2020-06-23T21:17:02.217+00:00
![](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(96, 82%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Steve Sanda
1
Reputation point
commented 2020-06-27T01:33:10.067+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
Creating a new view
I would like to set up a new view that shows only a set of opportunities that are related to our pilot and connect that data to a Power Bi Data
asked 2020-06-16T19:26:03.227+00:00
![](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(297.6, 73%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Rafael Arias Salas (Accenture)
1
Reputation point
answered 2020-06-26T19:46:35.997+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
Unable to read back up database file (has weird characters) and unable to import this file into azure data studio.
I have been struggling with this for a while. The documentation that is available is very confusing an not relevant. I am using a Mac operating system and have installed the latest version of azure data studio. When I open the back up file it…
asked 2020-06-02T01:48:54.007+00:00
![](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(252.8, 28.999999999999996%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Mortaza Sahar
1
Reputation point
commented 2020-06-16T00:40:11.37+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
One of the answers was accepted by the question author.
MySQL support in MyISAM format
Why doesn’t MySQL Database on Azure support databases in MyISAM format?
asked 2020-05-18T02:21:28.99+00:00
Rohan Jones
291
Reputation points
accepted 2020-06-10T21:32:16.033+00:00
Rohan Jones
291
Reputation points
2 answers
One of the answers was accepted by the question author.
Limit on databases on single server
Is there a limit to the number of databases on a single server?
asked 2020-05-18T02:19:15.917+00:00
Rohan Jones
291
Reputation points
accepted 2020-06-10T21:31:54.99+00:00
Rohan Jones
291
Reputation points
2 answers
Unable to import database file to sql server management studio because of “file contains corrupted data”
I have been struggling with this for days. I have received a backup database file from MSSQL, which has weird characters I'm not sure what type it is. I have attached it below. I used the method described in the Microsoft Learn to import a…
asked 2020-06-07T10:23:56.813+00:00
Mortaza Sahar
1
Reputation point
commented 2020-06-09T00:15:50.737+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee