Oracle 5.0, Справочное руководство

Страница: 498 / 3232

Server System Variables
478
up to
max_allowed_packet
[466] bytes as needed. The result buffer shrinks to
net_buffer_length
[477] after each SQL statement.
This variable should not normally be changed, but if you have very little memory, you can set it to the
expected length of statements sent by clients. If statements exceed this length, the connection buffer
is automatically enlarged. The maximum value to which
net_buffer_length
[477] can be set is
1MB.
As of MySQL 5.0.84, the session value of this variable is read only. Before 5.0.84, setting the
session value is permitted but has no effect.
•
net_read_timeout
[478]
Command-Line Format
--net_read_timeout=#
Option-File Format
net_read_timeout
Option Sets Variable Yes,
net_read_timeout
[478]
Variable Name
net_read_timeout
Variable Scope Global, Session
Dynamic Variable Yes
Permitted Values
Type
numeric
Default
30
Min
Value
1
The number of seconds to wait for more data from a connection before aborting the read.
This timeout applies only to TCP/IP connections, not to connections made through Unix
socket files, named pipes, or shared memory. When the server is reading from the client,
net_read_timeout
[478] is the timeout value controlling when to abort. When the server is
writing to the client,
net_write_timeout
[479] is the timeout value controlling when to abort.
See also
slave_net_timeout
[1466] .
On Linux, the
NO_ALARM
build flag affects timeout behavior as indicated in the description of the
net_retry_count
[478] system variable.
•
net_retry_count
[478]
Command-Line Format
--net_retry_count=#
Option-File Format
net_retry_count
Option Sets Variable Yes,
net_retry_count
[478]
Variable Name
net_retry_count
Variable Scope Global, Session
Dynamic Variable Yes
Permitted Values
Platform
Bit Size
32
Type
numeric
Default
10
Range
1 .. 4294967295
Permitted Values