Server System Variables
465
Permitted Values
Platform
Bit Size
64
Type
numeric
Default
1
Range
0 .. 18446744073709547520
Whether to produce additional warning messages. It is enabled (1) by default and can be disabled by
setting it to 0. Aborted connections are not logged to the error log unless the value is greater than 1.
•
long_query_time
[465]
Command-Line Format
--long_query_time=#
Option-File Format
long_query_time
Option Sets Variable
Yes,
long_query_time
[465]
Variable Name
long_query_time
Variable Scope
Global, Session
Dynamic Variable
Yes
Permitted Values (<= 5.0.20)
Type
numeric
Default
10
Min
Value
1
If a query takes longer than this many seconds, the server increments the
Slow_queries
[531]
status variable. If you are using the
--log-slow-queries
[412]
option, the query is logged to
the slow query log file. This value is measured in real time, not CPU time, so a query that is under
the threshold on a lightly loaded system might be above the threshold on a heavily loaded one. The
minimum value is 1. The default is 10. See
Section 5.2.4, “The Slow Query Log”
.
•
low_priority_updates
[465]
Command-Line Format
--low-priority-updates
Option-File Format
low-priority-updates
Option Sets Variable
Yes,
low_priority_updates
[465]
Variable Name
low_priority_updates
Variable Scope
Global, Session
Dynamic Variable
Yes
Permitted Values
Type
boolean
Default
FALSE
If set to
1
, all
INSERT
,
UPDATE
,
DELETE
, and
LOCK TABLE WRITE
statements wait until there is no
pending
SELECT
or
LOCK TABLE READ
on the affected table. This affects only storage engines that
use only table-level locking (such as
MyISAM
,
MEMORY
, and
MERGE
). This variable previously was
named
sql_low_priority_updates
.
•
lower_case_file_system
[465]
Command-Line Format
--lower_case_file_system[=#]
Содержание 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 ...