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(121.6, 91%, 21%)' 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)
I have just created an Azure Database for MySQL Flexible Server which is set to Private VNET access and I haven't connected any apps to it. Yet Azure Monitor shows constantly 18+ connections and 30+ queries, and CPU is 90%+.
Is this normal? I have tried setting up logging but when i try querying the logs using this query:
"AzureDiagnostics | where Category == 'MySqlAuditLogs' | order by TimeGenerated desc | project TimeGenerated, event_class_s, event_subclass_s, user_s, external_user_s, connection_id_d, thread_id_d, event_time_t, sql_text_s, db_s, table_s, error_code_d" but i get an error with the "event_class_s, event_subclass_s, user_s, external_user_s, connection_id_d, thread_id_d, event_time_t, sql_text_s, db_s, table_s, error_code_d" part "'project' operator: Failed to resolve scalar expression named ..." it works if i remove those but obviously doesn't give me any useful details.
Would appreciate any help with this, makes me paranoid someone is connecting to my server but don't see how this is possible, and i have seen other threads with same issue but no resolution ( https://learn.microsoft.com/en-us/answers/questions/513762/unreasonable-ammount-of-queries-and-connections-to, https://learn.microsoft.com/en-us/answers/questions/939895/why-does-my-azure-mysql-flexible-server-have-const?orderby=newest)
Thanks for any help.
Ive since connected workbench to the instance and when i view client conenctions from there i can see the following:
running show full processlist; only returns 3 entries from the user account im logged in with though.
@Josh So you do see the azure_superuser connections. That explains it
This one needs more troubleshooting I suggest raising a support case.
Thanks for the reply @GeethaThatipatri-MSFT , do you know why the Azure Superuser would be making so many client connections and queries? is this normal then? I hadnt ran anything against the database at this point so it wont be doing anything triggered by me, seems strange it would be hitting my database so much, maybe its not a big deal as im not an expert with databases on azure, was just concerning to see haha!
@Josh Thanks for the response, based on MySQL Flexible Server Tier and SKU there would be a small number of connections from Azure Super User
if it is Burstable SKU, then Burstable comes with CPU credits and once the credits are exhausted the CPU is limited till credits are added again, similar to Azure Burstable VM
If you think your question has been answered, click "Mark as Accept Answer",This can be beneficial to other community members reading this forum thread.
Regards Geetha
sorry i missed your last sentence about raising a support case, do i need to pay for the developer support package to raise a support case for something like this or is there somewhere i can raise one without it?
About the CPU Credits taking that into consideration its a bigger issue than first throught as i think this is causing my CPU to be 90% + constantly which will be using my CPU Credits at a high rate
@josh Yes it's a paid support package. so is it Burstable SKU?
Sorry for late reply, yes its burstable Burstable, B1ms, 1 vCores, 2 GiB RAM, 20 storage, 360 IOPS
Sorry for late reply , yes its burstable: Burstable, B1ms, 1 vCores, 2 GiB RAM, 20 storage, 360 IOPS. And for additional info the server still has 18 active connections and 36 queries, in last hour the Total Sum of :
Queries: 2.25k
Connections:1.07k
I did delete the original and create a new server with same specs just public with only my ip allowed to connect, and it has same issue.
@Josh can send an email with the subscription details. Don't forget to mention in the subject line ATTN: Geetha
Thanks Very Much @GeethaThatipatri-MSFT !! If the solution is shareable I will update this post in-case anyone comes across it in future.