Some common commands for mariadb

mysql> SHOW GLOBAL VARIABLES; Global variables affect the global operation of the server

Mysql> SHOW [SESSION] VARIABLES; Client variables, only valid for this session

Note: Some of these parameters support run-time modification and take effect immediately; some parameters are not supported and can only be changed by modifying the configuration file and restarting the server program

Some parameter scopes are global and immutable; some can provide individual settings for each user

Modifying the value of a server variable

Global: mysql> SET global system_var_name=value;

Mysql> SET @ @global. System_var_name=value;

Session: Mysql> SET [Session] System_var_name=value;

How to get the configuration that the program uses by default: MySQL--print-defaults mysqld--print-defaults

Some common commands for mariadb