Karrigell/Test Mysql

Example using Mysql database This simple program can be used to analyze your web server performance this script might be saved as testmysql.py and tested on a Karrigell server used alone or behind Apache # import MySQL module import MySQLdb import time t1 = time.clock() # connect db = MySQLdb.connect(host="localhost", user="root", passwd="123456",db="test") # create a cursor cursor = MySQLdb.cursors.DictCursor(db) # execute SQL statement cursor.execute("SELECT field1,field2 FROM table where field2 like '%%' limit 0,5000") # get the resultset as a tuple result = cursor.fetchallDict() print "Content-Type: text/plain\n\n" # iterate through resultset for record in result: # print record[0] , "-->", record[1] print "%s, %s" % (record['field1'], record['field2']) print "<br>" Now you can get the time spent by the query t2 = time.clock() t3 = t2 - t1 print t3