Author: paul
Date: 2010-11-16 03:42:39 +0100 (Tue, 16 Nov 2010)
New Revision: 23762
Log:
r65569@frost: paul | 2010-11-15 20:38:04 -0500
Document bug fixes:
- Bug#30025: Mysqld prints out warnings/errors being run with --no-defaults --help
- Bug#35269: mysqlcheck behaves different depending on order of parameters
- Bug#51099: Assertion in mysql_multi_delete_prepare()
- Bug#55744: GROUP_CONCAT + CASE + ucs return garbage
- Bug#56822: Add a thread state for sessions waiting on the query cache lock
- Bug#57039: queries using subtime in the where condition returns incorrect data
Modified:
trunk/dynamic-docs/changelog/mysqld-1.xml
trunk/dynamic-docs/changelog/mysqld-2.xml
trunk/refman-5.5/optimization.xml
trunk/refman-5.6/optimization.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/mysqldoc/trunk:35498
07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/trunk:44270
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:43968
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/trunk:44480
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:65561
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:39036
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/trunk:39546
+ 07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/mysqldoc/trunk:35498
07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/trunk:44270
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:43968
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/trunk:44480
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:65569
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:39036
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/trunk:39546
Modified: trunk/dynamic-docs/changelog/mysqld-1.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-1.xml 2010-11-16 01:13:29 UTC (rev 23761)
+++ trunk/dynamic-docs/changelog/mysqld-1.xml 2010-11-16 02:42:39 UTC (rev 23762)
Changed blocks: 2, Lines Added: 3, Lines Deleted: 2; 1004 bytes
@@ -1694,8 +1694,8 @@
<para>
It is now possible to assign indexes on partitioned
<literal role="se">MyISAM</literal> tables to key caches using
- the <literal role="stmt">CACHE INDEX</literal> and to preload such
- indexes into the cache using
+ the <literal role="stmt">CACHE INDEX</literal> and to preload
+ such indexes into the cache using
<literal role="stmt" condition="load-index">LOAD INDEX INTO
CACHE</literal> statements. Cache assignment and preloading of
indexes for such tables can be performed for one, several, or
@@ -48837,6 +48837,7 @@
</bugs>
<versions>
+ <version ver="5.6.1"/>
<version ver="6.0.6"/>
</versions>
Modified: trunk/dynamic-docs/changelog/mysqld-2.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-2.xml 2010-11-16 01:13:29 UTC (rev 23761)
+++ trunk/dynamic-docs/changelog/mysqld-2.xml 2010-11-16 02:42:39 UTC (rev 23762)
Changed blocks: 1, Lines Added: 148, Lines Deleted: 0; 2896 bytes
@@ -31853,4 +31853,152 @@
</logentry>
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="mysqlcheck"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="35269"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.5.7"/>
+ </versions>
+
+ <message>
+
+ <para>
+ <command>mysqlcheck</command> behaved differently depending on
+ the order in which options were given on the command line.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <bugs>
+ <fixes bugid="30025"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.5.7"/>
+ </versions>
+
+ <message>
+
+ <para>
+ When invoked to display a help message,
+ <command>mysqld</command> also displayed spurious warning or
+ error messages.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="feature">
+
+ <tags>
+ <manual type="query cache"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="56822"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.5.7"/>
+ </versions>
+
+ <message>
+
+ <para>
+ Added a new <literal role="stmt">SHOW PROCESSLIST</literal>
+ state, <literal>Waiting for query cache lock</literal>. This
+ indicates that a session is waiting to take the query cache lock
+ while it performs some query cache operation.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="CASE"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="55744"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.5.7"/>
+ </versions>
+
+ <message>
+
+ <para>
+ <literal role="op">CASE</literal> expressions with a mix of
+ operands in different character sets sometimes returned
+ incorrect results.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="SUBTIME()"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="57039"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.5.7"/>
+ </versions>
+
+ <message>
+
+ <para>
+ Constant <literal role="func">SUBTIME()</literal> expressions
+ could return incorrect results.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <bugs>
+ <fixes bugid="51099"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.5.7"/>
+ </versions>
+
+ <message>
+
+ <para>
+ An assertion could be raised by
+ <literal role="stmt">DELETE</literal> on a view that referenced
+ another view which in turn (directly or indirectly) referenced
+ more than one table.
+ </para>
+
+ </message>
+
+ </logentry>
+
</changelog>
Modified: trunk/refman-5.5/optimization.xml
===================================================================
--- trunk/refman-5.5/optimization.xml 2010-11-16 01:13:29 UTC (rev 23761)
+++ trunk/refman-5.5/optimization.xml 2010-11-16 02:42:39 UTC (rev 23762)
Changed blocks: 1, Lines Added: 28, Lines Deleted: 0; 1452 bytes
@@ -15255,6 +15255,34 @@
</para>
</listitem>
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>Waiting for query cache lock</primary>
+ <secondary>thread state</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>thread state</primary>
+ <secondary>Waiting for query cache lock</secondary>
+ </indexterm>
+
+ <literal>Waiting for query cache lock</literal>
+ </para>
+
+ <para>
+ This state occurs while a session is waiting to take the
+ query cache lock. This can happen for any statement that
+ needs to perform some query cache operation, such as an
+ <literal role="stmt">INSERT</literal> or
+ <literal role="stmt">DELETE</literal> that invalidates the
+ query cache, a <literal role="stmt">SELECT</literal> that
+ looks for a cached entry,
+ <literal role="stmt" condition="reset">RESET QUERY
+ CACHE</literal>, and so forth.
+ </para>
+ </listitem>
+
</itemizedlist>
</section>
Modified: trunk/refman-5.6/optimization.xml
===================================================================
--- trunk/refman-5.6/optimization.xml 2010-11-16 01:13:29 UTC (rev 23761)
+++ trunk/refman-5.6/optimization.xml 2010-11-16 02:42:39 UTC (rev 23762)
Changed blocks: 1, Lines Added: 28, Lines Deleted: 0; 1396 bytes
@@ -18032,6 +18032,34 @@
</para>
</listitem>
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>Waiting for query cache lock</primary>
+ <secondary>thread state</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>thread state</primary>
+ <secondary>Waiting for query cache lock</secondary>
+ </indexterm>
+
+ <literal>Waiting for query cache lock</literal>
+ </para>
+
+ <para>
+ This state occurs while a session is waiting to take the
+ query cache lock. This can happen for any statement that
+ needs to perform some query cache operation, such as an
+ <literal role="stmt">INSERT</literal> or
+ <literal role="stmt">DELETE</literal> that invalidates the
+ query cache, a <literal role="stmt">SELECT</literal> that
+ looks for a cached entry,
+ <literal role="stmt" condition="reset">RESET QUERY
+ CACHE</literal>, and so forth.
+ </para>
+ </listitem>
+
</itemizedlist>
</section>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r23762 - in trunk: . dynamic-docs/changelog refman-5.5 refman-5.6 | paul.dubois | 16 Nov |
