CODEWITHSUNDEEP
phpdebugging
Rakamazirem
Rakamazirem

Reputation: 179

Log all mysql queries without tampering code

Is there a way, to log all the mysql queries, like xhprof does with function calls - without tampering with the code? Are there any PHP extensions for this job?

I want a page execution based log of queries, not MySQL's logging facility.

Upvotes: 0

Views: 314

Answers (1)

symcbean
symcbean

Reputation: 48357

You seem to be a bit confused as to what you are trying to achieve here - or not explaining it well.

What have you tried?

What do intend to do with the information?

What does I want a page execution based log of queries, not MySQL's logging facility mean?

There's at least 3 way's I can think of acheiving it.

  • Use the runkit to wrap the relevant functions / methods with a logging layer

  • use mysql logging (slow query / general / replication)

  • route the conections via mysqlproxy and log the requests there.

Upvotes: 1

Related Questions