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…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
… almost to zero. We will run benchmarks with Thread Pool vs no-Thread Pool so we will see exact curve there…
Post: Testing the Virident FlashMAX II
March 21, 2013 By 1 Comment
… II: we see a read throughput of approximately 2580MiB/sec vs. 1450MiB/sec with the previous generation of hardware, an improvement…
Comment: Duplicate indexes and redundant indexes
September 21, 2006 By 38 Comments
… each of the same type T with T in (BTREE,FULLTEXT,RTREE,TTREE) then I1 is duplicate of I2 of the entire…
Comment: Duplicate indexes and redundant indexes
August 17, 2006 By 38 Comments
… is BTREE index and FULLTEXT index, while other combinations may also make sense.” You also might want to have BTREE and RTREE indexes on the same columns or even BTREE and HASH in certain rare cases.
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
… difference of behavior of ANALYZE TABLE for MyISAM vs Innodb. I used the following simple table for tests… | antest_innodb | 1 | i | 1 | i | A | 245900 | NULL | NULL | | BTREE | | | antest_innodb | 1 | c | 1 | c | A | 245900 | NULL …
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…
