…, I made tpcc-runs on our Dell PowerEdge R900 box, using RAID10 over 8 disks and a FusionIO 320GB MLC card. First… flushing of neighborhood pages (not available in MySQL 5.5.8). The problem with flushing neighborhood pages is that it makes… is about 2500-2800 NOTPM (~15% difference). MySQL 5.5.8 now has features related to having several buffer pool instancesÂ…
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
…-threads=64 –file-test-mode=rndwr cleanup sysbench v0.4.8: multi-threaded system evaluation benchmark Removing test files… [root@DB10…-threads=64 –file-test-mode=rndwr cleanup sysbench v0.4.8: multi-threaded system evaluation benchmark Removing test files… [root@DB10… wondering which hardware I used for benchmarks – it is Dell PowerEdge 2950 with PERC5 and 6 10K RPM hard drives in…
Post: RAID vs SSD vs FusionIO
May 1, 2009 By 17 Comments
… working horse Dell PowerEdge R900 (btw, to do that I had to switch from CentOS 5.2 to Ubuntu 8.10, as… it is single device, in comparison to RAID 10 on 8 disks) and FusionIO are impressive, it is worth to consider… on price of IO system, we have RAID 10 – 4.8 TPM / $ SSD – 27 TPM / $ FusionIO – 3.6 TPM / $ Please note…
Post: 128GB or RAM finally got cheap
August 4, 2008 By 14 Comments
… looking at customers system today I went to check Dell Poweredge R900. This monster takes up to 4 Quad Core CPUs… web the system with 8*2.5″ hard drives RAID and 2 CPUs (just as we usually configure PowerEdge 2950) with 128GB…
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
… are quite discouraging. My setup: Dell PowerEdge R900, running Percona-Server-5.1.57-rel12.8 (will be in public release soon… tables are create as: ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8, with final size 3.1GB per table. So we have…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 18 Comments
In my post MySQL 5.5.8 and Percona Server: being adaptive I mentioned that I used …. So I have number to show you. I took Dell PowerEdge R900 server with 32GB of RAM and with FusionIO 320GB… tpcc-mysql benchmark with 500W using Percona Server 5.5.8. Here is relevant part of config what I used innodb…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
… stabilize performance and to avoid decreasing performance.
Post: Another scalability fix in XtraDB
January 23, 2009 By 13 Comments
… secondary indexes were forgotten for some time. Now having Dell PowerEdge R900 on board (16CPU cores, 16GB RAM) I have some…_id tinyint(3) unsigned NOT NULL default ’0′, zip varchar(8) NOT NULL default ”, country_id smallint(5) unsigned NOT NULL….0.2 were kind of discouraging, dropping down just after 8 connections, si I decided to test MySQL-5.1.30…
Comment: The perils of uniform hardware and RAID auto-learn cycles
November 17, 2010 By 16 Comments
…-2010 Additional Info : OK – System: PowerEdge R710, SN: xxx, hardware working fine, 1 logical drives, 8 physical drives Anyway, I enjoy the…
Post: HandlerSocket on SSD
November 2, 2010 By 9 Comments
… experiment I used Cisco UCS C250 for server and Dell PowerEdge R900 for client running Perl script (single thread) with HandlerSocket… when table is located on FusionIO and on regular RAID10 ( 8 disks). and row results are on Wiki page As you…
