场景
memcache是一个分布式的、C/S结构的key/value存储系统。使用memcache可以有效地减轻MySQL的访问压力。
本文不介绍memcache的安装以及使用方法,只是简单的性能对比。
性能对比
第一次没有cache,需要到远端MySQL取数据回来,所以访问时间长,之后每次都命中cache,不需要访问MySQL。
附录:完整代码
#!/usr/bin/python
#coding: utf-8
import os, time
import fcntl
import hashlib
import memcache
from ConfigParser import SafeConfigParser
from datetime import datetime
from dao.dbinfo import *
from helper.mysqlhelper import *
from helper.loghelper4fr import g_logger
def md5(str):
m = hashlib.md5()
m.update(str)
key = m.hexdigest()
return key
def GetTotalCount():
''' Get player count. '''
dbMgr = DbManager(g_logger)
dbMgr.ConnectDb(DB_HOST, DB_USER, DB_PASSWD, DB_DBNAME, DB_PORT)
tablename = PLAYER_TABLE_NAME
count = dbMgr.GetTotalCount(tablename)
return count
def main():
mc = memcache.Client(['127.0.0.1:87654'], debug=0)
times = 10
for i in range(0, times):
start = time.time()
key = md5('GetTotalCount')
value = mc.get(key)
if not value:
count = GetTotalCount()
mc.set(key, count)
prompt = 'Not hit'
else:
count = value
prompt = 'Hit cache'
elapsed = time.time() - start
print prompt, 'Result:%d, Time elapsed: %f s' % (count, elapsed)
if __name__ == '__main__':
main()