List Info

Thread: Re: drupal.org downtime tomorrow
Re: drupal.org downtime tomorrow
country flaguser name
United States		 2007-05-23 11:15:46 

  


  

    Doug - great point on the time it takes for COUNT(*).  These an article over at 2bits.com [1] that points out the same problem.




Since the search tables are mostly read from wouldn't it be better for overall performance, as Doug said, to leave them as MyISAM?



 - Matt



[1] http://2bits.com/articles/mysql-innodb-performance-gains-as-well-as-some-pitfalls.html



On Wed May 23 10:59 , 'Doug Green' douggreenconsulting.com> sent:




douggreenconsulting.com>
Has someone run performance tests on converting the search_index tables to


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


the performance tests and report the results.  While developing new search



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



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



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


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


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





Doug Green


904-583-3342


www.douggreenconsulting.com


 


Bringing Ideas to Life with Software Artistry and Invention...


Providing open source software political solutions


-----Original Message-----


From: drupal.org','','','')">development-bouncesdrupal.org [drupal.org="" ,="" )="">development-bouncesdrupal.org','','','')">drupal.org','','','')">development-bouncesdrupal.org]


On Behalf Of Gerhard Killesreiter


Sent: Tuesday, May 22, 2007 2:49 PM


To: Drupal Development; Board of Directors of the Drupal Association


Subject: [development] drupal.org downtime tomorrow






-----BEGIN PGP SIGNED MESSAGE-----


Hash: SHA1





see http://drupal.org/node/145947


-----BEGIN PGP SIGNATURE-----


Version: GnuPG v1.4.6 (GNU/Linux)





iD8DBQFGUzsQfg6TFvELooQRAg77AKCrKdoiVqkRphbsvspgbs0stcA6HACgsWUe



vdoGZXmbjNuCbpAlN6uzXcM=


=tfXZ


-----END PGP SIGNATURE-----










  

  
  
   
     
    

  

    Re:  drupal.org downtime tomorrow
  


  

     user name

     2007-05-23 13:27:39
  


  

    
On 5/23/07, Matt Farina <mattmattfarina.com> wrote:
> Doug - great point on the time it takes for COUNT(*). 
These an article over
> at 2bits.com [1] that points out the same problem.
>
>  Since the search tables are mostly read from wouldn't
it be better for
> overall performance, as Doug said, to leave them as
MyISAM?

This has been discussed quite a bit on the infrastructure
list.  If
you want to be involved in the infrastructure discussions,
that is the
place.  There's work underway (coordinated on
infrastructure) to get
good benchmarks of different tweaks to the Drupal.org setup.
 Jonathan
Lambert is graciously undertaking that work.  I don't think
he's
looking for help now, but when he releases his results I
imagine that
it will be useful to get diverse opinions on them.

Regards,
Greg



  


  

    
  

  
  
   
     
    






 [1-2]











   
 





about | contact  Other archives ( Real Estate discussion Medical topics )