…/en/innodb-memcached-setup.html As a quick benchmark, I ran some batches of fetch and store against both a standard memcached instance…_Libmemcached Here is the rough code for this benchmark: // Identical config/code for memcached vs InnoDB $frontendOpts = array( ‘caching’ => true, ‘lifetime’ => 3600…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… does it compare to InnoDB Memcache storing? 2) The gain in performance from SQL SELECT to InnoDB Memcache fetching seems very small… as the memcache plugin and managed to become several times faster than the SQL interface. 3) Can you also benchmark Handlersocket and see how it compares to Innodb memcache plugin?
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
April 2, 2013 By 10 Comments
… Peter mentioned), whereas ‘cache-only’ seems to be the traditional memcached behavior, where a cache of data is created, derived from… in mind. Mike, what setting did you use for your benchmark? based on this, it seems important to have a clear…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 2
October 16, 2009 By 8 Comments
… data in memcached gives very similar numbers to accessing 100% of the data in memory in the DB ( part 1 benchmarked a… performance! Using Memcached::Fast was kind of a mixed bag when looking at the benchmarks for mixing MySQL and Memcached in my tests… performance! Using Memcached::Fast was kind of a mixed bag when looking at the benchmarks for mixing MySQL and Memcached in my tests…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3
October 19, 2009 By 25 Comments
… almost 2x faster then combining memcached and MySQL, and about 20% slower then the all memory memcached approach. So for this… architectures in the future. So lets look at some scalability benchmarks, my server resources are rather limited but I thought I… 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
… ( at least temporarily ) outside the DB. Think memcached. Almost everyone loves memcached, it’s simple, fast, and just works. When… about performance in a 100% pure memcached environment. Part 3 will focus on these same benchmarks in Tokyo tyrant. All to often… data ( at least temporarily ) outside the DB. Think memcached. Almost everyone loves memcached, it’s simple, fast, and just works. When your…
Post: Tokyo Tyrant -The Extras Part III : Write Bottleneck
November 12, 2009 By 3 Comments
… should work. I had an idea about using the memcached client to distribute the data accross multiple TC database files…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
… of MySQL Query Cache and File Cache. Jay uses Apache Benchmark to compare full full stack, cached or not which is… shared memory. Appendinx: If you would like to repeat my benchmark or experiment with more caches here are source files and…, ie query cache enabled, memcached running, apc enabled for cli mode etc. Main PHP File: global.php file with benchmark function: Enjoy 
Post: Looking at Redis
August 27, 2009 By 27 Comments
… data from the master as it comes. I did not benchmark the replication capacity but I’d expect it to be… 100K of writes/sec the single instance can handle. The benchmarks I’ve done were for applications which is very update… cache (it supports data expiration too) I have not benchmarked it against memcache in terms of performance and memory usage. This may…
Comment: Thoughts on MySQL Replication
July 9, 2006 By 18 Comments
… is often overlooked for some reason. MyISAM row cache in memcached could be interesting and actually not that hard to implement… avoid caching same data by same nodes. I have not benchmarked it however – should do once have a chance. Speaking about… the disk in MySQL 5.1 – I however have not benchmarked it that seriously. I also guess it would take at…
