MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:mcbrown Date:August 14 2007 2:03pm
Subject:svn commit - mysqldoc@docsrva: r7451 - in trunk: refman-5.0 refman-5.1 refman-5.2
View as plain text  
Author: mcbrown
Date: 2007-08-14 16:03:03 +0200 (Tue, 14 Aug 2007)
New Revision: 7451

Log:
Clarification on memory reclaimation when rows are deleted (thanks max, Leith)



Modified:
   trunk/refman-5.0/se-memory.xml
   trunk/refman-5.1/se-memory.xml
   trunk/refman-5.2/se-memory.xml


Modified: trunk/refman-5.0/se-memory.xml
===================================================================
--- trunk/refman-5.0/se-memory.xml	2007-08-14 09:04:12 UTC (rev 7450)
+++ trunk/refman-5.0/se-memory.xml	2007-08-14 14:03:03 UTC (rev 7451)
Changed blocks: 1, Lines Added: 13, Lines Deleted: 2; 1252 bytes

@@ -247,8 +247,19 @@
 
     <listitem>
       <para>
-        To free memory used by a <literal>MEMORY</literal> table when
-        you no longer require its contents, you should execute
+        Memory used by a <literal>MEMORY</literal> table is not
+        reclaimed if you delete individual rows from the table. Memory
+        is only reclaimed when the entire table is deleted. Memory that
+        was previously used for rows that have been deleted will be
+        re-used for new rows only within the same table. To free up the
+        memory used by rows that have been deleted you should use
+        <literal>ALTER TABLE ENGINE=MEMORY</literal> to force a table
+        rebuild.
+      </para>
+
+      <para>
+        To free all the memory used by a <literal>MEMORY</literal> table
+        when you no longer require its contents, you should execute
         <literal>DELETE</literal> or <literal>TRUNCATE TABLE</literal>,
         or remove the table altogether using <literal>DROP
         TABLE</literal>.


Modified: trunk/refman-5.1/se-memory.xml
===================================================================
--- trunk/refman-5.1/se-memory.xml	2007-08-14 09:04:12 UTC (rev 7450)
+++ trunk/refman-5.1/se-memory.xml	2007-08-14 14:03:03 UTC (rev 7451)
Changed blocks: 1, Lines Added: 13, Lines Deleted: 2; 1252 bytes

@@ -240,8 +240,19 @@
 
     <listitem>
       <para>
-        To free memory used by a <literal>MEMORY</literal> table when
-        you no longer require its contents, you should execute
+        Memory used by a <literal>MEMORY</literal> table is not
+        reclaimed if you delete individual rows from the table. Memory
+        is only reclaimed when the entire table is deleted. Memory that
+        was previously used for rows that have been deleted will be
+        re-used for new rows only within the same table. To free up the
+        memory used by rows that have been deleted you should use
+        <literal>ALTER TABLE ENGINE=MEMORY</literal> to force a table
+        rebuild.
+      </para>
+
+      <para>
+        To free all the memory used by a <literal>MEMORY</literal> table
+        when you no longer require its contents, you should execute
         <literal>DELETE</literal> or <literal>TRUNCATE TABLE</literal>,
         or remove the table altogether using <literal>DROP
         TABLE</literal>.


Modified: trunk/refman-5.2/se-memory.xml
===================================================================
--- trunk/refman-5.2/se-memory.xml	2007-08-14 09:04:12 UTC (rev 7450)
+++ trunk/refman-5.2/se-memory.xml	2007-08-14 14:03:03 UTC (rev 7451)
Changed blocks: 1, Lines Added: 13, Lines Deleted: 2; 1252 bytes

@@ -240,8 +240,19 @@
 
     <listitem>
       <para>
-        To free memory used by a <literal>MEMORY</literal> table when
-        you no longer require its contents, you should execute
+        Memory used by a <literal>MEMORY</literal> table is not
+        reclaimed if you delete individual rows from the table. Memory
+        is only reclaimed when the entire table is deleted. Memory that
+        was previously used for rows that have been deleted will be
+        re-used for new rows only within the same table. To free up the
+        memory used by rows that have been deleted you should use
+        <literal>ALTER TABLE ENGINE=MEMORY</literal> to force a table
+        rebuild.
+      </para>
+
+      <para>
+        To free all the memory used by a <literal>MEMORY</literal> table
+        when you no longer require its contents, you should execute
         <literal>DELETE</literal> or <literal>TRUNCATE TABLE</literal>,
         or remove the table altogether using <literal>DROP
         TABLE</literal>.


Thread
svn commit - mysqldoc@docsrva: r7451 - in trunk: refman-5.0 refman-5.1 refman-5.2mcbrown14 Aug