Logging queries?

[Liquid Fire]

Is there a possible way to log certain mysql queries(basically only update/empty/truncate/delete, stuff the either updates or removes data) and the time that the query was run?  I don't want to store select statement since the site runs million of those every few hours.  Any help in this would be great.

[Liquid Fire]

also note the version of mysql running in 4.1.20

[fenway]

Assuming you have your own DB wrapper class, this is simple... otherwise, there's a query log, but it's binary...

[Liquid Fire]

so then i would have to start the server with --log-bin=update.log and mysql with create that file and store any query that might update data

[fenway]

See here -- it will log everything.

[Liquid Fire]

I do not want to want to record select statement as they will not cause any issues and there will be millions of them a day, i just want anything that will effect data(delete or update it)

[fenway]

I do not want to want to record select statement as they will not cause any issues and there will be millions of them a day, i just want anything that will effect data(delete or update it)

You don't get that choice... you can easily clean up this file regularly... or roll your own.