… time we played with performance trying to align XtraDB performance with MySQL 5.4 ® and also port all performance fixes to 5.0… far. 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: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
… the 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: 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…-requests=0 –max-time=60 –mysql-db=test run On Dell R900 with CentOS 5.2 and ext3 filesystem we get 1060…
Post: 128GB or RAM finally got cheap
August 4, 2008 By 14 Comments
… “Elite” servers on Dell web site but looking at customers system today I went to check Dell Poweredge R900. This monster takes up… 128GB of RAM for about $16000. This means talking to Dell Sales rep it can purchases within $15000. This may sounds… designed to have “working set to fit in memory” to perform well and such systems can avoid good consolidation factor for…
Post: read_ahead (disabled) as steroid
May 12, 2009 By 4 Comments
…). Basically we took improvements from 5.4 and backported ones performance related to XtraDB. Here are results for tpcc-like workload… http://spreadsheets.google.com/ccc?key=rxUEhM2dqbX0uAfq9j6WQ_w ). Box Dell PowerEdge R900 (Does Dell have referral program ? ), with RAID10 (8 disks) on ext3…
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….) For 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
… SSD drive into our lab. I attached it to our Dell PowerEdge R900. The story making it running is worth separate mentioning… 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
… with 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… full results, scripts and settings are on Benchmarks Wiki. * Hardware: Dell PowerEdge R900 * IO subsystems * RAID10: 8 disks SAS 2.5″ 15K… 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
… ( which gives around 90GB of data + indexes) on my workhourse Dell PowerEdge R900 ( details about box ). On storage configuration: FusionIO 160GB SLC… utilization. Disk throughput: CPU (user) usage: Even with improvements, XtraDB performs less 150MB/s in disk writes (from benchmarks we saw…
