More simplistic Memcache vs. Memcache observations: http://blog.ulf-wendel.de/2013/toying-with-peclmysqlnd_memcache-and-mysql-5-6-memcache-innodb/ HandlerSocket vs Memcache is hard to compare as one would compare apples…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… comparison between performance of 5.6 memcached innodb write/read vs 5.6 innodb write/read with no memcached layer? Currently…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… rough code for this benchmark: // Identical config/code for memcached vs InnoDB $frontendOpts = array( ‘caching’ => true, ‘lifetime’ => 3600, ‘automatic_serialization’ => true…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… this problem, you can use mysql_unbuffered_query instead and mysqli and PDO have their own way to reach similar behavior. This…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… id=”attachment_13599″ align=”alignright” width=”210″] MySQL 5.6 vs MySQL 5.5 & the Star Schema Benchmark[/caption] So far… cache Star Schema Benchmark – Scale Factor 1 – Mysql 5.5 vs 5.6 response times are in seconds (lower is better…
Post: ext4 vs xfs on SSD
March 15, 2012 By 26 Comments
… see running MySQL benchmarks (to be published later) on ext4 vs xfs. Actually amount of threads does not affect the result…
Post: SLC vs MLC
July 14, 2010 By Leave a Comment
… MLC devices, for example, if we take 10,000 writes vs 100,000 writes than to provide the same life time…
Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 13 Comments
… thoughts and interesting facts. First, chart with results for InnoDB vs InnoDB-plugin during runs (values are in new order transactions…
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
… in the difference of behavior of ANALYZE TABLE for MyISAM vs Innodb. I used the following simple table for tests: CREATE…
Post: Multiple column index vs multiple indexes
August 22, 2008 By 13 Comments
… there were questions raised about Index Merge on Multiple Indexes vs Two Column Index efficiency. I mentioned in most cases when…
