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

MySQL两种表存储结构MyISAM和InnoDB的性能比较测试(2) '''
MyISAM,InnoDB性能比较
作者：空心菜（Invalid）
时间：2004-10-22
'''
import MySQLdb
import sys
import os
import string
import time

c = None

testtables = [("MyISAM_NT",None,0),
             ("MyISAM_TS",None,1),
             ("INNODB_NA_NB",0,0),
             ("INNODB_NA_BE",0,1),
             ("INNODB_AU_NB",1,0),
             ("INNODB_AU_BE",1,1)
             ]

def BeginTrans():

    print "ExeCSQL:BEGIN;"
    c.execute("BEGIN;")
   
    return

def Commit():
   
    print "ExecSQL:COMMIT;"
    c.execute("COMMIT;")
    return

def AutoCommit(flag):
   
    print "ExecSQL:Set AUTOCOMMIT = "+str(flag)
    c.execute("Set AUTOCOMMIT = "+str(flag))
    return
 
def getcount(table):
    #print  "ExecSQL:select count(*) from "+table
    c.execute("select count(*) from "+table)
    return c.fetchall()[0][0]
    
 
def AddTable (Table,TableId,TableString):

    sql = "INSERT INTO "+Table+"(TableId, TableString) VALUES( "+ TableId+ ",'" + TableString +"')"
    try: