This is a discussion on Query history within the MySQL Database forums, part of the Database Forums category; Is there a way to see what queries have been run recently on a table in mysql? Thanks in advance! ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
You can switch on the query log in the config file:
# General log log=/some/path/allqueries.sql This way, any SQL is sent to that file. Quite useful for localhost databases and test servers, but it wastes a lot of space for production databases. Best regards rbr wrote: > Is there a way to see what queries have been run recently on a table in > mysql? > > Thanks in advance! > > rbr > |
|
|||
|
Thank you much. Especially for the eerily quick reply!
I believe my log is already on. I will need to go grep the log file for what I need. Thanks again. rbr Willem Bogaerts wrote: > You can switch on the query log in the config file: > > # General log > log=/some/path/allqueries.sql > > This way, any SQL is sent to that file. Quite useful for localhost > databases and test servers, but it wastes a lot of space for production > databases. > > Best regards > > rbr wrote: > > Is there a way to see what queries have been run recently on a table in > > mysql? > > > > Thanks in advance! > > > > rbr > > |