Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to find out the SQL command 1

Status
Not open for further replies.

jsgoober

Programmer
Jan 3, 2002
12
US
Is there a way to capture/see what SQL command the user
is running/using inside of the MySQL database?

Meaning if the user said his app is running really slow,
how can I see what his SQL is doing?

Again, thanks for the help.
 
If you run this command at prompt

mysqladmin -u root -ppassword extended-status

it will give you a a list of all parameters of your server including the number of slow queries but it won't show you the query string
You can see more from a GUI like MYSQL-front or MySQL CC in the administration panel.

Bye

Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top