Server System Variables
479
Platform
Bit Size
64
Type
numeric
Default
10
Range
1 .. 18446744073709547520
If a read or write on a communication port is interrupted, retry this many times before giving up. This
value should be set quite high on FreeBSD because internal interrupts are sent to all threads.
On Linux, the
NO_ALARM
build flag (
-DNO_ALARM
) modifies how the binary treats both
net_read_timeout
[478]
and
net_write_timeout
[479]
. With this flag enabled, neither
timer cancels the current statement until after the failing connection has been waited on an additional
net_retry_count
[478]
times. This means that the effective timeout value becomes
(timeout
setting) × (net_retr1)
.
•
net_write_timeout
[479]
Command-Line Format
--net_write_timeout=#
Option-File Format
net_write_timeout
Option Sets Variable
Yes,
net_write_timeout
[479]
Variable Name
net_write_timeout
Variable Scope
Global, Session
Dynamic Variable
Yes
Permitted Values
Type
numeric
Default
60
Min
Value
1
The number of seconds to wait for a block to be written to a connection before aborting the write.
This timeout applies only to TCP/IP connections, not to connections made using Unix socket files,
named pipes, or shared memory. See also
net_read_timeout
[478]
.
On Linux, the
NO_ALARM
build flag affects timeout behavior as indicated in the description of the
net_retry_count
[478]
system variable.
•
new
[479]
Command-Line Format
--new
-n
Option-File Format
new
Option Sets Variable
Yes,
new
[479]
Variable Name
new
Variable Scope
Global, Session
Dynamic Variable
Yes
Disabled by
skip-new
Permitted Values
Type
boolean
Default
FALSE
Содержание 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 ...