memcached vs MySQL Memory engine table 速度比较

in 服务器类

memcached 1.2.0
MySQL 5.0.26 with MEMORY (heap) engine

记录数:50万~100万条

单机,client 从另外一台机访问
数据:单条 0.1K左右

memcached set/get 15,000 / s
MySQL memory table: insert/select 5,000 / s

结论:
memcached 读写速度是 mysql memory table 3倍左右

优点:
MySQL: 适合对 cache 数据进行Select条件查询。
MemCached: 可以设置 exptime (超时时间),无需自己管理

0 Comments

Leave a Reply

You must be logged in to post a comment.

Using Gravatars in the comments - get your own and be recognized!

XHTML: These are some of the tags you can use: <a href=""> <b> <blockquote> <code> <em> <i> <strike> <strong>