CODEWITHSUNDEEP
mysqlopencart
Suthan Bala
Suthan Bala

Reputation: 3299

Is it possible to get all the mysql queries called on the page?

I am using Open Cart, and it is extremely slow as I have about 3000 products. The category listing page is extremely slow, it doesn't seem like an issue with the server, I checked with various servers. I doubt that there are lots of MYSQL queries are running unnecessarily. Is there any way to get a list of all the query strings called on that page using some kind of PHP function? Or perhaps an Open Cart function?

Upvotes: 1

Views: 2794

Answers (2)

B-and-P
B-and-P

Reputation: 1713

You can also set general_log variable in mysql to ON. This will log all queries to mysql server into a file. Can be useful for debugging.

Upvotes: 1

Jay Gilford
Jay Gilford

Reputation: 15151

There's actually a vQmod file you can install that will create a log file for you with all of the database queries and their time taken to execute. You can find the thread and XML file here

Upvotes: 3

Related Questions