Enable and download server slow query logs of an Azure Database for MariaDB server using Azure CLI

This sample CLI script enables and downloads the slow query logs of a single Azure Database for MariaDB server.

If you don't have an Azure trail subscription, create a trial subscription before you begin.

Prerequisites

If you prefer to run CLI reference commands locally, install the Azure CLI. If you're running on Windows or macOS, consider running Azure CLI in a Docker container. For more information, see How to run the Azure CLI in a Docker container.

• If you're using a local installation, sign in to the Azure CLI by using the az login command. To finish the authentication process, follow the steps displayed in your terminal. For other sign-in options, see Sign in with the Azure CLI.

• When you're prompted, install the Azure CLI extension on first use. For more information about extensions, see Use extensions with the Azure CLI.

• Run az version to find the version and dependent libraries that are installed. To upgrade to the latest version, run az upgrade.

Sample script

Sign in to Azure

Use the following script to sign in using a different subscription, replacing <Subscription ID> with your Azure Subscription ID. If you don't have an Azure trail subscription, create a trial subscription before you begin.

az cloud set -n AzureChinaCloud
az login

subscription="<subscriptionId>" # add subscription here

az account set -s $subscription # ...or use 'az login'

For more information, see set active subscription or log in.

Run the script

# Enable server logs for MariaDB

# Variable block
let "randomIdentifier=$RANDOM*$RANDOM"
location="China East 2"
resourceGroup="msdocs-mariadb-rg-$randomIdentifier"
tag="server-logs-mariadb"
server="msdocs-mariadb-server-$randomIdentifier"
sku="GP_Gen5_2"
login="azureuser"
password="Pa$$w0rD-$randomIdentifier"
configurationParameter="slow_query_log"
logValue="On"

echo "Using resource group $resourceGroup with login: $login, password: $password..."

# Create a resource group
echo "Creating $resourceGroup in $location..."
az group create --name $resourceGroup --location "$location" --tags $tag

# Create a MariaDB server in the resource group
# Name of a server maps to DNS name and is thus required to be globally unique in Azure.
echo "Creating $server in $location..."
az mariadb server create --name $server --resource-group $resourceGroup --location "$location" --admin-user $login --admin-password $password --sku-name $sku

# List the configuration options for review
echo "Returning the configuration options on $server"
az mariadb server configuration list --resource-group $resourceGroup --server $server

# Show the value of the slow_query_log server configuration parameter
echo "Returning the value of the slow_query_log server configuration parameter on $server"
az mariadb server configuration show --name $configurationParameter --resource-group $resourceGroup --server $server

# Enable the slow_query_log 
echo "Enabling the slow_query_log on $server"
az mariadb server configuration set --name $configurationParameter --resource-group $resourceGroup --server $server --value $logValue

# List the available log files
echo "Returning the list of available log files on $server"
az mariadb server-logs list --resource-group $resourceGroup --server $server

# To download log file from Azure, direct the output of the previous comment to a text file 
# "> log_files_list.txt"
# Review the text file to find the server log file name for the desired timeframe
# Substitute the <log_file_name> in the script below with your server log file name
# Creates the log file in the current command line path
# az mariadb server-logs download --name <log_file_name> $resourceGroup --server $server

Clean up resources

Use the following command to remove the resource group and all resources associated with it using the az group delete command - unless you have an ongoing need for these resources. Some of these resources may take a while to create, as well as to delete.

az group delete --name $resourceGroup

Sample reference

This script uses the commands outlined in the following table:

Command	Notes
az group create	Creates a resource group in which all resources are stored.
az mariadb server create	Creates a MariaDB server that hosts the databases.
az mariadb server configuration list	List the configuration values for a server.
az mariadb server configuration set	Update the configuration of a server.
az mariadb server-logs list	List log files for a server.
az mariadb server-logs download	Download log files.
az group delete	Deletes a resource group including all nested resources.

Next steps

• Read more information on the Azure CLI: Azure CLI documentation.
• Try additional scripts: Azure CLI samples for Azure Database for MariaDB