Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ree-1.8.7-2009.10 > require 'mysql_binlog'
- => true
- ree-1.8.7-2009.10 > b = MysqlBinlog::Binlog.new("mysql-bin.010156")
- => #<MysqlBinlog::Binlog:0x10160a4f8 @format_cache={[{:length=>4, :format=>"V", :name=>:timestamp}, {:length=>1, :format=>"C", :name=>:event_type}, {:length=>4, :format=>"V", :name=>:server_id}, {:length=>4, :format=>"V", :name=>:event_length}, {:length=>4, :format=>"V", :name=>:next_position}, {:length=>2, :format=>"v", :name=>:flags}]=>{:length=>19, :format=>"VCVVVv"}, [{:length=>4, :format=>"V", :name=>:magic}]=>{:length=>4, :format=>"V"}, [{:length=>2, :format=>"v", :name=>:binlog_version}, {:length=>50, :format=>"A50", :name=>:server_version}, {:length=>4, :format=>"V", :name=>:create_timestamp}, {:length=>1, :format=>"C", :name=>:header_length}]=>{:length=>57, :format=>"vA50VC"}}, @fde={:header_length=>19, :binlog_version=>4, :server_version=>"5.0.84-percona-highperf-b19-log"}, @binlog=#<File:mysql-bin.010156>, @filename="mysql-bin.010156">
- ree-1.8.7-2009.10 > pp b.read_event
- {:type=>:query_event,
- :header=>
- {:flags=>8,
- :timestamp=>1326307010,
- :event_type=>2,
- :server_id=>167852170,
- :event_length=>59,
- :position=>98,
- :next_position=>157},
- :event=>
- {:error_code=>0,
- :status_length=>21,
- :db=>"",
- :thread_id=>397766020,
- :query_length=>5,
- :elapsed_time=>1,
- :position=>117,
- :query=>"BEGIN",
- :db_length=>0},
- :position=>98}
- => nil
Add Comment
Please, Sign In to add comment