1) Would you recommend EXT4 over XFS for MySQL on SSD? What about Btrfs or ZFS? Seems …
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… sysbench OLTP: It is worth noting here that EXT4 outperforms XFS by a fairly significant margin. The approximate raw numbers, in tabular format, are: – EXT4 XFS 13GiB BP 22000 7500 25GiB BP 17000 9000 50GiB BP…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
April 3, 2013 By 10 Comments
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…
Comment: ext4 vs xfs on SSD
May 3, 2012 By 26 Comments
… had to benchmark ext4 vs XFS, on a RAID10 of spinning drives. Many DBAs like to assert that XFS is the way to… MySQL, but I’m not sure how frequently they benchmark XFS vs ext4, and how much of their recommendation comes from the… statistically significant impact on performance, which seems to indicate that XFS had some bottleneck internally, maybe the lock contention issue that…
Comment: Drop table performance
April 20, 2011 By 22 Comments
Vadim, do you know the timing of these tests XFS vs. ext4?
Comment: Is your server's performance about to degrade?
May 19, 2010 By 13 Comments
Baron, I decided against XFS (picking JFS) for our servers when I bumped into these two bugs: … know those are from 2007, but since you’re recommending XFS ‘without hesitation’ I thought I’d ask: Have you ever (more recently) run into problems like those two bugs with XFS/LVM/MD? Or is it that I should just give…
Post: ext4 vs xfs on SSD
March 15, 2012 By 26 Comments
… thread: 87 MiB/sec ext4 4 threads: 74 MiB/sec xfs 4 threads: 97 MiB/sec Dropping performance in case with… not test it. At this point we may decide that xfs is still preferable, but there is one more point to… see running MySQL benchmarks (to be published later) on ext4 vs xfs. Actually amount of threads does not affect the result significantly…
