On 07/31/2012 05:28 PM, Rich Prohaska wrote:
> The innodb-safe-binlog variable no longer exists, but the binlog
> position is still stuffed into the innodb recovery log. Using recent
> MySQL versions, does this assist the DBA when running point in time
The position is printed on recovery and mainly to assist in provisioning
new slaves. The position can be used to know where to start replication
from, once the backup have been restored on a new slave. It can, as you
noted, also be used for point in time recovery.
To my knowledge, the position is not used anywhere else. In particular,
it is not used when recovering the server from a crash.
Just my few cents,
> On Fri, Jul 27, 2012 at 3:27 PM, Hartmut Holzgraefe
> <hartmut.holzgraefe@stripped> wrote:
>>> Why does InnoDB log the binlog position in its recovery log when a
>>> transaction commits?
>> as it needs to find out whether InnoDB state and binlog position are in
>> sync during recovery?
>> MySQL Internals Mailing List
>> For list archives: http://lists.mysql.com/internals
>> To unsubscribe: http://lists.mysql.com/internals
Senior Principal Software Developer
Oracle, MySQL Department