Server Command Options
423
Dynamic Variable
Yes
Set the SQL mode. See
Section 5.1.7, “Server SQL Modes”
.
•
--sysdate-is-now
[423]
Version Introduced
5.0.20
Command-Line Format
--sysdate-is-now
Option-File Format
sysdate-is-now
Permitted Values
Type
boolean
Default
FALSE
As of MySQL 5.0.12,
SYSDATE()
[928]
by default returns the time at which it executes, not the
time at which the statement in which it occurs begins executing. This differs from the behavior
of
NOW()
[926]
. This option causes
SYSDATE()
[928]
to be an alias for
NOW()
[926]
. For
information about the implications for binary logging and replication, see the description for
SYSDATE()
[928]
in
Section 12.7, “Date and Time Functions”
and for
SET TIMESTAMP
in
Section 5.1.4, “Server System Variables”
.
This option was added in MySQL 5.0.20.
•
--tc-heuristic-recover={COMMIT|ROLLBACK}
[423]
Version Introduced
5.0.3
Command-Line Format
--tc-heuristic-recover=name
Option-File Format
tc-heuristic-recover
Permitted Values
Type
enumeration
Valid
Values
COMMIT
RECOVER
The type of decision to use in the heuristic recovery process. Currently, this option is unused. Added
in MySQL 5.0.3.
•
--temp-pool
[423]
Command-Line Format
--temp-pool
Option-File Format
temp-pool
Permitted Values
Type
boolean
Default
TRUE
This option causes most temporary files created by the server to use a small set of names, rather
than a unique name for each new file. This works around a problem in the Linux kernel dealing with
creating many new files with different names. With the old behavior, Linux seems to “leak” memory,
because it is being allocated to the directory entry cache rather than to the disk cache.
•
--transaction-isolation=level
[423]
Command-Line Format
--transaction-isolation=name
Option-File Format
transaction-isolation
Содержание 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 ...