Author: jdrussel
Date: 2011-04-08 21:37:09 +0200 (Fri, 08 Apr 2011)
New Revision: 25814
Log:
Fill in some details for the InnoDB table cache enhancement.
Modified:
trunk/refman-5.6/innodb-performance.xml
Modified: trunk/refman-5.6/innodb-performance.xml
===================================================================
--- trunk/refman-5.6/innodb-performance.xml 2011-04-08 19:30:49 UTC (rev 25813)
+++ trunk/refman-5.6/innodb-performance.xml 2011-04-08 19:37:09 UTC (rev 25814)
Changed blocks: 1, Lines Added: 13, Lines Deleted: 2; 1215 bytes
@@ -1963,9 +1963,20 @@
<section id="innodb-performance-table-cache">
- <title>InnoDB Configurable Data Dictionary cache</title>
+ <title>InnoDB Configurable Data Dictionary Cache</title>
- <para></para>
+ <para>
+ To ease the memory load on systems with huge numbers of tables,
+ InnoDB now frees up the memory associated with an opened table,
+ using an LRU algorithm to select tables that have gone the longest
+ without being accessed. To reserve more memory to hold metadata
+ for open InnoDB tables, increase the value of the
+ <literal role="sysvar">table_cache</literal> configuration option.
+ InnoDB treats this value as a <quote>soft limit</quote>. The
+ actual number of tables with cached metadata could be higher,
+ because metadata for InnoDB system tables, and parent and child
+ tables in foreign key relationships, is never evicted from memory.
+ </para>
</section>
| Thread |
|---|
| • svn commit - mysqldoc@oter02: r25814 - trunk/refman-5.6 | john.russell | 8 Apr |
