Where are the MySQL Flexible Server Log Analytics tables documented?

Question

I cannot find documentation for the list of Log Analytics tables available for querying when I set my Azure MySQL Flexible Server diagnostics to send to Log Analytics. If I click on the Logs menu item in the Azure Portal, it drops me to Log Analytics. The page I land on claims that the resource type I am working with is Azure Database for MySQL Flexible Servers but there are only three example queries: Audit general events, Audit connection events and Audit connection events that appears to be a "longest queries" type query. All three example queries fail. It appears that the table names are unknown.
Where are these table names documented? This is such a poor user experience.

Answer 1

@JohnSebastian-3934 Thanks for your question. As you have mentioned that you have enabled diagnostic settings for Azure Database for MySQL server, I assume that you are looking for the Audit Logs and Slow Logs. You can check the logs in AzureDiagnostics Table.

For more information refer below documents

• Audit Logs : https://learn.microsoft.com/en-us/azure/mysql/single-server/concepts-audit-logs
• Slow Logs: https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-slow-query-logs

Also, to know the logs table by resource type, you can refer this document: https://learn.microsoft.com/en-us/azure/azure-monitor/reference/tables/tables-resourcetype