Module: ZabbixRubyClient::Plugins::Mysql

Extended by:
Mysql
Included in:
Mysql
Defined in:
lib/zabbix-ruby-client/plugins/mysql.rb

Instance Method Summary collapse

Instance Method Details

#collect(*args) ⇒ Object 



8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
 
# File 'lib/zabbix-ruby-client/plugins/mysql.rb', line 8

def collect(*args)
  host = args[0]
  mysqlargs = args[1]
  mysqlstatus = `mysqladmin #{mysqlargs} extended-status`
  if $?.to_i == 0
    status = get_status(mysqlstatus)
  else
    Log.warn "The connection failed."
    return []
  end

  time = Time.now.to_i
  back = []
  back << "#{host} mysql.status[Aborted_clients] #{time} #{status["Aborted_clients"]}"
  back << "#{host} mysql.status[Aborted_connects] #{time} #{status["Aborted_connects"]}"
  back << "#{host} mysql.status[Bytes_received] #{time} #{status["Bytes_received"]}"
  back << "#{host} mysql.status[Bytes_sent] #{time} #{status["Bytes_sent"]}"
  back << "#{host} mysql.status[Com_admin_commands] #{time} #{status["Com_admin_commands"]}"
  back << "#{host} mysql.status[Com_begin] #{time} #{status["Com_begin"]}"
  back << "#{host} mysql.status[Com_change_db] #{time} #{status["Com_change_db"]}"
  back << "#{host} mysql.status[Com_check] #{time} #{status["Com_check"]}"
  back << "#{host} mysql.status[Com_commit] #{time} #{status["Com_commit"]}"
  back << "#{host} mysql.status[Com_delete] #{time} #{status["Com_delete"]}"
  back << "#{host} mysql.status[Com_insert] #{time} #{status["Com_insert"]}"
  back << "#{host} mysql.status[Com_rollback] #{time} #{status["Com_rollback"]}"
  back << "#{host} mysql.status[Com_lock_tables] #{time} #{status["Com_lock_tables"]}"
  back << "#{host} mysql.status[Com_select] #{time} #{status["Com_select"]}"
  back << "#{host} mysql.status[Com_show_fields] #{time} #{status["Com_show_fields"]}"
  back << "#{host} mysql.status[Com_unlock_tables] #{time} #{status["Com_unlock_tables"]}"
  back << "#{host} mysql.status[Com_update] #{time} #{status["Com_update"]}"
  back << "#{host} mysql.status[Connections] #{time} #{status["Connections"]}"
  back << "#{host} mysql.status[Created_tmp_disk_tables] #{time} #{status["Created_tmp_disk_tables"]}"
  back << "#{host} mysql.status[Created_tmp_tables] #{time} #{status["Created_tmp_tables"]}"
  back << "#{host} mysql.status[Slave_running] #{time} #{status["Slave_running"]}"
  back << "#{host} mysql.status[Slow_queries] #{time} #{status["Slow_queries"]}"
  back << "#{host} mysql.status[Uptime] #{time} #{status["Uptime"]}"
  back << "#{host} mysql.status[Questions] #{time} #{status["Questions"]}"
  return back
end

#get_status(status) ⇒ Object 



49
50
51
52
53
54
55
56
57
58
 
# File 'lib/zabbix-ruby-client/plugins/mysql.rb', line 49

def get_status(status)
  ret = {}
  status.each_line do |l|
    if l[0] == "|"
      _, k, v = l.split "|"
      ret[k.strip] = v.strip
    end
  end
  ret
end