https://dev.mysql.com/replication-features-variables.html
sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the slave always preserves its own value for NO_DIR_IN_CREATE, regardless of changes to it on the master. However, when mysqlbinlog parses a SET @@sql_mode = mode statement, the full ...
https://dev.mysql.com/server-option-variable-reference.html
The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...
https://dev.mysql.com/server-options.html
For information about the implications for binary logging and replication, see the description for SYSDATE() in Section 12.7, “Date and Time Functions” and for SET TIMESTAMP in Section 5.1.8, “Server System Variables”. When you start the ...
https://dev.mysql.com/server-system-variable-reference.html
The following table lists all system variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables (System Var), and status variables (Status var) in ...
https://dev.mysql.com/show-columns.html
on update CURRENT_TIMESTAMP for TIMESTAMP or DATETIME columns that have the ON UPDATE CURRENT_TIMESTAMP attribute. SHOW [EXTENDED] [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW COLUMNS ...
https://dev.mysql.com/show-create-trigger.html
This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers. SHOW CREATE TRIGGER trigger_name This statement shows the CREATE TRIGGER statement that creates the named trigger. This statement requires the TRIGGER ...
https://dev.mysql.com/show-processlist.html
For a slave SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the slave machine. SHOW [FULL] PROCESSLIST SHOW PROCESSLIST shows which threads are running. If you have the PROCESS ...
https://dev.mysql.com/show-triggers.html
This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers. SHOW TRIGGERS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TRIGGERS lists the triggers currently defined for tables in a database (the default ...
https://dev.mysql.com/show-variables.html
SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'pattern' | WHERE expr] SHOW VARIABLES shows the values of MySQL system variables (see Section 5.1.8, “Server System Variables”). System variable information is also available from these sources: ...
https://dev.mysql.com/sys-metrics.html
This view summarizes MySQL server metrics to show variable names, values, types, and whether they are enabled. The metric type determines the source from which the name is taken: For global status variables: The VARIABLE_NAME column of the ...
