… I used MySQL 5.4/InnoDB, and all other parameters are the same from previous posts (100W, buffer_pool 3GB). Filesystem – XFS… SSD – 10681.050 TPM FusionIO – 17372.250 TPM However what should be noted – both SSD and FusionIO are run in “non-durable…. Here is my very rough calculation: For RAID 10 we use 8 73GB SAS 2.5″ 15K RPM disks, with price…
Comment: Benchmarks of new innodb_flush_neighbor_pages
July 3, 2012 By 8 Comments
…lock issue might be solved for this I still think the idea can be used to solve other problems…to remove.” ‘Note that on ext4 and xfs you should not have this problem as they would remove… worker flushing threads at a faster rate. There should be better ways of allowing read and writes without…
Comment: ext4 vs xfs on SSD
April 25, 2012 By 26 Comments
… – it should be available on official distribution, in repository, and often it has to pass QA cycle, which sometime can be as long as 6 months. Following your logic, it seems I just should go ahead and recommend to use btrfs to everyone, because it has so great concept. Who counts that it shows 5x worse performance than ext4/xfs…
Comment: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… i.e. you should check number of disks on the virtual drive that you’re working on (should be in the same output). For 12-disk RAID10 you would indeed use su=64k,sw=6 for xfs, though I… big fan of =) in which case for data disk you should use su=64k,sw=5.
Post: Should I buy a Fast SSD or more memory?
April 8, 2010 By 10 Comments
…/second – I would have preferred to buy memory instead, and use the storage device for writes. Here’s the benchmark I… with 80 million rows (about 18GB worth of data+indexes) XFS Filesystem mounted with nobarrier option. Tests run with: RAID10 with… market which use 8 Intel SSD devices). Is a 2x or 5x improvement enough? There are more wins to be had…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… still be unaligned, though xfs defragmentation may be able to fix that (not verified). 6. Added LVM on top of aligned partition table, used… should have really interesting effects. Large stripe on the other hand should somewhat reduce the effects of misalignment, though it would definitely be…
Post: linux.conf.au 2012 roundup
January 24, 2012 By Leave a Comment
…covered a lot of the recent improvements in XFS. Especially interesting for those with metadata heavy workloads. …It would be interesting to have a similar study on the database servers we all love and use. Migrating…. It’s only a 20minute talk, so you should really all go and watch it. Various static…
Post: FlashCache: first experiments
May 10, 2010 By 18 Comments
…: build over SSD-1 or SSD-2 * Filesystem XFS, builds as: mkfs.xfs -f -d su=16384,sw=40 /dev/sdc * mounted…, which could be related to additional driver layer. Read-Write case is more interesting. There I should mention that FlashCache uses WriteBack caching… benchmarks especially when data exceeds memory, and also it will be interesting to see how it works when we put FlashCache…
Post: Binary log file size matters (sometimes)
May 24, 2012 By 6 Comments
… used to think one should never look at max_binlog_size, however last year I… of interesting cases which showed that sometimes it may be very important variable to tune properly. I meant to …that long to remove. Note that on ext4 and xfs you should not have this problem as they would remove such …
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 26, 2012 By 20 Comments
…, and in which we clone new slaves from existing slaves using mylvmbackup or a method that is derived from that. Essentially… finds a crashed innodb, recovers this, and then it is being configured to become a new slave to the same master… READ LOCK (I believe it should work even without that). We are using CentOS 5.x, LVM2, XFS and Oracle MySQL 5.5…
