MySQL Forums
Forum List  »  Performance

log last x queries @3.23
Posted by: xnicnacx
Date: February 28, 2005 10:00AM

hi @ll
first post in this forum:)
following question:
is there any way to see the last x queries that were executed on a running 3.23 server without stopping it...? i have a pretty complex app making requests and would like to see what kind of select-queries runs most frequently, which is rather difficult to check in the app itself....

stopping the server and setting --log is not really an option as the server is live & is being depended on.......

show status only shows total numbers and %age of selects, updates etc....but i need it more detailed....

i tried mytop, but it only shows me the tables that my threads are accessing, not the actual queries as they are all delayed.....

any help is greatly appreciated


Options: ReplyQuote

Written By
log last x queries @3.23
February 28, 2005 10:00AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.