These two MySQL tools may prove useful for troubleshooting, benchmarking and optimization ... http://hackmysql.com/mysqlreport http://mtop.sourceforge.net
On Jul 8, 2006, at 8:00 PM, Khalid B wrote:
These two MySQL tools may prove useful for troubleshooting, benchmarking and optimization ...
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
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@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 ...
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
On 09 Jul 2006, at 05:00, Khalid B wrote:
These two MySQL tools may prove useful for troubleshooting, benchmarking and optimization ...
Thanks for the pointers. Profiling is easy and most of us are familiar with these tools (I use mtop a lot). Optimizing is what we need most help with. -- Dries Buytaert :: http://www.buytaert.net/
participants (3)
-
Dries Buytaert -
Khalid B -
Kieran Lal