![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_1646196502.webp)
Server System Variables
482
The path name of the plugin directory. This variable was added in MySQL 5.0.67. If the value is
nonempty, user-defined function object files must be located in this directory. If the value is empty,
the behavior that is used before 5.0.67 applies: The UDF object files must be located in a directory
that is searched by your system's dynamic linker.
If the plugin directory is writable by the server, it may be possible for a user to write executable code
to a file in the directory using
SELECT ... INTO DUMPFILE
. This can be prevented by making
plugin_dir
[481]
read only to the server or by setting
--secure-file-priv
[419]
to a
directory where
SELECT
writes can be made safely.
•
port
[482]
Command-Line Format
--port=#
-P
Option-File Format
port
Option Sets Variable
Yes,
port
[482]
Variable Name
port
Variable Scope
Global
Dynamic Variable
No
Permitted Values
Type
numeric
Default
3306
Range
0 .. 65535
The number of the port on which the server listens for TCP/IP connections. This variable can be set
with the
--port
[417]
option.
•
preload_buffer_size
[482]
Command-Line Format
--preload_buffer_size=#
Option-File Format
preload_buffer_size
Option Sets Variable
Yes,
preload_buffer_size
[482]
Variable Name
preload_buffer_size
Variable Scope
Global, Session
Dynamic Variable
Yes
Permitted Values
Type
numeric
Default
32768
Range
1024 .. 1073741824
The size of the buffer that is allocated when preloading indexes.
•
prepared_stmt_count
[482]
Version Introduced
5.0.21
Version Removed
5.0.31
Variable Name
prepared_stmt_count
Variable Scope
Global
Dynamic Variable
No
Содержание 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 ...