def turn_off_general_log(self): conn = MysqlConnUtil(host=self._mysql_meta.ip, user=self._mysql_meta.mysql_user, passwd=self._mysql_meta.mysql_password, db='', port=self._mysql_meta.mysql_port, autocommit=True) res, err = conn.execute("set global general_log=off") assert err is None, "turn off general log fail for {0}".format(err[1]) conn.close()
def turn_on_general_log(self, to_clean_old_file=True): if to_clean_old_file: self.turn_off_general_log_and_clean() conn = MysqlConnUtil(host=self._mysql_meta.ip, user=self._mysql_meta.mysql_user, passwd=self._mysql_meta.mysql_password, db='', port=self._mysql_meta.mysql_port, autocommit=True) res, err = conn.execute("set global general_log=on") assert err is None, "set general log on fail for {0}".format(err[1]) conn.close()
def kill_all_conns(self, exclude_conn_ids=None): conn = MysqlConnUtil(host=self._mysql_meta.ip, user=self._mysql_meta.mysql_user, passwd=self._mysql_meta.mysql_password, db='', port=self._mysql_meta.mysql_port, autocommit=True) res, err = conn.execute("show processlist") for row in res: conn_id = row[0] not_show_processlist = row[7] != "show processlist"#for excluding show processlist conn itself if not_show_processlist and exclude_conn_ids and str(conn_id) not in exclude_conn_ids: res, err = conn.execute("kill {}".format(conn_id)) assert err is None, "kill conn '{}' failed for {}".format(conn_id,err[1]) logger.debug("kill connections success, excluding connection ids:{}".format(exclude_conn_ids)) conn.close()
def turn_off_general_log_and_clean(self): conn = MysqlConnUtil(host=self._mysql_meta.ip, user=self._mysql_meta.mysql_user, passwd=self._mysql_meta.mysql_password, db='', port=self._mysql_meta.mysql_port, autocommit=True) res, err = conn.execute("set global log_output='file'") assert err is None, "get general log file fail for {0}".format(err[1]) res, err = conn.execute("set global general_log=off") assert err is None, "set general log off fail for {0}".format(err[1]) res, err = conn.execute("show variables like 'general_log_file'") assert err is None, "get general log file fail for {0}".format(err[1]) general_log_file = res[0][1] ssh = self._mysql_meta.ssh_conn rc, sto, ste = ssh.exec_command('rm -rf {0}'.format(general_log_file)) assert len(ste) == 0, "rm general_log_file fail for {0}".format(ste) conn.close() self._mysql_meta.close_ssh()
def do_execute_query(self, query_meta): conn = DbleObject.dble_long_live_conns.get(query_meta.conn_id, None) if conn: logger.debug( "find a exist conn of dble '{0}' to execute query".format( query_meta.conn_id)) else: logger.debug( "Can't find a exist dble conn '{0}', try to create a new conn". format(query_meta.conn_id)) try: conn = MysqlConnUtil(host=query_meta.ip, user=query_meta.user, passwd=query_meta.passwd, db=query_meta.db, port=query_meta.port, autocommit=True, charset=query_meta.charset) except MySQLdb.Error as e: err = e.args return None, err, 0 assert conn, "expect {0} find or create success, but failed".format( query_meta.conn_id) starttime = datetime.datetime.now() res, err = conn.execute(query_meta.sql) endtime = datetime.datetime.now() time_cost = endtime - starttime logger.debug("to close {0} {1}".format(query_meta.conn_id, query_meta.bClose)) if query_meta.bClose.lower() == "false": DbleObject.dble_long_live_conns.update({query_meta.conn_id: conn}) else: DbleObject.dble_long_live_conns.pop(query_meta.conn_id, None) conn.close() return res, err, time_cost
def check_query_in_general_log(self, query, expect_exist, expect_occur_times_expr=None): conn = MysqlConnUtil(host=self._mysql_meta.ip, user=self._mysql_meta.mysql_user, passwd=self._mysql_meta.mysql_password, db='', port=self._mysql_meta.mysql_port, autocommit=True) res, err = conn.execute("show variables like 'general_log_file'") assert err is None, "get general log file fail for {0}".format(err[1]) conn.close() general_log_file = res[0][1] find_query_in_genlog_cmd = 'grep -ni "{0}" {1} | wc -l'.format(query, general_log_file) ssh = self._mysql_meta.ssh_conn rc, sto, ste = ssh.exec_command(find_query_in_genlog_cmd) if expect_exist: if expect_occur_times_expr is None: expect_occur_times_expr = "==1" real_occur_times_as_expected = eval("{0}{1}".format(sto, expect_occur_times_expr)) assert real_occur_times_as_expected, "expect '{0}' occured {1} times in general log, but it occured {2} times".format( query, expect_occur_times_expr, sto); else: assert 0 == int(sto), "expect general log has no {0}, but it occurs {1} times".format(query, sto);