CODEWITHSUNDEEP
mysqlsqlloggingmariadb
Sandeep
Sandeep

Reputation: 1401

MySQL: Disable logging for table updates/inserts

Is there a way to disable logging of updates/inserts to a particular table in MySQL/MariaDB?

In our database we have multiple tables and we would like to disable the logging of INSERT and UPDATE events for a specific table only. SET GLOBAL general_log = 1; and SET GLOBAL general_log = 0; provide a pretty coarse level control over logging. We are looking for much finer-grained control over logging.

Upvotes: 0

Views: 1353

Answers (1)

danblack
danblack

Reputation: 14666

Use binary logging and put the particular table in its own database with binlog-ignore-db set for that database.

Upvotes: 1

Related Questions