…caption id=”attachment_13599″ align=”alignright” width=”210″] MySQL 5.6 vs MySQL 5.5 & the Star Schema Benchmark[/caption] So far most of…_time=1000 on MySQL 5.5.30 and testing multiple buffer pools on MySQL 5.5.30. Finally, MySQL 5.6.10 has many additional tuning… memory 4 disk 7200RPM RAID 10 array with 512MB write-back cache Star Schema Benchmark – Scale Factor 1 – Mysql 5.5 vs 5.6 response times…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
…01 AND l_quantity < 24; with execution plain (in 5.1) +—-+————-+———-+——-+—————+—————+———+——+———+————-+ | id | select_type | table | type | possible_keys | … see 1285 rkB/s is pretty small for RAID 10 system we have on this server. This …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…Schedulers And Queue Size ############################# sda | [deadline] 128 # RAID Controller ############################################ Controller | LSI Logic MegaRAID… single-thread performance by 5-10%. Sequential write results were … 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…. Here is my very rough calculation: For RAID 10 we use 8 73GB SAS 2.5” 15K RPM disks, with price 190$ per… simple dividing TPM on price of IO system, we have RAID 10 – 4.8 TPM / $ SSD – 27 TPM / $ FusionIO – 3.6 TPM…
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 14 Comments
…as: mdadm -C /dev/md0 –chunk=256 -n 3 -l 5 /dev/sdj /dev/sdk /dev/sdl RAID10 on 4 …here http://www.mythtv.org/wiki/RAID) mdadm -C /dev/md0 –chunk=256 -n 4 -l 10 -p f2 /dev/sdj /… RAID setup. RAID5 does not show benefits comparing with others, and RAID10,f2 is worse than RAID10. But speaking RAID0 vs…
Comment: Disaster: LVM Performance in Snapshot Mode
February 6, 2009 By 55 Comments
… 9’42” RAID 10 16000 88 178 167 97 2777 1630 9’31” RAID 5 16000 88 232 124 99 330 1359 10’28” RAID 5, LVM… Random Write and Random Read because of their importance: RAID 10 with LVM vs. RAID 10 only: Random Write: For small files (<16k) creation, no... finally chose RAID 5 + LVM for MySQL server. I chose RAID 5 instead of RAID 10 since I didn’t see much gain from RAID 10 in my…
Post: Intel SSD 910 vs HDD RAID in tpcc-mysql benchmark
September 11, 2012 By 6 Comments
… H710, disks: Seagate ST9750420AS 750GB, 2.5“, 7200RPM, 16MB, SATA. Intel SSD 910 (software RAID over 2x200GB devices) Filesystem: ext4 Software OS: Ubuntu 12.04.1 MySQL Version: Percona Server 5.5.27-28.1… Results There is a jitter graph of Throughput taken every 10 sec: I put number of median throughput, so we can…
Post: Pretending to fix broken group commit
February 2, 2009 By 11 Comments
…5Â years ago and still not fixed in MySQLÂ 5.0/5.1 (and most likely will not be …group-commit mode. There are results with this options vs without (results are in transactions per second, more …load). I tested it on Dell PowerEdge R900 with RAID 10 in WriteThrough mode to emulate absence of BBU. With…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
…hard drives to pick reading any block. RAID controller (and even software RAID driver) typically tracks disk head position so…on 1TB hard drive you will have 10 seeks condensed in 1/10 of the full seek distance. I …in both cases we have 2.2 vs 5.5ms which is 2.5 times difference – This is a lot, but…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…RAID controller crashes and all data is lost on that server A disk failed, and RAID… reliable backups? Think about the 10 example outages listed above. Each …Compressed mydumper typically 3x-5x smaller vs compressed xtrabackup Typically we … out to all slaves mysqlbinlog 5.6 Last year Percona IT …
