python操作DB汇总

一、长连接如何避免mysql server go away

def executeSQL(self,sql=""):
        try:
            self.conn.ping()
        except Exception,e:
            logger.error("Msql出了问题")
            logger.error(str(e))
            while True:
                try:
                    self.conn = MySQLdb.connect(self.config.get('mysql_server'),self.config.get('mysql_user'),self.config.get('mysql_pass'),self.config.get('mysql_db_name'),connect_timeout=60,compress=True,charset="UTF8")
                    break
                except Exception,e:
                    logger.error("尝试重连接失败")
                    time.sleep(2)
                    continue
            self.cursor=self.conn.cursor()

二、多线程环境如何构造数据库连接池提升性能