List:Commits« Previous MessageNext Message »
From:john.russell Date:April 6 2011 10:22pm
Subject:svn commit - mysqldoc@oter02: r25773 - trunk/dynamic-docs/changelog
View as plain text  
Author: jdrussel
Date: 2011-04-07 00:22:10 +0200 (Thu, 07 Apr 2011)
New Revision: 25773

Log:
Added entries for several InnoDB-related WLs.
Used the 'custom' style for those that seemed important enough to deserve a real title,
reusing the outline from some of the replication items.
(Have to check the HTML to see if the result flows well or has some weird order or divisions.)
Fixed a few stray items that were causing validation errors.
Different validation errors when validating mysqld-2.xml versus building
dynxml-local-news-5.6 targets.


Modified:
   trunk/dynamic-docs/changelog/mysqld-2.xml


Modified: trunk/dynamic-docs/changelog/mysqld-2.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-2.xml	2011-04-06 19:45:30 UTC (rev 25772)
+++ trunk/dynamic-docs/changelog/mysqld-2.xml	2011-04-06 22:22:10 UTC (rev 25773)
Changed blocks: 3, Lines Added: 264, Lines Deleted: 3; 7035 bytes

@@ -6,6 +6,267 @@
 ]>
 <changelog>
 
+  <logentry entrytype="custom" customname="cl-innodb-persistent-stats" customtitle="Persistent InnoDB Optimizer Statistics">
+
+    <tags>
+      <highlight type="innodb"/>
+    </tags>
+
+    <bugs>
+      <fixes wlid="5520"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.6.2"/>
+    </versions>
+
+    <message>
+
+      <para>
+        The optimizer statistics for <literal>InnoDB</literal> tables
+        can now persist across server restarts, producing more stable
+        query performance. You can also control the amount of sampling
+        done to estimate cardinality for each index, resulting in more
+        accurate optimizer statistics.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="custom" customname="cl-innodb-is-system-tables" customtitle="INFORMATION_SCHEMA System Tables for InnoDB">
+
+    <tags>
+      <highlight type="innodb"/>
+      <manual type="information_schema"/>
+    </tags>
+
+    <bugs>
+      <fixes wlid="5373"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.6.2"/>
+    </versions>
+
+    <message>
+
+      <para>
+        The <literal>InnoDB</literal> data dictionary, containing
+        metadata about <literal>InnoDB</literal> tables, columns,
+        indexes, and foreign keys, is available for SQL queries through
+        a set of <literal>INFORMATION_SCHEMA</literal> tables.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="custom" customname="cl-innodb-is-buffer-pool" customtitle="INFORMATION_SCHEMA Tables for InnoDB Buffer Pool Information">
+
+    <tags>
+      <highlight type="innodb"/>
+      <manual type="information_schema"/>
+    </tags>
+
+    <bugs>
+      <fixes wlid="5614"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.6.2"/>
+    </versions>
+
+    <message>
+
+      <para>
+        The new <literal>INFORMATION_SCHEMA</literal> tables
+        <literal role="is">INNODB_BUFFER_PAGE</literal>,
+        <literal>INNODB_BUFFER_PAGE_LRU</literal>, and
+        <literal role="is">INNODB_BUFFER_POOL_STATS</literal> display
+        <literal>InnoDB</literal>
+        <link linkend="glos_buffer_pool">buffer pool</link> information
+        for tuning on large-memory or highly loaded systems.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="custom" customname="cl-innodb-table-cache" customtitle="InnoDB Limit for Data Dictionary Cache Size">
+
+    <tags>
+      <highlight type="innodb"/>
+    </tags>
+
+    <bugs>
+      <fixes wlid="5457"/>
+      <fixes bugid="20877"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.6.2"/>
+    </versions>
+
+    <message>
+
+      <para>
+        <literal>InnoDB</literal> now uses the
+        <literal>table_cache</literal> option value as a guide to remove
+        table metadata from memory when many different
+        <literal>InnoDB</literal> tables are accessed.
+        <literal>InnoDB</literal> table metadata is removed using a
+        variation of the LRU algorithm. (Parent and child tables in
+        foreign key relationships are exempted from removal.)
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="custom" customname="cl-innodb-is-metrics" customtitle="InnoDB INFORMATION_SCHEMA Metrics Table">
+
+    <tags>
+      <highlight type="innodb"/>
+    </tags>
+
+    <bugs>
+      <fixes wlid="5316"/>
+      <fixes wlid="5776"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.6.2"/>
+    </versions>
+
+    <message>
+
+      <para>
+        A new <literal>INFORMATION_SCHEMA</literal> table,
+        <literal role="is">INNODB_METRICS</literal>, lets you query
+        low-level <literal>InnoDB</literal> performance information,
+        getting cumulative counts, averages, and min/max values for
+        internal aspects of the storage engine operation. You can start,
+        stop, and reset the metrics counters using the configuration
+        variables
+        <literal role="sysvar">innodb_monitor_enable</literal>,
+        <literal role="sysvar">innodb_monitor_disable</literal>,
+        <literal role="sysvar">innodb_monitor_reset</literal>, and
+        <literal role="sysvar">innodb_monitor_reset_all</literal>.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="feature">
+
+    <tags>
+      <highlight type="innodb"/>
+    </tags>
+
+    <bugs>
+      <fixes wlid="5458"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.6.2"/>
+    </versions>
+
+    <message>
+
+      <para>
+        The <literal>InnoDB</literal> kernel mutex has been split into
+        several <link linkend="glos_mutex">mutexes</link> and
+        <link linkend="glos_rw_lock">rw-locks</link>, for improved
+        concurrency.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="feature">
+
+    <tags>
+      <highlight type="innodb"/>
+    </tags>
+
+    <bugs>
+      <fixes wlid="5459"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.6.2"/>
+    </versions>
+
+    <message>
+
+      <para>
+        The configuration option
+        <literal role="sysvar">innodb_purge_threads</literal> can now be
+        set to a value higher than 1.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="feature">
+
+    <tags>
+      <highlight type="innodb"/>
+    </tags>
+
+    <bugs>
+      <fixes wlid="5579"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.6.2"/>
+    </versions>
+
+    <message>
+
+      <para>
+        A separate <literal>InnoDB</literal> thread
+        (<literal>page_cleaner</literal>) now handles the flushing of
+        dirty pages that was formerly done by the
+        <literal>InnoDB</literal> master thread.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="feature">
+
+    <tags>
+      <highlight type="innodb"/>
+    </tags>
+
+    <bugs>
+      <fixes wlid="5674"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.6.2"/>
+    </versions>
+
+    <message>
+
+      <para>
+        <literal>InnoDB</literal> can optionally log details about all
+        deadlocks that occur, to assist with troubleshooting and
+        diagnosis. This feature is controlled by the
+        <literal role="sysvar">innodb_print_all_deadlocks</literal>
+        configuration option.
+      </para>
+
+    </message>
+
+  </logentry>
+
   <logentry entrytype="custom" customname="replication-uuid" customtitle="Globally Unique Server IDs">
 
     <tags>

@@ -9135,7 +9396,7 @@
 
       <para>
         <literal role="stmt">UPDATE</literal> and
-        <literal role="">INSERT</literal> statements affecting
+        <literal role="stmt">INSERT</literal> statements affecting
         partitioned tables performed poorly when using row-based
         replication.
       </para>

@@ -42675,8 +42936,8 @@
     </tags>
 
     <bugs>
-      <fixes bug="60061"/>
-      <fixes bug="11827366"/>
+      <fixes bugid="60061"/>
+      <fixes bugid="11827366"/>
     </bugs>
 
     <versions>


Thread
svn commit - mysqldoc@oter02: r25773 - trunk/dynamic-docs/changelogjohn.russell7 Apr