Query history

Is there a way to see what queries have been run recently on a table in
mysql?

Thanks in advance!

rbr

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
> >