MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 5 total results

https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html

lock_wait_timeout Command-Line Format --lock-wait-timeout=# System Variable lock_wait_timeout Scope Global, Session Dynamic Yes SET_VAR Hint Applies Yes Type Integer Default Value 31536000 Minimum Value 1 Maximum Value 31536000 Unit seconds This ...

7.1.9.2 Dynamic System Variables

https://dev.mysql.com/doc/refman/8.0/en/dynamic-system-variables.html

Many server system variables are dynamic and can be set at runtime. For a description of the privilege requirements for setting system variables, see Section 7.1.9.1, “System Variable Privileges” The following table lists all dynamic system ...

15.3.5 LOCK INSTANCE FOR BACKUP and UNLOCK INSTANCE Statements

https://dev.mysql.com/doc/refman/8.0/en/lock-instance-for-backup.html

WITH READ LOCK; LOCK INSTANCE FOR BACKUP; UNLOCK INSTANCE; UNLOCK TABLES; The lock_wait_timeout setting defines the amount of time that a LOCK INSTANCE FOR BACKUP statement waits to acquire a lock before giving up. LOCK INSTANCE FOR BACKUP UNLOCK ...

7.1.4 Server Option, System Variable, and Status Variable Reference

https://dev.mysql.com/doc/refman/8.0/en/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 ...

7.1.5 Server System Variable Reference

https://dev.mysql.com/doc/refman/8.0/en/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 ...