Author: shinz
Date: 2006-01-13 19:16:19 +0100 (Fri, 13 Jan 2006)
New Revision: 804
Log:
Turn figure into table, remove false claims (closing bug #16463)
Modified:
trunk/refman-5.1/pluggable-storage.xml
Modified: trunk/refman-5.1/pluggable-storage.xml
===================================================================
--- trunk/refman-5.1/pluggable-storage.xml 2006-01-13 17:02:10 UTC (rev 803)
+++ trunk/refman-5.1/pluggable-storage.xml 2006-01-13 18:16:19 UTC (rev 804)
@@ -228,18 +228,200 @@
provided with MySQL:
</para>
- <figure>
- <title>Storage engine comparison</title>
- <mediaobject>
- <imageobject>
- <imagedata fileref="images/pluggable-storage-choosing.png" format="PNG" lang="en"/>
- </imageobject>
- <textobject>
- <phrase lang="en">Storage engine comparison</phrase>
- </textobject>
- </mediaobject>
- </figure>
-
+ <informaltable>
+ <tgroup cols="7">
+ <colspec colwidth="18*"/>
+ <colspec colwidth="12*"/>
+ <colspec colwidth="12*"/>
+ <colspec colwidth="12*"/>
+ <colspec colwidth="12*"/>
+ <colspec colwidth="12*"/>
+ <colspec colwidth="12*"/>
+ <tbody>
+ <row>
+ <entry><emphasis role="bold">Feature</emphasis></entry>
+ <entry><emphasis role="bold">MyISAM</emphasis></entry>
+ <entry><emphasis role="bold">BDB</emphasis></entry>
+ <entry><emphasis role="bold">Memory</emphasis></entry>
+ <entry><emphasis role="bold">InnoDB</emphasis></entry>
+ <entry><emphasis role="bold">Archive</emphasis></entry>
+ <entry><emphasis role="bold">NDB</emphasis></entry>
+ </row>
+ <row>
+ <entry>Storage limits</entry>
+ <entry>256TB</entry>
+ <entry>No</entry>
+ <entry>Yes</entry>
+ <entry>64TB</entry>
+ <entry>No</entry>
+ <entry>Yes</entry>
+ </row>
+ <row>
+ <entry>Transactions</entry>
+ <entry>No</entry>
+ <entry>Yes</entry>
+ <entry>No</entry>
+ <entry>Yes</entry>
+ <entry>No</entry>
+ <entry>No</entry>
+ </row>
+ <row>
+ <entry>Locking granularity</entry>
+ <entry>Table</entry>
+ <entry>Page</entry>
+ <entry>Table</entry>
+ <entry>Row</entry>
+ <entry>Row</entry>
+ <entry>Row</entry>
+ </row>
+ <row>
+ <entry>MVCC (snapshot read)</entry>
+ <entry>No</entry>
+ <entry>No</entry>
+ <entry>No</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ </row>
+ <row>
+ <entry>Geospatial support</entry>
+ <entry>Yes</entry>
+ <entry>No</entry>
+ <entry>No</entry>
+ <entry>No</entry>
+ <entry>No</entry>
+ <entry>No</entry>
+ </row>
+ <row>
+ <entry>B-tree indexes</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ <entry>No</entry>
+ <entry>Yes</entry>
+ </row>
+ <row>
+ <entry>Hash indexes</entry>
+ <entry>No</entry>
+ <entry>No</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ <entry>No</entry>
+ <entry>Yes</entry>
+ </row>
+ <row>
+ <entry>Full-text search indexes</entry>
+ <entry>Yes</entry>
+ <entry>No</entry>
+ <entry>No</entry>
+ <entry>No</entry>
+ <entry>No</entry>
+ <entry>No</entry>
+ </row>
+ <row>
+ <entry>Clustered indexes</entry>
+ <entry>No</entry>
+ <entry>No</entry>
+ <entry>No</entry>
+ <entry>Yes</entry>
+ <entry>No</entry>
+ <entry>No</entry>
+ </row>
+ <row>
+ <entry>Data caches</entry>
+ <entry>No</entry>
+ <entry>No</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ <entry>No</entry>
+ <entry>Yes</entry>
+ </row>
+ <row>
+ <entry>Index caches</entry>
+ <entry>Yes</entry>
+ <entry>No</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ <entry>No</entry>
+ <entry>Yes</entry>
+ </row>
+ <row>
+ <entry>Compressed data</entry>
+ <entry>Yes</entry>
+ <entry>No</entry>
+ <entry>No</entry>
+ <entry>No</entry>
+ <entry>Yes</entry>
+ <entry>No</entry>
+ </row>
+ <row>
+ <entry>Encrypted data (via function)</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ </row>
+ <row>
+ <entry>Cluster database support</entry>
+ <entry>No</entry>
+ <entry>No</entry>
+ <entry>No</entry>
+ <entry>No</entry>
+ <entry>No</entry>
+ <entry>Yes</entry>
+ </row>
+ <row>
+ <entry>Replication support</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ </row>
+ <row>
+ <entry>Foreign key support</entry>
+ <entry>No</entry>
+ <entry>No</entry>
+ <entry>No</entry>
+ <entry>Yes</entry>
+ <entry>No</entry>
+ <entry>No</entry>
+ </row>
+ <row>
+ <entry>Backup / point-in-time recovery</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ </row>
+ <row>
+ <entry>Query cache support</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ </row>
+ <row>
+ <entry>Update statistics for data dictionary</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ <entry>Yes</entry>
+ </row>
+ </tbody>
+ </tgroup>
+ </informaltable>
+
<para>
The following storage engines are the most commonly used:
</para>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r804 - trunk/refman-5.1 | stefan | 13 Jan |
