Server System Variables
451
Type
boolean
Default
OFF
If
ON
, the server flushes (synchronizes) all changes to disk after each SQL statement. Normally,
MySQL does a write of all changes to disk only after each SQL statement and lets the operating
system handle the synchronizing to disk. See
Section C.5.4.2, “What to Do If MySQL Keeps
Crashing”
. This variable is set to
ON
if you start
mysqld
with the
--flush
[408]
option.
•
flush_time
[451]
Command-Line Format
--flush_time=#
Option-File Format
flush_time
Option Sets Variable
Yes,
flush_time
[451]
Variable Name
flush_time
Variable Scope
Global
Dynamic Variable
Yes
Permitted Values
Type
numeric
Default
0
Min
Value
0
If this is set to a nonzero value, all tables are closed every
flush_time
[451]
seconds to free up
resources and synchronize unflushed data to disk. This option is best used only on systems with
minimal resources.
•
foreign_key_checks
[451]
If set to 1 (the default), foreign key constraints for
InnoDB
tables are checked. If set to 0, they
are ignored. Disabling foreign key checking can be useful for reloading
InnoDB
tables in an order
different from that required by their parent/child relationships. See
Section 14.2.3.4, “
InnoDB
and
FOREIGN KEY
Constraints”
.
Setting
foreign_key_checks
[451]
to 0 also affects data definition statements:
DROP
DATABASE
drops a database even if it contains tables that have foreign keys that are referred to by
tables outside the database, and
DROP TABLE
drops tables that have foreign keys that are referred
to by other tables.
Note
Setting
foreign_key_checks
[451]
to 1 does not trigger a scan
of the existing table data. Therefore, rows added to the table while
foreign_key_checks = 0
[451]
will not be verified for consistency.
•
ft_boolean_syntax
[451]
Command-Line Format
--ft_boolean_syntax=name
Option-File Format
ft_boolean_syntax
Variable Name
ft_boolean_syntax
Variable Scope
Global
Dynamic Variable
Yes
Permitted Values
Type
string
Содержание 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 ...