… billion of forum posts we decided to go ahead with raw drives for search index because it is far faster than using…. This has zero cost and offer redundancy in case of hard drive failure. Now regarding infrastructure. When being called for Consulting I… 2*2 Opterons with 32GB of RAM and 10-14 hard drives. Both solutions have comparable price/performance, though former depends on…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… had were rotating hard disk drives. I think the reason is very simple – when systems only had one bearing hard disk drive (HDD) as in RAID1 or one disk drive at all, you couldn’t really… partition table at all – you can just use the whole raw /dev/sdb and either format it with mkfs directly or…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… with multiple IO threads on systems with large amount of hard drives. Google has Patches which let you to try it out… too often and we’re only seeing 33% of the raw disk write speed. Since the commit isn’t perfectly serial… on single node. You can make them to use different hard drives and bind to different CPUs. Q25: In InnoDB, the referenced…
Post: Benchmarks of Intel 320 SSD 600GB
February 22, 2012 By 2 Comments
… Intel 320 SSD drives (NewRelic provided me with an access to the server), and compare performance with SAS hard drives. System specification Dell… can get 5.5T of useful space Intel drives: Intel 320 SSD 600GB HDD drives: Seagate Cheetah 15K 600GB 16MB Cache SAS… flushing problem. This is to investigate later. The scripts and raw results are on Benchmarks Launchpad. Follow @VadimTk !function(d,s…
Post: RAID throughput on FusionIO
March 24, 2010 By 7 Comments
… interesting question). There is graph for 16 threads runs, and raw results are below. As expected RAID1 over 2 disks shows… mode is really usable, and how it performs on regular hard drives or SSD disks. The performance drop in RAID settings is… I am going to look into is different page sizes. Raw results (in requests / seconds, more is better): single disk read…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
… (ON) / innodb_adaptive_checkpoint (estimate) were the default values. The raw results, full config files, and scripts are in our Benchmarks…. The flushing neighborhoods feature was created as an optimization for hard drives, since InnoDB tries to combine writing as many pages as…
Comment: RAID vs SSD vs FusionIO
May 1, 2009 By 17 Comments
… transfer rate for a second) which makes it a bit hard to compare, in particular because of density and scaling concerns… space as with Intel drives if space is a concern. It would be very interesting to see how raw IO, filesystems as well as MySQL scale with multiple Intel SSD drives of FusionIO cards. I…
Post: Fast storage: 8 SSD Intel X-25M 80GB benchmarks
January 18, 2010 By 15 Comments
… For benchmarks I used sysbench fileio benchmark. All raw results are available on Percona benchmarks wiki, …Sequential writes: I’d say sequential writes is hard task for both SSDs and FusionIO, it does… I put InnoDB transactional logs on rotation based drives instead of SSD in my InnoDB on FusionIO …
Comment: Tools
June 1, 2008 By 31 Comments
…?, scatter-gather?, etc. – hdparm : to gather infos about (and raw benchmark) ata drives – pmap : when you need a detailled map of processes memory usage, this is your tool – strace, ltrace, gdb, tcpdump, … for hard…
