0

Have added the directive in my.cnf

log-bin

Both the binlog and index files are created, but seems the binlog file remain unchanged even I massively insert data into the db.

Howard
  • 2,135
  • 13
  • 48
  • 72

2 Answers2

0

One possibility might be that if you are inserting into a transactional table but have not committed the data yet with a COMMIT statement all those inserts would be cached.

Kyle Brandt
  • 83,619
  • 74
  • 305
  • 448
0

This may be a wild guess, but it sounds like this is either a secondary master or slave host? Add the following line to your my.cnf and restart mysqld:

log-slave-updates
randomx
  • 1,004
  • 1
  • 8
  • 14