![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_1646196506.webp)
Server System Variables
486
Option
Description
0
or
OFF
Do not cache results in or retrieve results from the query cache. Note that
this does not deallocate the query cache buffer. To do that, you should set
query_cache_size
[485]
to 0.
1
or
ON
Cache all cacheable query results except for those that begin with
SELECT
SQL_NO_CACHE
.
2
or
DEMAND
Cache results only for cacheable queries that begin with
SELECT SQL_CACHE
.
This variable defaults to
ON
.
Any unique prefix of a valid value may be used to set the value of this variable.
•
query_cache_wlock_invalidate
[486]
Command-Line Format
--query_cache_wlock_invalidate
Option-File Format
query_cache_wlock_invalidate
Option Sets Variable
Yes,
query_cache_wlock_invalidate
[486]
Variable Name
query_cache_wlock_invalidate
Variable Scope
Global, Session
Dynamic Variable
Yes
Permitted Values
Type
boolean
Default
FALSE
Normally, when one client acquires a
WRITE
lock on a
MyISAM
table, other clients are not blocked
from issuing statements that read from the table if the query results are present in the query cache.
Setting this variable to 1 causes acquisition of a
WRITE
lock for a table to invalidate any queries in
the query cache that refer to the table. This forces other clients that attempt to access the table to
wait while the lock is in effect.
•
query_prealloc_size
[486]
Command-Line Format
--query_prealloc_size=#
Option-File Format
query_prealloc_size
Option Sets Variable
Yes,
query_prealloc_size
[486]
Variable Name
query_prealloc_size
Variable Scope
Global, Session
Dynamic Variable
Yes
Permitted Values
Platform
Bit Size
32
Type
numeric
Default
8192
Range
8192 .. 4294967295
Block
Size
1024
Permitted Values
Содержание 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 ...