[development] Database queries on drupal.org

[Dries Buytaert]

On 26 Jul 2006, at 18:10, Kieran Lal wrote:
> Great!  If I can get a copy of the Drupal.org schema then I'll  
> write the EXPLAINs for both these queries and the Slow queries from  
> the Drupal.org databases.  We just need a PHP Snippet that puts an  
> EXPLAIN in front of these queries and converts INSERTS, UPDATES,  
> and DELETES to SELECTS to use EXPLAINs.
>
> I'll then ask for the snippet to be run on Drupal.org by a  
> maintainer with PHP Input format privileges so I can review the  
> EXPLAINS.  It's also worth noting that Peter Zaitsev, the MySQL  
> performance lead, has been explaining how MySQL EXPLAIN can be  
> wrong here: http://www.mysqlperformanceblog.com/2006/07/24/mysql- 
> explain-limits-and-errors/

Isn't our time better spend building that functionality into the  
devel.module (along with a permission)?  It would be convenient if  
there was an 'explain' link on the query overview page.

--
Dries Buytaert  ::  http://www.buytaert.net/