… L2 cache. I made binaries for FlashCache for CentOS 5.4, kernel 2.6.18-164.15, you can download it from… settings are on Benchmarks Wiki. * Hardware: Dell PowerEdge R900 * IO subsystems * RAID10: 8 disks SAS 2.5” 15K ( main storage) * SSD-1: Intel X25-E 32GB ( 1 gen firmware) ( Model Number: SSDSA2SH032G1GN INTEL, Firmware Revision: 045C8621) * SSD-2…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
…, and 5.5x less disk space than MyISAM. For tests I used Dell PowerEdge R900, with RAID 10 on 8 disks (2.5” SAS… see the results that you do in iiBench test ( Graph 2), and the number of inserts/sec is almost linear even… modes – 1. data size is much more then memory and 2. data fits into memory. As you see in IO-bound…
Post: Intel Nehalem vs AMD Opteron shootout in sysbench workload
April 25, 2011 By 41 Comments
… Nehalem (Cisco UCS C250) and second on AMD Opteron (Dell PowerEdge R815), I decided to run some simple sysbench benchmark to… Dell PowerEdge R815 has 48 cores of AMD Opteron 6168. One of biggest difference is that Cisco is running CentOS 5.5 and… oltp ( both read-only and read-write) and MySQL 5.6.2 as it seems most scalable system at the moment. All…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 19 Comments
…: Analyzing Percona’s TPCC-like Workload on MySQL 5.5 sounded doubt that it really makes sense. Here … I have number to show you. I took Dell PowerEdge R900 server with 32GB of RAM and with … ioDrive in this system Fusion-io driver version: 2.2.0 build 82 fct0 Attached as ‘fioa’ (block device…
Post: Benchmarking Galera replication overhead
October 13, 2011 By 12 Comments
… node: Dell PowerEdge R815 Both nodes use Fusion-io cards as storage to minimize IO overhead Software: Percona-Server-5.5.15 regular… further, network communication adds its overhead. We have 10384 for 2 nodes vs 10821 for 1 node. The drop is just… have better result: 11180 for MySQL replication vs 10384 for 2 Galera nodes. However there two things to consider: You see…
Post: Multiple MySQL instances on Fusion-io ioDrive
October 7, 2011 By 6 Comments
… systems. Server hardware: Dell PowerEdge R815 Storage: Fusion-io ioDrive Duo 640GB MLC. Fusion-io driver version: 2.3.1 build 123; Firmware v5.0.7, rev 101971 Software: Percona Server 5.5.15 Client hardware: IBM… MySQL instance, 2400 warehouses (220GB of data), 120GB buffer pool 2 MySQL instances, 1200 warehouses (110GB of data) each, 60GB buffer…
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…-1.0.2 were kind of discouraging, dropping down just after 8 connections, si I decided to test MySQL-5.1.30…_log_buffer_size=8M \ –innodb_flush_log_at_trx_commit=2 \ –innodb_thread_concurrency=16 \ –innodb_file_per_table=1 \ –innodb…
Post: SSD, XFS, LVM, fsync, write cache, barrier and lost transactions
March 2, 2009 By 32 Comments
… drive into our lab. I attached it to our Dell PowerEdge R900. The story making it running is worth separate mentioning… Intel X25-E I got HighPoint 2300 controller and CentOS 5.2 just could not start with two RAID controllers (Perc/6i… innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=256M innodb_thread_concurrency=0 innodb…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
… to avoid decreasing performance.
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
… initial results are quite discouraging. My setup: Dell PowerEdge R900, running Percona-Server-5.1.57-rel12.8 (will be in public… st 1 0 98 0 0 85 13 2 0 0 85 13 2 0 0 85 13 1 0 0 85 13 2 0 0 Compressed tables: —–cpu—— us sy id wa st 2 0 97 1 0 7 0 93 0 0 7 …
