Software >> Services >> RDBMS >> MariaDB >> How to current system variables in the running instance

## login as root user

mysql -uroot -p

## e.g. show variables that end with log

MariaDB [(none)]> show variables like '%log';
+----------------------------------+-------+
| Variable_name                    | Value |
+----------------------------------+-------+
| back_log                         | 50    |
| general_log                      | ON    |
| innodb_locks_unsafe_for_binlog   | OFF   |
| innodb_recovery_update_relay_log | OFF   |
| log                              | ON    |
| relay_log                        |       |
| slow_query_log                   | OFF   |
| sync_binlog                      | 0     |
| sync_relay_log                   | 0     |
+----------------------------------+-------+