def get_mysql_tcp_state(self):
     my_dic = {}
     os_get = OS(None)
     variables = self.__my_conn.mysql_show_variables()
     try:
         timewait = os_get.get_tcp_status(variables['port'], 'TIME_WAIT')
         established = os_get.get_tcp_status(variables['port'], 'ESTABLISHED')
     except:
         timewait = 0
         established = 0
     my_dic['time_wait'] = timewait
     my_dic['established'] = established
     return convert_dict_to_object(dict_key2lower(my_dic))
 def get_mysql_memory_report(self):
     my_dic = {}
     variables = self.__my_conn.mysql_show_variables()
     pid_file = variables['pid_file']
     os_get = OS(None)
     try:
         my_dic = os_get.get_pid_memory_info(None, pid_file)
         if my_dic != None:
             return convert_dict_to_object(dict_key2lower(my_dic))
         else:
             return None
     except:
         pass
    def get_mysql_mem_usage(self):
        my_dic = {}
        os_get = OS(None)
        mysql_usage = self.__my_conn.mysql_memory_usage()
        meminfo = os_get.get_mem_info()
        try:
            ram = long(kbytes2bytes(meminfo.memtotal)) # bytes
            if ram < mysql_usage:
                ram = CONS_RAM_SERVER # 128 GB Ram
        except:
            ram = CONS_RAM_SERVER # 128 GB Ram

        my_dic['mysql_usage'] = fixfloat(round(mysql_usage, 2))  #bytes
        my_dic['usage_ram_free_size'] = fixfloat(round(ram - mysql_usage, 2))
        my_dic['usagem_ram_percent'] = round(mysql_usage * 100 / ram, 2)
        return convert_dict_to_object(dict_key2lower(my_dic))