MySQL版本:5.7.28
Redis版本: 3.0.6
Python源代码:
mysql_insert.py
#!/usr/bin/python3
import pymysql
import time
db = pymysql.connect("localhost","root","tkt","test_db", charset='utf8')
cursor = db.cursor()
try:
start=time.time()
db.begin()
times=0
for i in range(0, 100000):
sql="insert into t_student(name,age) values('student_{0}', {0})".format(i)
cursor.execute(sql)
times=times+1
db.commit()
end=time.time()
print("mysql insert data spend time: %s(s), times: %d" % (end-start, times))
except:
db.rollback()
db.close()
mysql_query.py
#!/usr/bin/python3
import pymysql
import time
db = pymysql.connect("localhost", "root", "tkt", "test_db", charset='utf8' )
cursor = db.cursor()
try:
start=time.time()
times=0
for i in range(0, 100000):
sql = "select * from t_student where name='student_{0}'".format(i)
cursor.execute(sql)
times=times+1
end=time.time()
print("mysql query data spend time: %s(s), times=%d" % (end-start, times))
except:
print("Error: unable to fecth data")
db.close()
redis_get.py
#!/usr/bin/python3
import redis
import time
try:
pool = redis.ConnectionPool(host='127.0.0.1', password = 'tkt', port=6379)
except:
print("could not connect to redis.")
r = redis.Redis(connection_pool=pool)
start=time.time()
times=0
for i in range(0, 100000):
value=r.get('key_'+str(i))
times=times+1
end=time.time()
print("redis get data spend time: %s(s), times: %d" % (end-start, times))
redis_set.py
#!/usr/bin/python3
import redis
import time
try:
pool = redis.ConnectionPool(host='127.0.0.1', password = 'tkt', port=6379)
except:
print("could not connect to redis.")
r = redis.Redis(connection_pool=pool)
start=time.time()
times=0
for i in range(0, 100000):
r.set('key_'+str(i), 'value_'+str(i))
times=times+1
end=time.time()
print("redis set data spend time: %s(s), times: %d" % (end-start, times))
运行效果: