DeNA / HandlerSocket-Plugin-for-MySQL

HandlerSocket is a NoSQL plugin for MySQL, working as a daemon inside the mysqld process, to accept tcp connections, and execute requests from clients. HandlerSocket does not support SQL queries; instead it supports simple CRUD operations on tables.
Other
1.13k stars 150 forks source link

The binlog execute time is wrong #76

Open rj03hou opened 12 years ago

rj03hou commented 12 years ago

at 3739797

700101 8:00:00 server id 211603306 end_log_pos 3739693 Delete_rows: table id 46 flags: STMT_END_F

BINLOG ' AAAAABNqz5wMLQAAAAcQOQAAAC4AAAAAAAEABHRlc3QABXRlc3QyAAIDAwAA AAAAABlqz5wMJgAAAC0QOQAAAC4AAAAAAAEAAv/8DicAAAIAAAA= '/!/;

DELETE FROM test.test2

WHERE

@1=9998 /* INT meta=0 nullable=0 is_null=0 */

@2=2 /* INT meta=0 nullable=0 is_null=0 */

at 574

700101 8:00:00 server id 211603306 end_log_pos 574 Table_map: test.ctest mapped to number 33

700101 8:00:00 server id 211603306 end_log_pos 620 Write_rows: table id 33 flags: STMT_END_F

BINLOG ' AAAAABNqz5wMLgAAAD4CAAAAACEAAAAAAAEABHRlc3QABWN0ZXN0AAMIAwMAAA== AAAAABdqz5wMLgAAAGwCAAAAACEAAAAAAAEAA//4UiHtMAAAAAABAAAAAgAAAA== '/!/;

INSERT INTO test.ctest

SET

@1=820846930 /* LONGINT meta=0 nullable=0 is_null=0 */

@2=1 /* INT meta=0 nullable=0 is_null=0 */

@3=2 /* INT meta=0 nullable=0 is_null=0 */

at 620

the time of the execute is always "700101 8:00:00"

client:python,perl server:Percona 5.5.17-55 5.5.17-55 compile handlersocket version:1.0.6-97-g0986a75

zephyrleaves commented 12 years ago

Becaues handlersocket didn't set THD's start_time,so the binlog event's when is 0. so .......