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
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.
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.