Configuration.md

Configuration

Options

mysqld --verbose --help

my.cnf

Variables

-- VARIABLES
SHOW GLOBAL VARIABLES ;
SHOW SESSION VARIABLES ;
-- STATUS
SHOW GLOBAL STATUS ;
SHOW SESSION STATUS ;

SQL Modes

• characteristics
• behavior

SELECT @@sql_mode;
+--------------------------------------------+
| @@sql_mode                                 |
+--------------------------------------------+
| STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |
+--------------------------------------------+
1 row in set (0.00 sec)

Reference

• server-configuration