Author: jstephens
Date: 2006-06-07 13:35:52 +0200 (Wed, 07 Jun 2006)
New Revision: 2298
Log:
Updating description of ndb_cache_check_time variable. (Thanks, Magnus!)
Modified:
trunk/refman-4.1/database-administration.xml
trunk/refman-5.0/database-administration.xml
trunk/refman-5.1/database-administration.xml
Modified: trunk/refman-4.1/database-administration.xml
===================================================================
--- trunk/refman-4.1/database-administration.xml 2006-06-07 08:51:24 UTC (rev 2297)
+++ trunk/refman-4.1/database-administration.xml 2006-06-07 11:35:52 UTC (rev 2298)
@@ -5067,15 +5067,22 @@
</para>
<para>
- The number of seconds to wait before checking the
+ The number of milliseconds to wait before checking the
<literal>NDB</literal> query cache. Setting this to
<literal>0</literal> (the default and minimum value) means
that the <literal>NDB</literal> query cache will be
- checked for validation upon each query. A large value
- means the <literal>NDB</literal> query cache will seldom
- be checked and invalidated because of updates on another
+ checked for validation on every query.
+ </para>
+
+ <para>
+ The recommended maximum value for this variable is
+ <literal>1000</literal>, which means that the query cache
+ is checked once per second. A larger value means the
+ <literal>NDB</literal> query cache is less often checked
+ and invalidated due to updates on a different
<command>mysqld</command>. It is generally not desirable
- to set this to a value greater than <literal>2</literal>.
+ to set this to a value greater than
+ <literal>2000</literal>.
</para>
</listitem>
Modified: trunk/refman-5.0/database-administration.xml
===================================================================
--- trunk/refman-5.0/database-administration.xml 2006-06-07 08:51:24 UTC (rev 2297)
+++ trunk/refman-5.0/database-administration.xml 2006-06-07 11:35:52 UTC (rev 2298)
@@ -5396,15 +5396,22 @@
</para>
<para>
- The number of seconds to wait before checking the
+ The number of milliseconds to wait before checking the
<literal>NDB</literal> query cache. Setting this to
<literal>0</literal> (the default and minimum value) means
that the <literal>NDB</literal> query cache will be
- checked for validation upon each query. A large value
- means the <literal>NDB</literal> query cache will seldom
- be checked and invalidated because of updates on another
+ checked for validation on every query.
+ </para>
+
+ <para>
+ The recommended maximum value for this variable is
+ <literal>1000</literal>, which means that the query cache
+ is checked once per second. A larger value means the
+ <literal>NDB</literal> query cache is less often checked
+ and invalidated due to updates on a different
<command>mysqld</command>. It is generally not desirable
- to set this to a value greater than <literal>2</literal>.
+ to set this to a value greater than
+ <literal>2000</literal>.
</para>
</listitem>
Modified: trunk/refman-5.1/database-administration.xml
===================================================================
--- trunk/refman-5.1/database-administration.xml 2006-06-07 08:51:24 UTC (rev 2297)
+++ trunk/refman-5.1/database-administration.xml 2006-06-07 11:35:52 UTC (rev 2298)
@@ -5748,15 +5748,22 @@
</para>
<para>
- The number of seconds to wait before checking the
+ The number of milliseconds to wait before checking the
<literal>NDB</literal> query cache. Setting this to
<literal>0</literal> (the default and minimum value) means
that the <literal>NDB</literal> query cache will be
- checked for validation upon each query. A large value
- means the <literal>NDB</literal> query cache will seldom
- be checked and invalidated because of updates on another
+ checked for validation on every query.
+ </para>
+
+ <para>
+ The recommended maximum value for this variable is
+ <literal>1000</literal>, which means that the query cache
+ is checked once per second. A larger value means the
+ <literal>NDB</literal> query cache is less often checked
+ and invalidated due to updates on a different
<command>mysqld</command>. It is generally not desirable
- to set this to a value greater than <literal>2</literal>.
+ to set this to a value greater than
+ <literal>2000</literal>.
</para>
</listitem>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r2298 - in trunk: refman-4.1 refman-5.0 refman-5.1 | jon | 7 Jun |
