![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_1646196457.webp)
Server System Variables
437
[mysqld]
init_connect='SET autocommit=0'
The content of
init_connect
[456]
is not executed for users that have the
SUPER
[578]
privilege.
•
automatic_sp_privileges
[437]
Version Introduced
5.0.3
Variable Name
automatic_sp_privileges
Variable Scope
Global
Dynamic Variable
Yes
Permitted Values
Type
boolean
Default
TRUE
When this variable has a value of 1 (the default), the server automatically grants the
EXECUTE
[577]
and
ALTER ROUTINE
[576]
privileges to the creator of a stored routine, if the
user cannot already execute and alter or drop the routine. (The
ALTER ROUTINE
[576]
privilege is
required to drop the routine.) The server also automatically drops those privileges from the creator
when the routine is dropped. If
automatic_sp_privileges
[437]
is 0, the server does not
automatically add or drop these privileges.
The creator of a routine is the account used to execute the
CREATE
statement for it. This might not
be the same as the account named as the
DEFINER
in the routine definition.
See also
Section 18.2.2, “Stored Routines and MySQL Privileges”
.
This variable was added in MySQL 5.0.3.
•
back_log
[437]
Command-Line Format
--back_log=#
Option-File Format
back_log
Option Sets Variable
Yes,
back_log
[437]
Variable Name
back_log
Variable Scope
Global
Dynamic Variable
No
The number of outstanding connection requests MySQL can have. This comes into play when the
main MySQL thread gets very many connection requests in a very short time. It then takes some
time (although very little) for the main thread to check the connection and start a new thread. The
back_log
[437]
value indicates how many requests can be stacked during this short time before
MySQL momentarily stops answering new requests. You need to increase this only if you expect a
large number of connections in a short period of time.
In other words, this value is the size of the listen queue for incoming TCP/IP connections. Your
operating system has its own limit on the size of this queue. The manual page for the Unix
listen()
system call should have more details. Check your OS documentation for the maximum
value for this variable.
back_log
[437]
cannot be set higher than your operating system limit.
•
basedir
[437]
Command-Line Format
--basedir=path
Содержание 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 ...