Doug - great point on the time it takes for COUNT(*).&nbsp; These an article over at 2bits.com [1] that points out the same problem.<BR>
<BR>
Since the search tables are mostly read from wouldn't it be better for overall performance, as Doug said, to leave them as MyISAM?<BR>
<BR>
 - Matt<BR>
<BR>
[1] http://2bits.com/articles/mysql-innodb-performance-gains-as-well-as-some-pitfalls.html<BR>
<BR>
<span style="font-weight: bold;">On Wed May 23 10:59 , 'Doug Green' <douggreen@douggreenconsulting.com> sent:<BR>
<BR>
</douggreen@douggreenconsulting.com></span><blockquote style="border-left: 2px solid rgb(245, 245, 245); margin-left: 5px; margin-right: 0px; padding-left: 5px; padding-right: 0px;">Has someone run performance tests on converting the search_index tables to<BR>

innodb?  If someone wants to help me get a half dozen d.o tables, I'll run<BR>

the performance tests and report the results.  While developing new search<BR>

queries, I've found the difference on some search_index GROUP BY HAVING<BR>

COUNT(*) clauses to be 30 seconds verses half a second.  We really should<BR>

benchmark this on the 5.x search.module code before converting... in my<BR>

opinion from myisam to innodb.  It should be noted that you can leave some<BR>

tables (one table) as myisam and everything else as innodb.<BR>

<BR>

Doug Green<BR>

904-583-3342<BR>

www.douggreenconsulting.com<BR>

 <BR>

Bringing Ideas to Life with Software Artistry and Invention...<BR>

Providing open source software political solutions<BR>

-----Original Message-----<BR>

From: <a href="javascript:top.opencompose('development-bounces@drupal.org','','','')">development-bounces@drupal.org</a> [<a href="javascript:top.opencompose('<a href=" javascript:top.opencompose(="" development-bounces@drupal.org="" ,="" )="">development-bounces@drupal.org</a>','','','')"&gt;<a href="javascript:top.opencompose('development-bounces@drupal.org','','','')">development-bounces@drupal.org</a>]<BR>

On Behalf Of Gerhard Killesreiter<BR>

Sent: Tuesday, May 22, 2007 2:49 PM<BR>

To: Drupal Development; Board of Directors of the Drupal Association<BR>

Subject: [development] drupal.org downtime tomorrow<BR>

<BR>

-----BEGIN PGP SIGNED MESSAGE-----<BR>

Hash: SHA1<BR>

<BR>

see <a href="parse.pl?redirect=http%3A%2F%2Fdrupal.org%2Fnode%2F145947" target="_blank"><span style="color: red;">http://drupal.org/node/145947</span></a><BR>

-----BEGIN PGP SIGNATURE-----<BR>

Version: GnuPG v1.4.6 (GNU/Linux)<BR>

<BR>

iD8DBQFGUzsQfg6TFvELooQRAg77AKCrKdoiVqkRphbsvspgbs0stcA6HACgsWUe<BR>

vdoGZXmbjNuCbpAlN6uzXcM=<BR>

=tfXZ<BR>

-----END PGP SIGNATURE-----<BR>

<BR>

</blockquote><BR>