8

My site is running slow and I suspect its a module, but not sure which one. Is there a module that can display all the sql queries being run on a loaded page? If there isn't maybe there is a command line tool that others use to monitor this data?

5

There is better query log we can get from mysql log( more here: https://stackoverflow.com/questions/6479107/how-to-enable-mysql-query-log )

It shows real mysql queries with real values while the Devel's log shows placeholders.

So to get log of a page shutdown Mysql server, add the "log=" line in my.ini and restart the server then do the page load and then again stop the server and comment the log command.

14

The Devel module has a query log option, which when enabled will show every query that's been run for a request at the footer of the page.

You can enable it at admin/config/development/devel once the module's installed.

3
  • 2
    Seems this is no longer available in D8.
    – Randell
    Jul 31 '19 at 5:46
  • 1
    @Randell Now it's a sub-module called Web Profiler
    – Dalin
    May 7 '20 at 3:57
  • The Web Profiler project page says the module has been merged with the Devel module since November 9, 2015.
    – apaderno
    Aug 23 at 14:11

Not the answer you're looking for? Browse other questions tagged or ask your own question.