Azure DB for MySQL – server parameters

If you have used MySQL before you will know about the system server variables, you know such commands as SHOW VARIABLES; You can access most of them via the Azure portal or connect to MySQL and issues the commands you come to know about.

Let’s see a quick example. I connect to the server and run:

MySQL [(none)]> SHOW VARIABLES LIKE ‘tx%’;

Here I am looking for the isolation level, just for example. This isn’t SQL server, inner workings and behaviours are different. I want to show how you can change something and see its reflection in the Azure portal. Hence:

MySQL [(none)]> SET tx_isolation = ‘READ-COMMITTED’;

Query OK, 0 rows affected, 1 warning (0.037 sec)

MySQL [(none)]>  SHOW VARIABLES LIKE ‘tx%’;

Go to Azure Portal > MySQL server > settings > server parameters and the transaction isolation level

So here I changed it again to serializable.

I did a restart and connect via command line and can see the updated value:

2 thoughts on “Azure DB for MySQL – server parameters

  1. Pingback: Dew Drop – February 11, 2022 (#3619) – Morning Dew by Alvin Ashcraft

  2. Pingback: Server Variables with Azure DB for MySQL – Curated SQL

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s