Open main menu

Wikibooks β

Karrigell/Test Mysql

< Karrigell

Example using Mysql database

This simple program can be used to analyze your web server performance

this script might be saved as 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