…cache storage device. EXT4 is the filesystem, and CentOS 6.4 the operating …MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL…well using the base HDD MySQL configuration for purposes of comparison. Given the apparent differences…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… but this is not the point of comparison. “Failback could destroy the original master tooâ€,… if the filesystem on top of DRBD was fried beforehand. Let us again compare MySQL Replication … further degraded performance. In the large databases I run in production relaying on MySQL Replication for …
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
… workload was performed with a buffer pool size of 6G. The benchmarks compare Block Nested Loop (BNL) Join of MySQL 5.5… and the MySQL datadir is on a 4-disk Software RAID5 volume, the disks are 5.4K RPM disks. The filesystem used… scanning the right-side table becomes costly in comparison. Block Nested Loop Join would perform better than Hash Join when you are…
Post: Virident tachIOn: New player on Flash PCI-E cards market
June 15, 2010 By 19 Comments
… Centos 5.3 2-6.18.164 Kernel Filesystem is XFS formatted with mkfs.xfs -s size…. I think it would be fair to get comparison with FusionIO card, especially for write pressure case… Quite stable sequential writes performance (important in question for log related activity in MySQL) I am looking forward…
Post: RAID vs SSD vs FusionIO
May 1, 2009 By 17 Comments
… I used MySQL 5.4/InnoDB, and all other parameters are the same from previous posts (100W, buffer_pool 3GB). Filesystem – XFS… device, in comparison to RAID 10 on 8 disks) and FusionIO are impressive, it is worth to consider price/performance parameter. Here… will be cheaper than FusionIO), but it also may improve performance as such setup will be able to handle IO requests…
