Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
716 questions
1 answer
Azure Database for MySQL flexible server unexpected increase in CPU usage
I'm running a base B-tier burstable Azure Database for MySQL instance that holds the data for a Strapi CMS backend for a client NextJS website. The CMS and subsequently the database are are not being accessed regularly, only for data updates and the…
asked 2024-05-07T19:57:52.45+00:00
Owen Abkes
0
Reputation points
answered 2024-05-07T20:15:25.4333333+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(236.8, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Rahul Randive
8,521
Reputation points Microsoft Employee
0 answers
Unable to resolve Azure database for mysql name from Data Factory
I am creating a linked service from my Azure Data Factory environment, to access my Azure Database for Mysql database. I select "Azure database for Mysql", and I can see all my mysql servers. I select "From Azure subscription" as the…
asked 2024-05-07T07:39:15.9766667+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, 71%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIS%3C/text%3E%3C/svg%3E)
Ignacio Sales
5
Reputation points
edited a comment 2024-05-07T13:21:52.0733333+00:00
PRADEEPCHEEKATLA-MSFT
77,901
Reputation points Microsoft Employee
4 answers
One of the answers was accepted by the question author.
SSIS Error when deploying package, the locale identifier LCID is not supported by SQL Server
Hi I am unable to deploy my project from Visual Studio to SSISDB. I have tried to change my localename and locale as well as my region. I have also made MYSQL Server login local but the below error still persists. Can anyone provide guidance TITLE: SQL…
asked 2021-05-03T11:51:51.583+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(80, 74%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELC%3C/text%3E%3C/svg%3E)
Lynn Carelse
21
Reputation points
answered 2024-05-06T23:54:14.06+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, 6%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Santiago Guerrero Toro
0
Reputation points
1 answer
Azure database for MySQL - foreign key checks option
Hello M, Can you help us with a variable to manage the foreign_key_checks option is basic variable to migrate data.
asked 2021-10-14T15:05:39.163+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(54.400000000000006, 98%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
Jesus Gaibor Yanez
1
Reputation point
commented 2024-05-06T16:26:47.0766667+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(32, 87%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
Dario Carta Mantiglia
5
Reputation points
0 answers
!!Email_me_if_you_want_your_database_dbfile@proton.me
!!Email_me_if_you_want_your_database_dbfile@proton.me This appeared in my MySql server on an Azure VM. They also deleted 30 database. It looks like it is an empty database and they just used the name to send a message. The database can not be dropped Is…
asked 2024-05-03T09:07:59.83+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(259.20000000000005, 20%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPH%3C/text%3E%3C/svg%3E)
Phillip Hamilton
0
Reputation points
commented 2024-05-04T07:34:27.2833333+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(102.4, 13%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sailesh kumar
0
Reputation points
2 answers
Connecting to MySQL Flexible Server in Azure suddenly failing
I have a MySQL instance in Azure which has run fine for about 2+ years. I have a Function App which inserts some data into on a monthly basis which has failed this month with the following error: Result: Failure Exception: InterfaceError: 2026 (HY000):…
asked 2024-04-02T15:08:03.6733333+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(236.8, 72%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Chris Sadler
10
Reputation points
commented 2024-05-01T17:14:51.4933333+00:00
Oury Ba-MSFT
16,471
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Using REPLICATE_REWRITE_DB in Azure MySQL database
Database names in my Master and Replica server are different. Master DB name - uas-tms-20211111 Slave DB name - uas-tms-uat To get the replication working in this scenario, we use REPLICATE_REWRITE_DB option in on-prem MySQL servers. …
asked 2024-04-23T12:20:53.6433333+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, 43%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Srikar Gondesi - UAS Database Administrator
85
Reputation points
commented 2024-04-29T12:18:04.9633333+00:00
Srikar Gondesi - UAS Database Administrator
85
Reputation points
1 answer
Azure MySQL Flexible Server Extremely Slow
I have a database server (MySQL Flexible) and it was working fine, but the last few days it has become very slow. There were no changes in the application, the code of application did not change. In the information_schema.processlist there are no active…
asked 2024-04-04T16:08:44.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(156.8, 72%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EID%3C/text%3E%3C/svg%3E)
Igor Deutsch
0
Reputation points
commented 2024-04-27T10:21:15.4133333+00:00
Rahul Randive
8,521
Reputation points Microsoft Employee
1 answer
Deployment for MySQL server fails
I'm trying to set up my first MySQL server on azure, but deployment keeps failing with error: { "status": "Failed", "error": { "code": "AzureKeyVaultKeyNotFound", …
asked 2023-04-20T07:53:50.0966667+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(57.599999999999994, 90%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECN%3C/text%3E%3C/svg%3E)
»CLØnÊ« Who
0
Reputation points
commented 2024-04-27T10:09:43.21+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(105.60000000000001, 42%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETM%3C/text%3E%3C/svg%3E)
Tim Murphy
0
Reputation points
1 answer
Azure Database for MySQl Flexible - High CPU - No increase in workload
I have an Azure Web App that is connected to an Azure Database for MySQL Flexible server. This web app is a small data collection form that stores the collected values to a table which are later collected via am API in the web app. A cron job executes…
asked 2024-04-03T11:31:42.51+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(3.2, 87%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jon Bromley
5
Reputation points
answered 2024-04-26T14:38:19.3+00:00
Rahul Randive
8,521
Reputation points Microsoft Employee
2 answers
100% CPU on Empty MySQL Instance
Hello, I recently setup an Azure mySQL Database. It is type Standard_B1s (small yes). I have not created any databases at all. The only thing in there is the default database mySQL comes with. There are no users, no-one connecting to it. Looking at…
asked 2024-04-01T23:18:33.1233333+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(67.2, 5%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jason Bennett
10
Reputation points
edited a comment 2024-04-26T14:35:02.6866667+00:00
Rahul Randive
8,521
Reputation points Microsoft Employee
1 answer
What's going on with the flexible mysql database ?
Hello, For several days now, I've been experiencing completely unexplained cpu load peaks on my flexible mysql server (B1MS). No metrics, no maintenance, no increase in requests or connections are to blame at this time. As proof, I've disconnected my…
asked 2024-04-09T08:30:32.0566667+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(112.00000000000001, 67%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZ%3C/text%3E%3C/svg%3E)
Zhaerius
5
Reputation points
answered 2024-04-26T14:33:05.9233333+00:00
Rahul Randive
8,521
Reputation points Microsoft Employee
2 answers
Deleted table restore
Is it possible to recover the deleted table in azure database ? if yes please tell me how ?
asked 2024-04-26T01:28:18.4566667+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(169.60000000000002, 47%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVG%3C/text%3E%3C/svg%3E)
VIKAS GOLE
0
Reputation points
answered 2024-04-26T03:51:00.6133333+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(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
13,516
Reputation points Microsoft Employee
2 answers
Unable to create an Azure MySQL flexible server
I am receiving an error message when trying to create a new Azure MySQL flexible server database in the Southeast Asia region. The error states that "Subscription <name> is not allowed to provision in Southeast Asia." I already have one…
asked 2024-02-26T06:13:34.3666667+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(28.799999999999997, 61%, 12%)' 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)
LonLee
11
Reputation points
commented 2024-04-24T05:28:33.35+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(188.79999999999998, 15%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEC%3C/text%3E%3C/svg%3E)
Elvin Cheah
0
Reputation points
2 answers
Is there any transactional SQL for creating firewall rule using sp_set_firewall_rule in Azure MI
Hi Team, Can you please let us know, is there any transactional SQL for creating firewall rules using sp_set_firewall_rule in Azure Managed Instance? Thanks, Abhishek Modi
asked 2024-04-22T12:26:02.4033333+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(80, 77%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Abhishek Modi (amodi)
0
Reputation points
answered 2024-04-22T15:03:28.0966667+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(134.4, 95%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Abhishek-MSFT
181
Reputation points Microsoft Employee
1 answer
I am using the Student version of Microsoft azure. Can I create Data lake and Data warehouse with this version?
I am student in CIT , Coimbatore.I want to explore the concepts of Data warehouse so I choosed Microsoft azure student version.Can I create warehouse in this version if not please suggest another platforms to create effective warehouses for free.
asked 2024-04-18T05:01:48.5133333+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(137.6, 25%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHK%3C/text%3E%3C/svg%3E)
Harish Kumar
0
Reputation points
edited an answer 2024-04-18T07:38:57.85+00:00
Sumarigo-MSFT
43,806
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Increasing usage of MySQL server
Hello, When I go to the Top free services by usage section in Subscriptions>Overview, I notice continuous increasing in the "Azure Database for MySQL, Flexible Server Storage, Data Stored" usage. It is increasing daily although i stopped…
asked 2024-03-30T08:53:18.47+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(240, 64%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Mohmmed Magdy
30
Reputation points
commented 2024-04-16T10:43:15.95+00:00
Mohmmed Magdy
30
Reputation points
1 answer
PowerBI Service connection fails to Azure Database for MySQL flexible server
Hello, I created a semantic model connected to my Azure Database for MySQL flexible server. It refreshes successfully from powerbi desktop, but once the dashboard is published, it does not refresh anymore. The error I am getting is: …
asked 2024-04-13T14:44:34.5566667+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(182.40000000000003, 67%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPY%3C/text%3E%3C/svg%3E)
Peter Yacoub
0
Reputation points
answered 2024-04-15T15:06:47.6+00:00
GeethaThatipatri-MSFT
27,717
Reputation points Microsoft Employee
1 answer
Private link / VNet integration between App Service and MySQL Database
Hello, Between an App Service and an Azure Database for MySQL I created a Private Link with VNet integration, so that the Database for MySQL is only reachable through the App Service and not through the public internet. When looking at the App…
asked 2024-04-11T16:25:04.0466667+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(51.2, 32%, 14%)' 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)
JohnC92
0
Reputation points
answered 2024-04-15T08:15:52.5433333+00:00
KapilAnanth-MSFT
35,501
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Cost anomaly mySQL 76% Memory, "Paid IO LRS IO Rate Operations" at $20/m for inactive (dev) wordpress website
For a Wordpress website in development almost inactive, the cost of the Azure Database MySQL is at IOPS CA$20/month, and it says the CPU at 7% but Memory constantly at 74% , and the bulk of the cost comes from "Paid IO LRS IO Rate…
asked 2023-10-30T09:49:55.7133333+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(217.60000000000002, 64%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Christopher Mary
20
Reputation points
edited an answer 2024-04-15T07:14:05.8766667+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(201.6, 49%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPL%3C/text%3E%3C/svg%3E)
Peter Lekkerkerker
0
Reputation points