<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script type="text/javascript">window["_gaUserPrefs"] = { ioo : function() { return true; } }</script><script type="text/javascript">window["_gaUserPrefs"] = { ioo : function() { return true; } }</script><style type="text/css" id="owaParaStyle"></style>
</head>
<body fpstyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;"><font face="Courier New">Hi,</font>
<div><font face="Courier New"><br>
</font></div>
<div><font face="Courier New">When I ran Plone buildout to initialize a blank MySQL database through RelStorage, I noticed that the tables in that database use different engines:</font></div>
<div><font face="Courier New"><br>
</font></div>
<blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">
<div>
<div><font face="Courier New">mysql> SELECT table_name, engine FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = 'mi_ucpd';</font></div>
</div>
<div>
<div><font face="Courier New">+-------------------+--------+</font></div>
</div>
<div>
<div><font face="Courier New">| table_name | engine |</font></div>
</div>
<div>
<div><font face="Courier New">+-------------------+--------+</font></div>
</div>
<div>
<div><font face="Courier New">| blob_chunk | InnoDB |</font></div>
</div>
<div>
<div><font face="Courier New">| current_object | InnoDB |</font></div>
</div>
<div>
<div><font face="Courier New">| new_oid | MyISAM |</font></div>
</div>
<div>
<div><font face="Courier New">| object_ref | MyISAM |</font></div>
</div>
<div>
<div><font face="Courier New">| object_refs_added | MyISAM |</font></div>
</div>
<div>
<div><font face="Courier New">| object_state | InnoDB |</font></div>
</div>
<div>
<div><font face="Courier New">| pack_object | MyISAM |</font></div>
</div>
<div>
<div><font face="Courier New">| pack_state | MyISAM |</font></div>
</div>
<div>
<div><font face="Courier New">| pack_state_tid | MyISAM |</font></div>
</div>
<div>
<div><font face="Courier New">| transaction | InnoDB |</font></div>
</div>
<div>
<div><font face="Courier New">+-------------------+--------+</font></div>
</div>
<div>
<div><font face="Courier New">10 rows in set (0.00 sec)</font></div>
</div>
</blockquote>
<div><font face="Courier New"><br>
</font></div>
<div><font face="Courier New">I thought RelStorage requires InnoDB. So I wonder whether I did something wrong? If not, can I change the engine of those tables using MyISAM to InnoDB?</font></div>
<div><font face="Courier New"><br>
</font></div>
<div><font face="Courier New">Thanks.</font></div>
<div class="vimiumReset vimiumHUD" style="right: 150px; opacity: 0; display: none;">
</div>
<div class="vimiumReset vimiumHUD" style="right: 150px; opacity: 0; display: none;">
</div>
</div>
</body>
</html>