At the moment one needs to set slow query logging in my.cnf, but if this module could analyze a Drupal site for a few days without having to touch my.cnf for slow query logging would be great.

I guess this is possible since php can measure query time etc. and collect these in a separate report :)

Comments

giorgio79’s picture

giorgio79 commented

Additional feature would be to be able to set slow query threshold :P

dalin’s picture

dalin
he/him
Primary language English
Location 🇨🇦, 🇲🇽, 🌍
commented

Devel module already has the ability to log queries. But the problem is that the overhead of logging the queries with PHP+MySQL is far too high to be useful on a performance site. The MySQL slow query log is a far more efficient way to do this. There's also really great tools to analyze the MySQL slow log like Maatkit.

mikeytown2’s picture

mikeytown2 commented
Status: Active » Closed (won't fix)

going to won't fix this.

+1 for using tools to analyze the MySQL slow query log; like this #799236: Run explain on every query in the slow query log