… of memory, memached was started with 16 threads ( 1.4 memcached ), mysql was 5.1 XtraDB. Each environment had 2 tables each with 2 million rows. The data was identical. memcached… going to try and continue this series by exploring and benchmarking other NOSQL options and comparing them to database based solutions…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… pure memcached environment. Part 3 will focus on these same benchmarks in … can then compare using MySQL to using MySQL + Memcached, and then to other…). Seems simple enough right? My two tables each contain 5M rows of … lots and lots of memory allocated to memcached to be successful. This application…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 2
October 16, 2009 By 8 Comments
…memcached gives very similar numbers to accessing 100% of the data in memory in the DB ( part 1 benchmarked… Using Memcached::Fast was kind of a mixed bag when looking at the benchmarks for mixing MySQL and Memcached … often leave lots of performance on the table. Don’t just trust that your current …
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
… Cache 27000 Memcached Cache (TCP/IP) 12200 MySQL Query Cache (TCP/IP) 9900 MySQL Query Cache (Unix Socket) 13500 Selecting from table (TCP/IP… both on disk and in shared memory. Appendinx: If you would like to repeat my benchmark or experiment with more caches here…, ie query cache enabled, memcached running, apc enabled for cli mode etc. Main PHP File: global.php file with benchmark function: Enjoy 
