7

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?

closed as off-topic by Pierre.Vriens, DRUPWAY, No Sssweat, Adrian Cid Almaguer, mradcliffe Jan 23 '17 at 18:27

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions asking to recommend or find a book, tool, module, theme, distribution, tutorial, or other off-site resource are off-topic for Drupal Answers as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it." – Pierre.Vriens, DRUPWAY, No Sssweat, Adrian Cid Almaguer, mradcliffe
If this question can be reworded to fit the rules in the help center, please edit the question.

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.

  • Seems this is no longer available in D8. – Randell Jul 31 at 5:46

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