MemcachedvsMySQLMemoryenginetable speed comparison

Original post: hi.baidu.comjabberblogitem757873f455cf32d9f2d385eb.html memcachedvsMySQLMemoryenginetable speed: 2006-11-1419: 03 Performancecompare: Timhi. baidu. comjabberblogcategoryMemcachedmemcached1.2.0MySQL5.0.

Original post: http://hi.baidu.com/jabber/blog/item/757873f455cf32d9f2d385eb.html memcached vs MySQL Memory engine table speed comparison Performance compare: Tim http://hi.baidu.com/jabber/blog/category/Memcached memcached 1.2.0 MySQL 5.0.

Original post: http://hi.baidu.com/jabber/blog/item/757873f455cf32d9f2d385eb.html

Memcached vs MySQL Memory engine table speed comparison

Performance compare: Tim http://hi.baidu.com/jabber/blog/category/Memcached Memcached 1.2.0 MySQL 5.0.26 with MEMORY (heap) engine Number of records: 0.5 million ~ 1 million Single-host, client access from another machine Data: about KB Memcachedset/get 15,000/s MySQL memory table: insert/select 5,000/s Conclusion: The memcached read/write speed is about three times faster than mysql memory table. Advantages: MySQL: Suitable for querying cache data using the Select condition. MemCached: You can set exptime (time-out period) without managing it yourself.

Category: Memcached | added to souzang | browsing (822)

Recent readers:

Then, you will appear here. "); Script appears here after you log on.

Comments:

";}Else {if (cmtname =" "| cmtname =" anonymous ") {if (cmturl =" ") {html1 =" anonymous ";} else {html1 = "" + cmtname + "" ;}} else {if (cmturl = "") {html1 ="

Netizen: "+ cmtname +"

";} Else {html1 ="

Netizen: "+ cmtname +"

";}}} Document. write (html1);} script

2

Netizen: wjackie

Memcache can set/get up to 15000 data records per second! I use the php function to get first, and then replace according to the matching degree. There are only about 40 entries per second. The larger the value of a single key, is the longer the replace time? I used only one key and searched it using the php method. Does this affect performance?

3

Iso1600

It should not be a problem for php to reach thousands. I have discussed the server performance above. Assuming that the client performance is optimized, the above results are obtained by testing with two similar java clients called. If your data is too different from this, it indicates that your client program has problems or needs to be adjusted.

4

User: hickwu

I tested php with a maximum efficiency of 30000 rps :)