GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

problem about mixed binlog-format in percona5.5

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • problem about mixed binlog-format in percona5.5

    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)

  • #2
    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

    Comment


    • #3
      SET TIMESTAMP=1333588546/*!*/; ensures that the NOW() function returns the same value on slaves

      Comment

      Working...
      X