Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

which sql going in database

 
Karan Johar
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Bartender
Posts: 5852
7
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What database are you using? The ones I know of provide means to log all SQL statements.
 
Karan Johar
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
it is mysql
 
ujjwal soni
Ranch Hand
Posts: 403
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi There,

Check out below link.

http://www.mysql.com/why-mysql/white-papers/mysql_wp_queryanalyzer.php
 
Peter Johnson
author
Bartender
Posts: 5852
7
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic