Author: paul
Date: 2007-10-23 18:57:59 +0200 (Tue, 23 Oct 2007)
New Revision: 8268
Log:
r31554@polar: paul | 2007-10-23 11:56:40 -0500
Update description for Last_query_cost.
Modified:
trunk/refman-5.0/dba-core.xml
trunk/refman-5.1/dba-core.xml
trunk/refman-5.2/dba-core.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:31525
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:25981
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:31554
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:25981
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:20005
Modified: trunk/refman-5.0/dba-core.xml
===================================================================
--- trunk/refman-5.0/dba-core.xml 2007-10-23 16:52:23 UTC (rev 8267)
+++ trunk/refman-5.0/dba-core.xml 2007-10-23 16:57:59 UTC (rev 8268)
Changed blocks: 1, Lines Added: 8, Lines Deleted: 0; 791 bytes
@@ -9352,6 +9352,14 @@
</para>
<para>
+ The <literal>Last_query_cost</literal> value can be
+ computed accurately only for simple <quote>flat</quote>
+ queries, not complex queries such as those with subqueries
+ or <literal>UNION</literal>. For the latter, the value is
+ set to 0.
+ </para>
+
+ <para>
Prior to MySQL 5.0.16, this variable was not updated for
queries served from the query cache.
</para>
Modified: trunk/refman-5.1/dba-core.xml
===================================================================
--- trunk/refman-5.1/dba-core.xml 2007-10-23 16:52:23 UTC (rev 8267)
+++ trunk/refman-5.1/dba-core.xml 2007-10-23 16:57:59 UTC (rev 8268)
Changed blocks: 1, Lines Added: 8, Lines Deleted: 0; 775 bytes
@@ -9742,6 +9742,14 @@
default value is 0. <literal>Last_query_cost</literal> has
session scope.
</para>
+
+ <para>
+ The <literal>Last_query_cost</literal> value can be
+ computed accurately only for simple <quote>flat</quote>
+ queries, not complex queries such as those with subqueries
+ or <literal>UNION</literal>. For the latter, the value is
+ set to 0.
+ </para>
</listitem>
<listitem>
Modified: trunk/refman-5.2/dba-core.xml
===================================================================
--- trunk/refman-5.2/dba-core.xml 2007-10-23 16:52:23 UTC (rev 8267)
+++ trunk/refman-5.2/dba-core.xml 2007-10-23 16:57:59 UTC (rev 8268)
Changed blocks: 1, Lines Added: 8, Lines Deleted: 0; 775 bytes
@@ -9575,6 +9575,14 @@
default value is 0. <literal>Last_query_cost</literal> has
session scope.
</para>
+
+ <para>
+ The <literal>Last_query_cost</literal> value can be
+ computed accurately only for simple <quote>flat</quote>
+ queries, not complex queries such as those with subqueries
+ or <literal>UNION</literal>. For the latter, the value is
+ set to 0.
+ </para>
</listitem>
<listitem>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r8268 - in trunk: . refman-5.0 refman-5.1 refman-5.2 | paul | 23 Oct |
