Class: Maatkit::TableChecksum

Inherits:
Object
  • Object
show all
Defined in:
lib/maatkit-ruby/mk-table-checksum.rb

Overview

Perform an online replication consistency check, or checksum MySQL tables efficiently on one or many servers.

Maatkit::TableChecksum.new( array, str, array)

Instance Attribute Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize ⇒ TableChecksum

Returns a new TableChecksum Object



94
95
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 94

def initialize()
end

Instance Attribute Details

#algorithm ⇒ Object

(No # value)



15
16
17
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 15

def algorithm
  @algorithm
end

#arg_table ⇒ Object

(No # value)



16
17
18
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 16

def arg_table
  @arg_table
end

#ask_pass ⇒ Object

FALSE



17
18
19
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 17

def ask_pass
  @ask_pass
end

#check_interval ⇒ Object

1



18
19
20
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 18

def check_interval
  @check_interval
end

#check_replication_filters ⇒ Object

TRUE



19
20
21
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 19

def check_replication_filters
  @check_replication_filters
end

#check_slave_lag ⇒ Object

(No # value)



20
21
22
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 20

def check_slave_lag
  @check_slave_lag
end

#checksum ⇒ Object

FALSE



21
22
23
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 21

def checksum
  @checksum
end

#chunk_column ⇒ Object

(No # value)



22
23
24
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 22

def chunk_column
  @chunk_column
end

#chunk_index ⇒ Object

(No # value)



23
24
25
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 23

def chunk_index
  @chunk_index
end

#chunk_size ⇒ Object

(No # value)



24
25
26
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 24

def chunk_size
  @chunk_size
end

#chunk_size_limit ⇒ Object

(No # value)



25
26
27
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 25

def chunk_size_limit
  @chunk_size_limit
end

#columns ⇒ Object

(No # value)



26
27
28
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 26

def columns
  @columns
end

#config ⇒ Object

/etc/maatkit/maatkit.conf,/etc/maatkit/mk_table_checksum.conf,/home/joel/.maatkit.conf,/home/joel/.mk_table_checksum.conf



27
28
29
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 27

def config
  @config
end

#count ⇒ Object

FALSE



28
29
30
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 28

def count
  @count
end

#crc ⇒ Object

TRUE



29
30
31
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 29

def crc
  @crc
end

#create_replicate_table ⇒ Object

FALSE



30
31
32
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 30

def create_replicate_table
  @create_replicate_table
end

#databases ⇒ Object

(No # value)



31
32
33
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 31

def databases
  @databases
end

#defaults_file ⇒ Object

(No # value)



32
33
34
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 32

def defaults_file
  @defaults_file
end

#empty_replicate_table ⇒ Object

FALSE



33
34
35
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 33

def empty_replicate_table
  @empty_replicate_table
end

#engines ⇒ Object

(No # value)



34
35
36
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 34

def engines
  @engines
end

#explain ⇒ Object

FALSE



35
36
37
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 35

def explain
  @explain
end

#explain_hosts ⇒ Object

FALSE



36
37
38
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 36

def explain_hosts
  @explain_hosts
end

#float_precision ⇒ Object

(No # value)



37
38
39
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 37

def float_precision
  @float_precision
end

#function ⇒ Object

(No # value)



38
39
40
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 38

def function
  @function
end

#help ⇒ Object

TRUE



39
40
41
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 39

def help
  @help
end

#ignore_columns ⇒ Object

(No # value)



40
41
42
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 40

def ignore_columns
  @ignore_columns
end

#ignore_databases ⇒ Object

(No # value)



41
42
43
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 41

def ignore_databases
  @ignore_databases
end

#ignore_engines ⇒ Object

FEDERATED,MRG_MyISAM



42
43
44
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 42

def ignore_engines
  @ignore_engines
end

#ignore_tables ⇒ Object

(No # value)



43
44
45
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 43

def ignore_tables
  @ignore_tables
end

#lock ⇒ Object

FALSE



44
45
46
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 44

def lock
  @lock
end

#max_lag ⇒ Object

1



45
46
47
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 45

def max_lag
  @max_lag
end

#modulo ⇒ Object

(No # value)



46
47
48
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 46

def modulo
  @modulo
end

#offset ⇒ Object

(No # value)



47
48
49
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 47

def offset
  @offset
end

#optimize_xor ⇒ Object

TRUE



48
49
50
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 48

def optimize_xor
  @optimize_xor
end

#password ⇒ Object

(No # value)



49
50
51
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 49

def password
  @password
end

#path_to_mk_table_checksum ⇒ Object

Sets the executable path, otherwise the environment path will be used.



89
90
91
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 89

def path_to_mk_table_checksum
  @path_to_mk_table_checksum
end

#pid ⇒ Object

(No # value)



50
51
52
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 50

def pid
  @pid
end

#port ⇒ Object

(No # value)



51
52
53
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 51

def port
  @port
end

#probability ⇒ Object

100



52
53
54
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 52

def probability
  @probability
end

#quiet ⇒ Object

FALSE



53
54
55
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 53

def quiet
  @quiet
end

#recheck ⇒ Object

FALSE



54
55
56
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 54

def recheck
  @recheck
end

#recurse ⇒ Object

FALSE



55
56
57
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 55

def recurse
  @recurse
end

#recursion_method ⇒ Object

(No # value)



56
57
58
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 56

def recursion_method
  @recursion_method
end

#replicate ⇒ Object

(No # value)



57
58
59
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 57

def replicate
  @replicate
end

#replicate_check ⇒ Object

(No # value)



58
59
60
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 58

def replicate_check
  @replicate_check
end

#replicate_database ⇒ Object

(No # value)



59
60
61
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 59

def replicate_database
  @replicate_database
end

#resume ⇒ Object

(No # value)



60
61
62
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 60

def resume
  @resume
end

#resume_replicate ⇒ Object

FALSE



61
62
63
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 61

def resume_replicate
  @resume_replicate
end

#save_since ⇒ Object

FALSE



62
63
64
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 62

def save_since
  @save_since
end

#schema ⇒ Object

FALSE



63
64
65
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 63

def schema
  @schema
end

#separator ⇒ Object

#



64
65
66
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 64

def separator
  @separator
end

#set_vars ⇒ Object

wait_timeout=10000



65
66
67
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 65

def set_vars
  @set_vars
end

#since ⇒ Object

(No # value)



66
67
68
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 66

def since
  @since
end

#since_column ⇒ Object

(No # value)



67
68
69
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 67

def since_column
  @since_column
end

#single_chunk ⇒ Object

FALSE



68
69
70
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 68

def single_chunk
  @single_chunk
end

#slave_lag ⇒ Object

FALSE



69
70
71
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 69

def slave_lag
  @slave_lag
end

#sleep ⇒ Object

(No # value)



70
71
72
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 70

def sleep
  @sleep
end

#sleep_coef ⇒ Object

(No # value)



71
72
73
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 71

def sleep_coef
  @sleep_coef
end

#socket ⇒ Object

(No # value)



72
73
74
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 72

def socket
  @socket
end

#tab ⇒ Object

FALSE



73
74
75
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 73

def tab
  @tab
end

#tables ⇒ Object

(No # value)



74
75
76
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 74

def tables
  @tables
end

#throttle_method ⇒ Object

none



75
76
77
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 75

def throttle_method
  @throttle_method
end

#trim ⇒ Object

FALSE



76
77
78
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 76

def trim
  @trim
end

#unchunkable_tables ⇒ Object

TRUE



77
78
79
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 77

def unchunkable_tables
  @unchunkable_tables
end

#use_index ⇒ Object

TRUE



78
79
80
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 78

def use_index
  @use_index
end

#user ⇒ Object

(No # value)



79
80
81
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 79

def user
  @user
end

#verify ⇒ Object

TRUE



80
81
82
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 80

def verify
  @verify
end

#version ⇒ Object

FALSE



81
82
83
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 81

def version
  @version
end

#wait ⇒ Object

(No # value)



82
83
84
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 82

def wait
  @wait
end

#where ⇒ Object

(No # value)



83
84
85
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 83

def where
  @where
end

#zero_chunk ⇒ Object

TRUE



84
85
86
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 84

def zero_chunk
  @zero_chunk
end

Instance Method Details

#start(options = nil) ⇒ Object

Execute the command



100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
 
# File 'lib/maatkit-ruby/mk-table-checksum.rb', line 100

def start(options = nil)
  tmp = Tempfile.new('tmp')
  command = option_string() + options.to_s + " 2> " + tmp.path
  success = system(command)
  if success
    begin
      while (line = tmp.readline)
        line.chomp
        selected_string = line
      end
    rescue EOFError
      tmp.close
    end
    return selected_string
  else
    tmp.close!
    return success
  end
end