Author: paul
Date: 2006-09-28 19:51:02 +0200 (Thu, 28 Sep 2006)
New Revision: 3497
Log:
r8716@frost: paul | 2006-09-28 12:49:47 -0500
Com_select not updated for queries served from query cache.
Modified:
trunk/refman-4.1/database-administration.xml
trunk/refman-5.0/database-administration.xml
trunk/refman-5.1/database-administration.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:14099
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:8710
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:10466
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:14099
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:8716
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:10466
Modified: trunk/refman-4.1/database-administration.xml
===================================================================
--- trunk/refman-4.1/database-administration.xml 2006-09-28 17:25:01 UTC (rev 3496)
+++ trunk/refman-4.1/database-administration.xml 2006-09-28 17:51:02 UTC (rev 3497)
Changed blocks: 1, Lines Added: 5, Lines Deleted: 1; 887 bytes
@@ -7937,7 +7937,11 @@
statement. For example, <literal>Com_delete</literal> and
<literal>Com_insert</literal> count
<literal>DELETE</literal> and <literal>INSERT</literal>
- statements.
+ statements, respectively. However, if a query result is
+ returned from query cache, the server increments the
+ <literal>Qcache_hits</literal> status variable, not
+ <literal>Com_select</literal>. See
+ <xref linkend="query-cache-status-and-maintenance"/>.
</para>
<para>
Modified: trunk/refman-5.0/database-administration.xml
===================================================================
--- trunk/refman-5.0/database-administration.xml 2006-09-28 17:25:01 UTC (rev 3496)
+++ trunk/refman-5.0/database-administration.xml 2006-09-28 17:51:02 UTC (rev 3497)
Changed blocks: 1, Lines Added: 5, Lines Deleted: 1; 901 bytes
@@ -8495,7 +8495,11 @@
statement. For example, <literal>Com_delete</literal> and
<literal>Com_insert</literal> count
<literal>DELETE</literal> and <literal>INSERT</literal>
- statements, respectively.
+ statements, respectively. However, if a query result is
+ returned from query cache, the server increments the
+ <literal>Qcache_hits</literal> status variable, not
+ <literal>Com_select</literal>. See
+ <xref linkend="query-cache-status-and-maintenance"/>.
</para>
<para>
Modified: trunk/refman-5.1/database-administration.xml
===================================================================
--- trunk/refman-5.1/database-administration.xml 2006-09-28 17:25:01 UTC (rev 3496)
+++ trunk/refman-5.1/database-administration.xml 2006-09-28 17:51:02 UTC (rev 3497)
Changed blocks: 3, Lines Added: 8, Lines Deleted: 4; 1845 bytes
@@ -363,7 +363,7 @@
<emphasis role="bold">Note</emphasis>: Not all storage engines
are supported by all MySQL server binaries and configurations.
To find out how to determine which storage engines are
- supported by your MySQL server installation, see
+ supported by your MySQL server installation, see
<xref linkend="show-engines"/>.
</para>
@@ -4059,11 +4059,11 @@
<literal>DISABLED</literal>, with the default being
<literal>OFF</literal>. This variable and its effects on
the Event Scheduler's operation are discussed in greater
- detail in the
+ detail in the
<link linkend="events-event-scheduler-option">Overview
section of the Events chapter</link>.
</para>
-
+
<para>
This variable was added in MySQL 5.1.6.
</para>
@@ -8537,7 +8537,11 @@
statement. For example, <literal>Com_delete</literal> and
<literal>Com_insert</literal> count
<literal>DELETE</literal> and <literal>INSERT</literal>
- statements, respectively.
+ statements, respectively. However, if a query result is
+ returned from query cache, the server increments the
+ <literal>Qcache_hits</literal> status variable, not
+ <literal>Com_select</literal>. See
+ <xref linkend="query-cache-status-and-maintenance"/>.
</para>
<para>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r3497 - in trunk: . refman-4.1 refman-5.0 refman-5.1 | paul | 28 Sep |
