MySQL两种表存储结构MyISAM和InnoDB的性能比较测试

MySQL两种表存储结构MyISAM和InnoDB的性能比较测试(3)         c.execute(sql)
    except MySQLdb.OperationalError,error:
        print "AddTable Error:",error
        return -1;
    return c.rowcount

def main():

    argv = sys.argv

    if len(argv) < 2:
        print 'Usage:',argv[0],' TableId TestCount \n'
        sys.exit(1)
   
    global c        #mysql访问cursor

   
    db_host = "localhost"
    db_name = "demo"
    db_user = "root"
    db_user_passwd = ""
   
    print "Config:[%s %s/%s %s] DB\n"%(db_host,db_user,db_user_passwd,db_name)
    
    if len(argv) > 2:
        tableid = argv[1]
        testcount = int(argv[2])   #

    for test in testtables:
        #每次操作前都重写建立数据库连接   
        try:
            mdb = MySQLdb.connect(db_host, db_user, db_user_passwd, db_name)
        except MySQLDb.OperationalError,error:
            print "Connect Mysql[%s %s/%s %s] DB Error:"%(db_host,db_user,db_user_passwd,db_name),error,"\n"