#!/usr/bin/python
# -*- coding: latin-1 -*-

# Ce script checke toutes les minutes l'état du servier  MySQL
# et vérifie si le service est optimum

import os, sys, MySQLdb as mysql, time, exceptions, getopt

def hms(secs):
   s = secs % 60
   secs /= 60
   m = secs % 60
   secs /= 60
   h = secs
   return "%2d:%.2d:%.2d" % (h, m, s)

def usage():
        print " usage "
        print "-h --help    print this help menu"
        print "-t --threads print some threads info on mysql server"
        print "-c --connect print info about connection clients"
        print "-o xx --options=xx print info about server options"

pos = 1
options = ''
level = ''

try:
        opts, args = getopt.getopt(sys.argv[1:], "ht:c:o:v", ["help", "option=","thread","connect"])
except getopt.GetoptError:
        usage()
        sys.exit(2)


for opt,arg in opts:
        if opt in ("-t","--thread"):
                options = "Threads%"
                level = int(arg)
        if opt in ("-c","--connect"):
                options = "Connect%"
                level = int(arg)
        if opt in ("-o","--options"):
                options = arg

#log = open('/var/log/mysql-status.log', 'a')
#
#sys.stdout.close()
#sys.stderr.close()
#
#sys.stdout = log
#sys.stderr = log

logged = None

sql  = mysql.connect(host = 'localhost', user = 'root', passwd = 'password')
sqlc = sql.cursor()

sqlc.execute( "SHOW STATUS LIKE '%s'" % options )


for a,b in sqlc.fetchall():
        
        if pos == level:
                print b
                sys.exit(1)

        pos += 1

print 0

# vim: set ts=3 sw=3: