InnoDB
Startup Options and System Variables
1244
6
The crash recovery mode. Possible values are from 0 to 6. The meanings of these values are
described in
Section 14.2.5.2, “Forcing
InnoDB
Recovery”
.
Warning
This variable should be set greater than 0 only in an emergency situation
when you want to dump your tables from a corrupt database! As a safety
measure,
InnoDB
prevents any changes to its data when this variable is
greater than 0.
•
innodb_lock_wait_timeout
Command-Line Format
--innodb_lock_wait_timeout=#
Option-File Format
innodb_lock_wait_timeout
Option Sets Variable
Yes,
innodb_lock_wait_timeout
[1244]
Variable Name
innodb_lock_wait_timeout
Variable Scope
Global
Dynamic Variable
No
Permitted Values
Type
numeric
Default
50
Range
1 .. 1073741824
The timeout in seconds an
InnoDB
transaction may wait for a row lock before giving up. The default
value is 50 seconds. A transaction that tries to access a row that is locked by another
InnoDB
transaction will hang for at most this many seconds before issuing the following error:
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
When a lock wait timeout occurs, the current statement is not executed. The current transaction
is not rolled back. (Until MySQL 5.0.13
InnoDB
rolled back the entire transaction if a lock
wait timeout happened. You can restore this behavior by starting the server with the
--
innodb_rollback_on_timeout
[1249]
option, available as of MySQL 5.0.32. See also
Section 14.2.11, “
InnoDB
Error Handling”
.)
innodb_lock_wait_timeout
[1244]
applies to
InnoDB
row locks only. A MySQL table lock does
not happen inside
InnoDB
and this timeout does not apply to waits for table locks.
InnoDB
does detect transaction deadlocks in its own lock table immediately and rolls back one
transaction. The lock wait timeout value does not apply to such a wait.
•
innodb_locks_unsafe_for_binlog
Command-Line Format
--innodb_locks_unsafe_for_binlog
Option-File Format
innodb_locks_unsafe_for_binlog
Option Sets Variable
Yes,
innodb_locks_unsafe_for_binlog
[1244]
Variable Name
innodb_locks_unsafe_for_binlog
Variable Scope
Global
Dynamic Variable
No
Deprecated
5.6.3
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...