The Slow Query Log Is Written As. The general query log and the slow query log can also be written to special tables in the mysql database. The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be examined.
Or alternatively you can set the this options in the mycnfmyini option files. It can also help debug MySQL crashes because unlike other log formats the query is written to this log file before MySQL attempts to execute. By default the slow query log is written to hostname-slowlog in the datadir directory.
Queries are written to the slow query log after all locks have been released.
If None the slow query log will only be written to Azure Monitor Diagnostics Logs. Queries are written to the slow query log after all locks have been released. It can be changed dynamically with SET GLOBAL. The slow query logs will show you a list of queries that have been identified as slow based on the given values in the system variables as mentioned earlier.