Doug - great point on the time it takes for COUNT(*). 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>','','','')"><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>