![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_16461961633.webp)
MySQL Server Options and Variables for MySQL Cluster
1613
Option Sets Variable
Yes,
ndb_cache_check_time
[1612]
Variable Name
ndb_cache_check_time
Variable Scope
Global
Dynamic Variable
Yes
Permitted Values
Type
numeric
Default
0
The number of milliseconds that elapse between checks of MySQL Cluster SQL nodes by the
MySQL query cache. Setting this to 0 (the default and minimum value) means that the query cache
checks for validation on every query.
The recommended maximum value for this variable is 1000, which means that the check is
performed once per second. A larger value means that the check is performed and possibly
invalidated due to updates on different SQL nodes less often. It is generally not desirable to set this
to a value greater than 2000.
•
ndb_force_send
[1613]
Command-Line Format
--ndb-force-send
Option-File Format
ndb_force_send
Option Sets Variable
Yes,
ndb_force_send
[1613]
Variable Name
ndb_force_send
Variable Scope
Global, Session
Dynamic Variable
Yes
Permitted Values
Type
boolean
Default
TRUE
Forces sending of buffers to
NDB
immediately, without waiting for other threads. Defaults to
ON
.
•
ndb_index_stat_cache_entries
[1613]
Command-Line Format
--ndb_index_stat_cache_entries
Option-File Format
ndb_index_stat_cache_entries
Permitted Values
Type
numeric
Default
32
Range
0 .. 4294967295
Sets the granularity of the statistics by determining the number of starting and ending keys to store
in the statistics memory cache. Zero means no caching takes place; in this case, the data nodes are
always queried directly. Default value:
32
.
•
ndb_index_stat_enable
[1613]
Command-Line Format
--ndb_index_stat_enable
Option-File Format
ndb_index_stat_enable
Permitted Values
Type
boolean
Содержание 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 ...