bk commit - mysqldoc@docsrva tree (stefan:1.3007)

[stefan]

Below is the list of changes that have just been committed into a local
mysqldoc repository of stefan. When stefan does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://www.mysql.com/doc/I/n/Installing_source_tree.html

ChangeSet
  1.3007 05/07/13 16:40:19 stefan@stripped +3 -0
  mysql-database-administration.xml:
    Sync with refman
    Query cache minimum size:
    Further clarifications
    (thanks, Sanja!)

  refman-5.0/mysql-database-administration.xml
    1.28 05/07/13 16:39:48 stefan@stripped +28 -0
    Sync with refman

  refman-4.1/mysql-database-administration.xml
    1.18 05/07/13 16:39:45 stefan@stripped +28 -0
    Sync with refman

  refman/mysql-database-administration.xml
    1.26 05/07/13 16:39:17 stefan@stripped +28 -0
    Query cache minimum size:
    Further clarifications
    (thanks, Sanja!)

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	stefan
# Host:	apollon.site
# Root:	/home/stefan/bk/mysqldoc

--- 1.17/refman-4.1/mysql-database-administration.xml	2005-07-09 23:40:59 +02:00
+++ 1.18/refman-4.1/mysql-database-administration.xml	2005-07-13 16:39:45 +02:00
@@ -23255,6 +23255,34 @@
    </para>
 
    <para>
+    When setting <literal>query_cache_size</literal> to a non-zero value
+    keep in mind that the query cache needs a minimum size of about 40KB
+    to allocate its structures. (The exact size depends on 
+    architecture.) If you set the value too small, you'll get a warning,
+    like in this example:
+    <programlisting>
+mysql> <userinput>SET GLOBAL query_cache_size = 40000;</userinput>
+Query OK, 0 rows affected, 1 warning (0.00 sec)
+
+mysql> <userinput>SHOW WARNINGS\G</userinput>
+*************************** 1. row ***************************
+  Level: Warning
+   Code: 1282
+Message: Query cache failed to set size 39936; new query cache size is 0
+
+mysql> <userinput>SET GLOBAL query_cache_size = 41984;</userinput>
+Query OK, 0 rows affected (0.00 sec)
+
+mysql> <userinput>SHOW VARIABLES LIKE 'query_cache_size';</userinput>
++------------------+-------+
+| Variable_name    | Value |
++------------------+-------+
+| query_cache_size | 41984 |
++------------------+-------+
+    </programlisting>
+   </para>
+
+   <para>
     If the query cache size is greater than 0, the
     <literal>query_cache_type</literal> variable influences how it
     works. This variable can be set to the following values:

--- 1.27/refman-5.0/mysql-database-administration.xml	2005-07-09 23:40:59 +02:00
+++ 1.28/refman-5.0/mysql-database-administration.xml	2005-07-13 16:39:48 +02:00
@@ -22751,6 +22751,34 @@
    </para>
 
    <para>
+    When setting <literal>query_cache_size</literal> to a non-zero value
+    keep in mind that the query cache needs a minimum size of about 40KB
+    to allocate its structures. (The exact size depends on 
+    architecture.) If you set the value too small, you'll get a warning,
+    like in this example:
+    <programlisting>
+mysql> <userinput>SET GLOBAL query_cache_size = 40000;</userinput>
+Query OK, 0 rows affected, 1 warning (0.00 sec)
+
+mysql> <userinput>SHOW WARNINGS\G</userinput>
+*************************** 1. row ***************************
+  Level: Warning
+   Code: 1282
+Message: Query cache failed to set size 39936; new query cache size is 0
+
+mysql> <userinput>SET GLOBAL query_cache_size = 41984;</userinput>
+Query OK, 0 rows affected (0.00 sec)
+
+mysql> <userinput>SHOW VARIABLES LIKE 'query_cache_size';</userinput>
++------------------+-------+
+| Variable_name    | Value |
++------------------+-------+
+| query_cache_size | 41984 |
++------------------+-------+
+    </programlisting>
+   </para>
+
+   <para>
     If the query cache size is greater than 0, the
     <literal>query_cache_type</literal> variable influences how it
     works. This variable can be set to the following values:

--- 1.25/refman/mysql-database-administration.xml	2005-07-09 23:40:59 +02:00
+++ 1.26/refman/mysql-database-administration.xml	2005-07-13 16:39:17 +02:00
@@ -23328,6 +23328,34 @@
    </para>
 
    <para>
+    When setting <literal>query_cache_size</literal> to a non-zero value
+    keep in mind that the query cache needs a minimum size of about 40KB
+    to allocate its structures. (The exact size depends on 
+    architecture.) If you set the value too small, you'll get a warning,
+    like in this example:
+    <programlisting>
+mysql> <userinput>SET GLOBAL query_cache_size = 40000;</userinput>
+Query OK, 0 rows affected, 1 warning (0.00 sec)
+
+mysql> <userinput>SHOW WARNINGS\G</userinput>
+*************************** 1. row ***************************
+  Level: Warning
+   Code: 1282
+Message: Query cache failed to set size 39936; new query cache size is 0
+
+mysql> <userinput>SET GLOBAL query_cache_size = 41984;</userinput>
+Query OK, 0 rows affected (0.00 sec)
+
+mysql> <userinput>SHOW VARIABLES LIKE 'query_cache_size';</userinput>
++------------------+-------+
+| Variable_name    | Value |
++------------------+-------+
+| query_cache_size | 41984 |
++------------------+-------+
+    </programlisting>
+   </para>
+
+   <para>
     If the query cache size is greater than 0, the
     <literal>query_cache_type</literal> variable influences how it
     works. This variable can be set to the following values: