Oracle 5.0, Reference Manual

Page: 493 / 3232

Server System Variables
473
Variable Scope Global, Session
Dynamic Variable Yes
Permitted Values
Type
numeric
Default
0
Range
0 .. 4294967295
The maximum number of simultaneous connections permitted to any given MySQL user account. A
value of 0 (the default) means “no limit.”
Before MySQL 5.0.3, this variable has only a global value that can be set at server startup or
runtime. As of MySQL 5.0.3, it also has a read-only session value that indicates the effective
simultaneous-connection limit that applies to the account associated with the current session. The
session value is initialized as follows:
• If the user account has a nonzero
MAX_USER_CONNECTIONS
resource limit, the session
max_user_connections
[472] value is set to that limit.
• Otherwise, the session
max_user_connections
[472] value is set to the global value.
Account resource limits are specified using the
GRANT
statement. See Section 6.3.4, “Setting
Account Resource Limits” , and Section 13.7.1.3, “
GRANT
Syntax” .
•
max_write_lock_count
[473]
Command-Line Format
--max_write_lock_count=#
Option-File Format
max_write_lock_count
Option Sets Variable Yes,
max_write_lock_count
[473]
Variable Name
max_write_lock_count
Variable Scope Global
Dynamic Variable Yes
Permitted Values
Platform
Bit Size
32
Type
numeric
Default
4294967295
Range
1 .. 4294967295
Permitted Values
Platform
Bit Size
64
Type
numeric
Default
18446744073709547520
Range
1 .. 18446744073709547520
After this many write locks, permit some pending read lock requests to be processed in between.
•
myisam_data_pointer_size
[473]
Command-Line Format
--myisam_data_pointer_size=#
Option-File Format
myisam_data_pointer_size