Author: pd221994
Date: 2011-02-27 04:21:59 +0100 (Sun, 27 Feb 2011)
New Revision: 25160
Log:
r45332@dhcp-adc-twvpn-1-vpnpool-10-154-17-185: paul | 2011-02-26 21:21:44 -0500
Document bug fix:
Bug 11752585 - 43818: LOJ ON I_S TOO SLOW
Modified:
svk:merge
trunk/dynamic-docs/changelog/mysqld-2.xml
Property changes on: trunk
___________________________________________________________________
Modified: svk:merge
===================================================================
Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 1277 bytes
Modified: trunk/dynamic-docs/changelog/mysqld-2.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-2.xml 2011-02-27 02:43:09 UTC (rev 25159)
+++ trunk/dynamic-docs/changelog/mysqld-2.xml 2011-02-27 03:21:59 UTC (rev 25160)
Changed blocks: 1, Lines Added: 36, Lines Deleted: 0; 1346 bytes
@@ -40385,4 +40385,40 @@
</logentry>
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="INFORMATION_SCHEMA"/>
+ <highlight type="performance"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="43818"/>
+ <fixes bugid="11752585"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.1.55"/>
+ <version ver="5.5.9"/>
+ </versions>
+
+ <message>
+
+ <para>
+ Queries involving <literal role="se">InnoDB</literal> tables in
+ the <literal>INFORMATON_SCHEMA</literal> tables
+ <literal role="is">TABLE_CONSTRANTS</literal>,
+ <literal role="is">KEY_COLUMN_USAGE</literal>, or
+ <literal role="is">REFERENTIAL_CONSTRAINTS</literal> were slower
+ than necessary because statistics were rechecked more often than
+ required, even more so when many foreign keys were present. The
+ improvement to this may be of particular benefit to users of
+ MySQL Enterprise Monitor with many monitored servers or tens of
+ thousands of tables.
+ </para>
+
+ </message>
+
+ </logentry>
+
</changelog>
| Thread |
|---|
| • svn commit - mysqldoc@oter02: r25160 - in trunk: . dynamic-docs/changelog | paul.dubois | 27 Feb |
