I'm investigating some rows/tables that intermittently go missing on a Magento site, and of course there's no entries in the error log. (I suspect Magento queries/rules or human error might be the culprit) I know I can enable the General log, but I don't want to log EVERYTHING as this site processes a huge amount of sales every day and the log would be massive.
I'm hoping someone might know of a way to configure either the general log or log table to record only DELETE
commands. Open to any suggestions you might have of a better way to go about this.
DELETE
is concerned, I assume something like anINSERT INTO delete_log
would do the trick?