Author: paul
Date: 2007-10-17 20:27:23 +0200 (Wed, 17 Oct 2007)
New Revision: 8154
Log:
r25749@frost: paul | 2007-10-17 13:24:10 -0500
Corrections re: query cache support for prepared statements in 5.1+.
Minor grammar revisions.
Modified:
trunk/refman-4.1/optimization.xml
trunk/refman-5.0/optimization.xml
trunk/refman-5.1/optimization.xml
trunk/refman-5.2/optimization.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:31118
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:25733
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:20005
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:31118
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:25749
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:20005
Modified: trunk/refman-4.1/optimization.xml
===================================================================
--- trunk/refman-4.1/optimization.xml 2007-10-17 17:54:25 UTC (rev 8153)
+++ trunk/refman-4.1/optimization.xml 2007-10-17 18:27:23 UTC (rev 8154)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 667 bytes
@@ -7931,7 +7931,7 @@
<note>
<para>
The query cache is not used for server-side prepared
- statements. If you are using server-side prepared statements
+ statements. If you are using server-side prepared statements,
consider that these statements will not be satisfied by the
query cache. See <xref linkend="c-api-prepared-statements"/>.
</para>
Modified: trunk/refman-5.0/optimization.xml
===================================================================
--- trunk/refman-5.0/optimization.xml 2007-10-17 17:54:25 UTC (rev 8153)
+++ trunk/refman-5.0/optimization.xml 2007-10-17 18:27:23 UTC (rev 8154)
Changed blocks: 1, Lines Added: 3, Lines Deleted: 3; 821 bytes
@@ -10209,9 +10209,9 @@
<note>
<para>
The query cache is not used for server-side prepared
- statements. If you're using server-side prepared statements
- consider that these statement won't be satisfied by the query
- cache. See <xref linkend="c-api-prepared-statements"/>.
+ statements. If you are using server-side prepared statements,
+ consider that these statements will not be satisfied by the
+ query cache. See <xref linkend="c-api-prepared-statements"/>.
</para>
</note>
Modified: trunk/refman-5.1/optimization.xml
===================================================================
--- trunk/refman-5.1/optimization.xml 2007-10-17 17:54:25 UTC (rev 8153)
+++ trunk/refman-5.1/optimization.xml 2007-10-17 18:27:23 UTC (rev 8154)
Changed blocks: 1, Lines Added: 5, Lines Deleted: 3; 920 bytes
@@ -10381,9 +10381,11 @@
<note>
<para>
The query cache is not used for server-side prepared
- statements. If you're using server-side prepared statements
- consider that these statement won't be satisfied by the query
- cache. See <xref linkend="c-api-prepared-statements"/>.
+ statements before MySQL 5.1.17. If you are using server-side
+ prepared statements, consider that these statements will not
+ be satisfied by the query cache. As of 5.1.17, the query cache
+ is used under the conditions described in
+ <xref linkend="query-cache-how"/>.
</para>
</note>
Modified: trunk/refman-5.2/optimization.xml
===================================================================
--- trunk/refman-5.2/optimization.xml 2007-10-17 17:54:25 UTC (rev 8153)
+++ trunk/refman-5.2/optimization.xml 2007-10-17 18:27:23 UTC (rev 8154)
Changed blocks: 1, Lines Added: 0, Lines Deleted: 9; 796 bytes
@@ -10368,15 +10368,6 @@
</para>
</note>
- <note>
- <para>
- The query cache is not used for server-side prepared
- statements. If you're using server-side prepared statements
- consider that these statement won't be satisfied by the query
- cache. See <xref linkend="c-api-prepared-statements"/>.
- </para>
- </note>
-
<para>
Some performance data for the query cache follows. These results
were generated by running the MySQL benchmark suite on a Linux
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r8154 - in trunk: . refman-4.1 refman-5.0 refman-5.1 refman-5.2 | paul | 17 Oct |
