which sql going in database

[Karan Johar]

how to know which sql is going to database and how many time it going.
any tool can tell me how to see.

[Peter Johnson]

What database are you using? The ones I know of provide means to log all SQL statements.

[Karan Johar]

it is mysql

[ujjwal soni]

Hi There,

Check out below link.

http://www.mysql.com/why-mysql/white-papers/mysql_wp_queryanalyzer.php

[Peter Johnson]

For MySQL you can set the "log" and "log-update" entries in the config file (see the docs for details). Or you can use the Admin GUI to turn the logs on.