[development] MySQL tools

[Khalid B]

If a site is slow, and you suspect the database, then mtop will
show you the queries that are running.

The mysqlreport has some examples on their site where locks are an
issue http://hackmysql.com/examples/bad_table_locks_waited.txt

This can happen with Drupal on a busy site.

On 7/9/06, Kieran Lal <kieran at civicspacelabs.org> wrote:
>
> On Jul 8, 2006, at 8:00 PM, Khalid B wrote:
>
> > These two MySQL tools may prove useful for troubleshooting,
> > benchmarking
> > and optimization ...
> >
> > http://hackmysql.com/mysqlreport
> >
> > http://mtop.sourceforge.net
>
> Both are good, but it's what we use them to do that's interesting.
>
> Anything in particular you'd like to see measured?
>
> Kieran
>
> >
>
>