Karrigell/Test Mysql
Appearance
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