Re: log-bin not logging UPDATEs

[Johnny Boy]

Actually when I run this on my beta server which doesn't have any traffic and it runs mysql Server version: 5.0.45-log FreeBSD port: mysql-server-5.0.45_1,

it turns out it does write something to the log, but it's different from what gets written when running the mysql console command.

Here is my diff on mysqlbinlog output before and after I run the update with python:

beta# diff db.sql-log db2.sql-log
4031a4032,4036
> # at 179821
> # at 179890
> # at 179989
> #080215 9:20:08 server id 1 end_log_pos 180016 Xid = 8392
> COMMIT/*!*/;


Here is what the diff looks like if I run the query in the mysql command:

beta# diff db3.sql-log db4.sql-log
4043a4044,4054
> # at 180145
> #080215 9:23:55 server id 1 end_log_pos 180217 Query thread_id=2541 exec_time=0 error_code=0
> SET TIMESTAMP=1203063835/*!*/;
> BEGIN/*!*/;
> # at 180217
> #080215 9:23:51 server id 1 end_log_pos 100 Query thread_id=2541 exec_time=2 error_code=0
> SET TIMESTAMP=1203063831/*!*/;
> UPDATE database.table SET field=321/*!*/;
> # at 180317
> #080215 9:23:55 server id 1 end_log_pos 180344 Xid = 8400
> COMMIT/*!*/;