which sql going in database

Karan Johar

Greenhorn

Posts: 25

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

author

Posts: 5856

I like...

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

JBoss In Action

Karan Johar

Greenhorn

Posts: 25

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

it is mysql

ujjwal soni

Ranch Hand

Posts: 405

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi There,

Check out below link.

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

Cheers!!!
Ujjwal B Soni <baroda, gujarat, india> <+918866008962>
"Helping hands are better than praying lips......"

Peter Johnson

author

Posts: 5856

I like...

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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.

JBoss In Action

There's a city wid manhunt for this tiny ad:

Thread Boost feature

https://coderanch.com/t/674455/Thread-Boost-feature