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(169.60000000000002, 8%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
We have a Mysql single server and would like to log all of the queries that are run on it (not just the 'slow' ones). What settings do we need to configure to achieve this?
We have currently configured the Azure Diagnostic Settings so that the MySql Audit Logs are archived to a storage account. I can see that data is being written to that account in the following structure:
insights-metrics-pt1m/resourceId=/SUBSCRIPTIONS/
![](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)
Hi @John Robinson ,
Welcome to Microsoft Q&A platform and thanks for using Azure services.
As I understand from the question, you are unable to view the Logs stored in Storage Account for the Azure MySQL Database.
Could you please check the Storage Account which is used for the Logs storage if this Premium?
Premium Storage accounts are not supported if you sending the logs to Azure storage via diagnostics and settings
Hi ShaktiSingh,
No, that's not quite the issue. I can see that data is being written to the storage account, but it's not quite the data that I would like. I would like to log all of the queries that are run by users on mysql. I think that this is possible but I'm not sure how to set it up in Azure. Currently, none of the data appears to be written to the storage account as configured in the Azure Diagnositc Settings. Instead I can see lots of files called 'PT1H.json. I don't recognize the data that they contain, but they reference the mysql db, and are stored under the following folder structure:
resourceId=/SUBSCRIPTIONS/<subscriptionId>/RESOURCEGROUPS/PRODUCTION/PROVIDERS/MICROSOFT.DBFORMYSQL/
We currently have an Azure 'Pay as you go' plan.
Many thanks
John
Hi @John Robinson ,
Could you please share the configuration done in Azure MySQL done for Audit logs:
If not set to allLogs, how many Retention Days have been mentioned. Please check and let us know the settings from your end.
Additionally, you can use Workbooks as shown below to check the audit logs:
Reference Link: tutorial-configure-audit
Please check and let us know the settings and result you are getting. Thanks for your patience.
Hi @John Robinson ,
We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.
Hi Shakti, Sorry I was on holiday. Here is what the configuration looks like:
Hi @John Robinson ,
You can configure the storage account with see the logs generated as shown below:
For slow query log, refer to how-to-configure-server-logs-in-portal:
Hope this helps. Please let us know your inputs.
Hi @John Robinson ,
We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.
Hi Shakti,
That only logs the slow queries. I would like to be able to log all queries. We currently have the slow query logging working on the db, but it doesn't log queries that are very quick (for example, ones that use indexes etc...). I have tried setting the slow query threshold to 0, but the fast queries still do not get logged.
Hi @John Robinson ,
Did you try the option "allLogs"?
Please let us know if this option enablement helped you getting the logs. If not, I would recommend you to please file a support ticket for deeper investigation and in case if you don't have a support plan, do let us know here so that we can check on other options to unblock you. Thanks
Hi @John Robinson,
We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.
Hi Shakti,
This is working now. I selected all logs and configured them to be sent to an analytics workspace. However, I then needed to set the following server parameters:
audit_log_enabled: ON
audit
Hi @John Robinson ,
Perfect!
Good to hear that you are able to get the desired logs and appreciate you for sharing solution here with the community.
Thank you!
Hi Shakti,
This works now. I configured the Diagnostic Setting as in your screenshot and set the following server parameters:
audit
audit_log_events: DML
This logged all of the queries to the insights-logs-mysqlauditlogs blob container under the storage account configured in the diagnostic settings.
I then noticed that I only needed to send the 'MySQL Audit Logs' to the container not 'AllLogs' so updated the Diagnostic Setting. It all still works nicely.
Thankyou for all your help. It is very much appreciated.