… write about is queries that execute slower in new MySQL 6.0 version. Query is pretty simple SELECT sum(l_extendedprice… NULL, `l_comment` varchar(44) NOT NULL, `l_shipmode` char(10) NOT NULL, PRIMARY KEY (`l_orderkey`,`l_linenumber`), KEY `lineitem…. As you see 1285 rkB/s is pretty small for RAID 10 system we have on this server. This is because of…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… Linux Release | Ubuntu 10.04.2 LTS (lucid) Kernel | 2.6.32-31-server…Schedulers And Queue Size ############################# sda | [deadline] 128 # RAID Controller ############################################ Controller | LSI Logic MegaRAID… 15% — 909 iops unaligned -vs- 1049 aligned. Random write….
Post: RAID vs SSD vs FusionIO
May 1, 2009 By 17 Comments
… for SSD (note it is single device, in comparison to RAID 10 on 8 disks) and FusionIO are impressive, it is worth… price/performance parameter. Here is my very rough calculation: For RAID 10 we use 8 73GB SAS 2.5″ 15K RPM disks… price of IO system, we have RAID 10 – 4.8 TPM / $ SSD – 27 TPM / $ FusionIO – 3.6 TPM / $ Please note that price of…
Post: FusionIO - time for benchmarks
December 8, 2009 By 10 Comments
I posted about FusionIO couple times RAID vs SSD vs FusionIO and Testing FusionIO: strict_sync is too strict…. The … information here). By that link you can get card for $6,569.99, which gives us ~40$/GB. There we should… we can see only 130MB/sec max throughput. Write bandwidth vs filesize: So there I tested how filesize (fill factor) affects…
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
…speaking about 300 microseconds vs 5000 microseconds and DRBD overhead can be well below 10% The problem is…per transaction commit, or could be more than 6 depending on how Filesystem does it job. …BBU (Battery backed up unit) on your hardware RAID card or something which has same effect, especially…
