June 19, 2013

Post: MySQL 5.5.8 and Percona Server: being adaptive

….) For this post, I made tpcc-runs on our Dell PowerEdge R900 box, using RAID10 over 8 disks and a FusionIO… flushing neighborhoods feature was created as an optimization for hard drives, since InnoDB tries to combine writing as many pages as…

Post: FlashCache: tpcc workload

… with 1000 Warehouses ( that gives 100GB of data) on Dell PowerEdge R900 with 32GB of RAM, 22GB allocated for buffer pool… did pretty bad test – just turned off power on SSD drive in the middle of tpcc-mysql run, just SSD power…

Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage

…gives around 90GB of data + indexes) on my workhourse Dell PowerEdge R900 ( details about box ). On storage configuration: FusionIO 160GB SLC…tablespace I used partition on regular RAID10 with regular hard drives, here I followed Yoshinori Matsunobu’s recommendations http://yoshinorimatsunobu….

Post: SSD, XFS, LVM, fsync, write cache, barrier and lost transactions

… to get Intel X25-E SSD drive into our lab. I attached it to our Dell PowerEdge R900. The story making it…

Post: RAID System performance surprises

… to overheating). This is also almost the case with Hard Drives – there are possible performance differences based on where data is… PERC5 (LSI MegaRaid) – Pretty typical controller from Dell installed on PowerEdge 1950, 2950 etc you should be aware of couple of…

Comment: How reliable RAID really is

… found RAID5 to perform _faster_ or close to RAID10 on PowerEdge 2850 for example. You can see benchmark data in “Performance… so you do not have to reclone them whenever any drive fails also this means you can promote slave to the…