# problem about mixed binlog-format in percona5.5 **URL:** \ **Category:** Other MySQL® Questions\ **Created:** [April 4, 2012, 8:18pm UTC](https://forums.percona.com/t/problem-about-mixed-binlog-format-in-percona5-5/1790 "2012-04-04T20:18:49Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![justlooks](https://avatars.discourse-cdn.com/v4/letter/j/e274bd/32.png) [@justlooks](https://forums.percona.com/u/justlooks)\ **Post date:** [April 4, 2012, 8:18pm UTC](https://forums.percona.com/t/problem-about-mixed-binlog-format-in-percona5-5/1790/1 "2012-04-04T20:18:49Z")
i checked my binary log and find the unsafe SQL still log use SBS but my log format is mixed,why? #120405 9:15:46 server id 5551 end\_log\_pos 3817 Query thread\_id=81681 exec\_time=25 error\_code=0 SET TIMESTAMP=1333588546/_!_/; INSERT INTO toocle\_news\_base.news\_cate1 SET `nid` = ‘6630489’,`category` = ‘4511’, post\_time = now() /_!_/; mysql\> show variables like ‘binlog\_format’; ±--------------±------+ | Variable\_name | Value | ±--------------±------+ | binlog\_format | MIXED | ±--------------±------+ 1 row in set (0.00 sec) ---
**Author:** ![sterin](https://avatars.discourse-cdn.com/v4/letter/s/3ab097/32.png) [@sterin](https://forums.percona.com/u/sterin)\ **Post date:** [April 5, 2012, 2:22am UTC](https://forums.percona.com/t/problem-about-mixed-binlog-format-in-percona5-5/1790/2 "2012-04-05T02:22:33Z")
I’m not really sure what you are asking but binlog\_format=MIXED actually means that most of the logging is SBR. Ref:The manual binary-log-mixed ---
**Author:** ![jtokoph](https://avatars.discourse-cdn.com/v4/letter/j/f1d935/32.png) [@jtokoph](https://forums.percona.com/u/jtokoph)\ **Post date:** [April 5, 2012, 6:54pm UTC](https://forums.percona.com/t/problem-about-mixed-binlog-format-in-percona5-5/1790/3 "2012-04-05T18:54:09Z")
SET TIMESTAMP=1333588546/_!_/; ensures that the NOW() function returns the same value on slaves