Is there a way to log the select query instead of all general queries in mysql? -


i have enabled general log monitor retrieve queries. gave me queries(like insert,update , delete). have run cron job fetch select queries in general log. procedure more following steps.

  • mysql writes general log
  • i running job every 3 hours select query general log , write in file, clear general log.

so need select queries want logged instead of queries. there way achieve it? please guide me. in advance.


Comments