PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
At times, it may be more efficient to disable deadlock detection and rely on the innodb_lock_wait_timeout setting for transaction rollback when a deadlock occurs. innodb_lock_wait_timeout Command-Line Format --innodb-lock-wait-timeout=# System ...
https://dev.mysql.com/doc/refman/5.7/en/glossary.html
innodb_lock_wait_timeout The innodb_lock_wait_timeout option sets the balance between waiting for shared resources to become available, or giving up and handling the error, retrying, or doing alternative processing in your application. These terms ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlock-detection.html
Resolve these situations by setting the value of the innodb_lock_wait_timeout system variable. At times, it may be more efficient to disable deadlock detection and rely on the innodb_lock_wait_timeout setting for transaction rollback when a deadlock ... When deadlock detection is enabled (the default), InnoDB automatically detects transaction deadlocks and rolls back a transaction or transactions to break the ...
https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html
If deadlock detection is disabled using the innodb_deadlock_detect configuration option, InnoDB relies on the innodb_lock_wait_timeout setting to roll back transactions in case of a deadlock. If you have MyISAM tables that you want to convert to ...
https://dev.mysql.com/doc/refman/5.7/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 5.1.8.1, “System Variable Privileges” The following table lists all dynamic system ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlocks.html
If deadlock detection is disabled using the innodb_deadlock_detect variable, InnoDB relies on the innodb_lock_wait_timeout setting to roll back transactions in case of a deadlock. A deadlock is a situation in which multiple transactions are unable ...
https://dev.mysql.com/doc/refman/5.7/en/internal-locking.html
At times, it may be more efficient to disable deadlock detection and rely on the innodb_lock_wait_timeout setting for transaction rollback when a deadlock occurs. This section discusses internal locking; that is, locking performed within the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-timeout.html
The total retry count can be seen in the output of SHOW STATUS; see Section 5.1.9, “Server Status Variables”.
https://dev.mysql.com/doc/refman/5.7/en/replication-options-replica.html
This section explains the server options and system variables that apply to replicas and contains the following: Startup Options for Replicas Options for Logging Replica Status to Tables System Variables Used on Replicas Specify the options either ...
https://dev.mysql.com/doc/refman/5.7/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 ...