…the LV when we need to and align the partition correctly. We got decent tpcc performance, nearly 37k … maybe just normal. We didn’t try too hard to get better performance because we already had … other drive in the mirror. Better availability and disk usage On purpose, I allocated mirror pairs using …
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… RAID with 256k stripe element size and a misalignment in partition table – partition /dev/sdb1 starts 11 sectors ahead of the stripe… decide on very early when configuring RAID. Disk sectors Most if not all hard disk drives available on the market these days use…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…Size ========== ==== ======= ====== ======= ============ =========== Hard Disk SAS Online 0/0/0 SEAGATE ST3600057SS 558.911 Hard Disk SAS Online 0/0/0 SEAGATE ST3600057SS 558.911 Hard Disk … – for XFS file system on a raw partition I was using full partition size which was slightly over 1TB in …
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…case. There are whole classes of systems where Disk performance is not that important – consider for example…along you need enough concurrency to utilize multiple hard drives and with 50 drives you would need… whole datadir) and log files on the same partition as well because this makes it very easy…
Comment: InnoDB Flushing: a lot of memory and slow disk
April 1, 2011 By 57 Comments
… it comes to rotating disks. For blocks physically close to each other, head move isn’t necessary, the hard drive only has… on the whole hard disk, and run the same benchmark again on a small partition at the beginning of the disk. The number of… with a sequential io benchmark too, the beginning of the disk will be always faster, you can see “steps pattern” when…
Comment: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
… it comes to rotating disks. For blocks physically close to each other, head move isn’t necessary, the hard drive only has… on the whole hard disk, and run the same benchmark again on a small partition at the beginning of the disk. The number of… with a sequential io benchmark too, the beginning of the disk will be always faster, you can see “steps pattern” when…
Comment: MySQL: Data Storage or Data Processing
April 18, 2008 By 9 Comments
how i can switch mysql to use other partition of my hard disk to store data. i am a new kid for mysql. assist me for the same.
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…. Naturally, CSV files don’t store as compactly on disk as [Compressed] MyISAM or Archive. These are just some ideas… to avoid enormous tables that are hard to maintain, back up, and restore. And the partitioning functionality is not done yet… There are already inconvenient limitations on some key parts of partitioning, such as maintenance and repair commands, that essentially negate the…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
…accessed data stored in different servers), multi-server partitioning to use combined memory and a lot …with data access, saving you IO for completely disk bound workloads. There are certain optimizations in … query execution time is your concern many hard drives and large number of CPUs will not…
Post: RAID throughput on FusionIO
March 24, 2010 By 7 Comments
… FusionIO cards RAID1 over 2 RAID0 partitions (4 cards in total) RAID0 over 2 RAID1 partitions (4 cards in total) special RAID10… expected RAID1 over 2 disks shows hit on write throughput comparing to single disk, but RAID10 modes over 4 disks surprises me, showing… is really usable, and how it performs on regular hard drives or SSD disks. The performance drop in RAID settings is unexpected…
