Guest User

Untitled

a guest
May 21st, 2018
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.41 KB | None | 0 0
  1. ree-1.8.7-2009.10 > require 'mysql_binlog'
  2. => true
  3. ree-1.8.7-2009.10 > b = MysqlBinlog::Binlog.new("mysql-bin.010156")
  4. => #<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">
  5. ree-1.8.7-2009.10 > pp b.read_event
  6. {:type=>:query_event,
  7. :header=>
  8. {:flags=>8,
  9. :timestamp=>1326307010,
  10. :event_type=>2,
  11. :server_id=>167852170,
  12. :event_length=>59,
  13. :position=>98,
  14. :next_position=>157},
  15. :event=>
  16. {:error_code=>0,
  17. :status_length=>21,
  18. :db=>"",
  19. :thread_id=>397766020,
  20. :query_length=>5,
  21. :elapsed_time=>1,
  22. :position=>117,
  23. :query=>"BEGIN",
  24. :db_length=>0},
  25. :position=>98}
  26. => nil
Add Comment
Please, Sign In to add comment