… time we played with performance trying to align XtraDB performance with MySQL 5.4 ® and also port all performance fixes to 5.0…. As usually for benchmarks I used our workhorse Dell PowerEdge R900 with 16 cores and 32GB of RAM and RAID 10… will be released with fast recovery patch – XtraDB has additional performance fixes i.e. extra UNDO and ROLLBACK segments (full list…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
…,
Post: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
… scope of the benchmark to include data on our Dell r900 with traditional hard drives in RAID10, and a server in… long-term benchmark and see how the instance performed over time. Can it sustain performance over a several-day period of intense… ran. While running the benchmarks, I gathered many gigabytes of performance and diagnostic metrics, and ensuring that it is ready to…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
… have the best peak performance, but also stable and predictable performance. I refer you to Peter’s post, Performance Optimization and Six Sigma… this post, I made tpcc-runs on our Dell PowerEdge R900 box, using RAID10 over 8 disks and a FusionIO 320GB… the buffer pool scalability issue. Let’s see how MySQL performance changes for the last workload if we set innodb_buffer…
Post: SSD, XFS, LVM, fsync, write cache, barrier and lost transactions
March 2, 2009 By 32 Comments
… into our lab. I attached it to our Dell PowerEdge R900. The story making it running is worth separate mentioning – along… card with enabled write-cache (which is default and most performance mode) does not warranty storing all InnoDB transactions on permanent… have durability we need to disable write cache ( with following performance penalty, how much we need to test yet) 3. Possible…
Post: FlashCache: tpcc workload
May 25, 2010 By 18 Comments
… 1000 Warehouses ( that gives 100GB of data) on Dell PowerEdge R900 with 32GB of RAM, 22GB allocated for buffer pool and… rate in final place is limited by RAID. So all performance benefits will come from read hits The full report and… CFQ to Deadline. Seriously, it makes so much damage on performance on servers with IO intensive workloads, so it should be…
Post: FlashCache: first experiments
May 10, 2010 By 18 Comments
…, and since that I run couple benchmarks, to see what performance benefits we can expect. For initial tries I took sysbench…, scripts and settings are on Benchmarks Wiki. * Hardware: Dell PowerEdge R900 * IO subsystems * RAID10: 8 disks SAS 2.5″ 15K ( main… X25-M, probably X25-M in second generation has better performance characteristics ( I will post sysbench fileio benchmarks). Also what is…
Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 13 Comments
… around 90GB of data + indexes) on my workhourse Dell PowerEdge R900 ( details about box ). On storage configuration: FusionIO 160GB SLC and… utilization. Disk throughput: CPU (user) usage: Even with improvements, XtraDB performs less 150MB/s in disk writes (from benchmarks we saw… more can be done. Still you can have very impressive performance improvement in IO-intensive or IO-bound workloads. You may…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
… disk space than MyISAM. For tests I used Dell PowerEdge R900, with RAID 10 on 8 disks (2.5″ SAS disks… at a given incoming data rate, enabling much higher query performance. Beside iiBench we run benchmarks of SELECT queries again one… can be from simple apache logs put into mysql, application performance logs to more complex log like clicks, user movements and…
Post: Beware: ext3 and sync-binlog do not play well together
January 21, 2009 By 19 Comments
… our customers reported strange problem with MySQL having extremely poor performance when sync-binlog=1 is enabled, even though the system with RAID and BBU were expected to have much better performance. The problem could be repeated with SysBench as follows: ./sysbench…=0 –max-time=60 –mysql-db=test run On Dell R900 with CentOS 5.2 and ext3 filesystem we get 1060…
