… cpu threads) Cisco UCS C250 (12cores/24 cpu threads) Dell PowerEdge R720 (16 cores/32 cpu threads) All are NUMA boxes… excluded NUMA from the equation. We ran tests on Dell PowerEdge R720 box and varied cpu combinations with taskset. The following… –num-threads=<1..1024> –test=oltp.lua –oltp_tables_count=8 –oltp-table-size=1000000 –rand-init=on –report-interval=1…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… and IO-bound cases. For this test we used a PowerEdge R720 box with a fast PCI-e flash card as… innodb_file_per_table innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 5000 sync_binlog=0 max…_capacity_max = 15000 #Percona only innodb_adaptive_hash_index_partitions=8 innodb_buffer_pool_instances=1 innodb_adaptive_flushing_method=keep…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…, 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: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
… how MySQL 5.6.7 performs Hardware specification Server: Dell PowerEdge R710 CPU: 2x Intel(R) Xeon(R) CPU E5-2660… innodb logfiles. We can see that innodb_buffer_pool_instances=8 makes a big difference on small buffer_pool sizes, while… = 1 innodb_buffer_pool_size = 125G innodb_buffer_pool_instances=8 innodb_log_file_size = 4G innodb_log_files_in_group…
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 19 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.
