… 6.3, and the filesystem used for the test was XFS, mounted with both the noatime,nodiratime options. The card was… (maxperformance reserves some additional space internally to provide better write performance). In “maxcapacity” mode, the device tested provides approximately 2200GB of… of predictable performance; the standard deviation on the asynchronous random read throughput measurement is only 5.7MiB/sec. However, the overall read throughput…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
… the explanation of the hash join lets see how it performs for different test cases. Benchmarks For the purpose of the… disks are 5.4K RPM disks. The filesystem used is XFS, and the OS installed is Centos 6.2 Table Structure… would perform better than Hash Join when you are joining two tables on a PK column such that both tables are read…
Post: linux.conf.au 2012 roundup
January 24, 2012 By Leave a Comment
…on a variety of topics – everything from filesystem performance to open hardware, to repurposing existing hardware … Corbet You can skip this only if you read every single mail on LKML, run your … a lot of the recent improvements in XFS. Especially interesting for those with metadata heavy workloads….
Post: RAID throughput on FusionIO
March 24, 2010 By 7 Comments
…in the previous experiment, as I am running XFS with nobarrier mount options. OS is CentOS 5…usable, and how it performs on regular hard drives or SSD disks. The performance drop in RAID settings…disks read/110810.08 read/1666316.29 write/18830.49 write/1618687.97 raid10 n2 read/111612.89 read/1699170…
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 14 Comments
…in RightScale environment, I noticed that IO performance on EBS volume in EC2 cloud is…tested IO on single volume. I used xfs filesystem mounted with noatime,nobarrier options … seqrd (sequential read), seqwr (sequential write), rndrd (random read), rndwr (random write), rndrw (random read-write). And…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…valgrind-3.8.1.tar.bz2 # Or newer tar -xf valgrind-3.8.1.tar.bz2 cd valgrind-…mysqld) | ->27.73% (114,084,096B) 0x7255BB: Log_event::read_log_event(char const*, unsigned int, char const**, …, you’ll likely find that the default options will perform well in most scenario’s. For the technically advanced…
Post: Benchmarks of Intel 320 SSD 600GB
February 22, 2012 By 2 Comments
… an access to the server), and compare performance with SAS hard drives. System specification Dell… Cheetah 15K 600GB 16MB Cache SAS Filesystem: XFS, mkfs.xfs -s size=4096, mount -o nobarrier …sysbench workload is pretty nasty, MySQL will mostly reads and writes pages from buffer pool (replacing…
Post: Working with many files and file system fragmentation
March 18, 2008 By 11 Comments
… the read speed on the files we end up with, compared to just writing the file sequentially and reading it back. The performance difference was huge – we could read single file at 80MB/sec while… see how other filesystems deal with this problem, for example XFS with delayed allocation may be doing better job. I also…
Post: Should I buy a Fast SSD or more memory?
April 8, 2010 By 10 Comments
… when they still have a lot of pages read/second – I would have preferred to buy memory … million rows (about 18GB worth of data+indexes) XFS Filesystem mounted with nobarrier option. Tests run with:… – because while memory decreased by only ~10% the performance dropped by 2.6 times! In production …
Comment: Is there room for more MySQL IO Optimization?
January 9, 2013 By 11 Comments
Dimitri, This was on XFS. I’m looking more into it and will provide more … I think the fact filesystem is doing more paralel reads and/or read ahead is a fact though the question is Why… point. If there is endless buffering etc would not the performance in buffered mode be a lot worse not other way…
