Baron, For monitoring PERC I use OMSA which has Nagios plugins and it works pretty … ~]# omreport storage battery controller=0 Battery 0 on Controller PERC 5/i Integrated (Embedded) Controller PERC 5/i Integrated (Slot Embedded) ID : 0 Status : Ok Name… hours The utility you mentioned is for PERC4 for PERC5 I have not found one at least a year ago, however…
Comment: Evaluating IO subsystem performance for MySQL Needs
March 6, 2008 By 23 Comments
…) and it will not solve problems that schema design will. I‘m doing around 200K selects (various large ranges, primary key… of IOPS so the WIO went up increasing load – yet I was still able to sustain 22MB a sec of random… with throughput (T). I would love to see the same test with different cache profiles that the PERC-5 offers. Also a test…
Comment: How To Test Your Upgrades - pt-upgrade
July 24, 2012 By 7 Comments
…,u=root,P=3306 h=192.168.1.100,u=perc,p=perc,P=3306 –convert-to-select –limit 100% –temp-database… above pt-upgrade query? I have same set of data in mysql-4.1.x and mysql-5.5.x (tested with pt-table-checksum). My aim is to get a list of errors, queries where I have…
Post: Benchmarks of Intel 320 SSD 600GB
February 22, 2012 By 2 Comments
…) CPU X5650 RAID controller: Perc H800 RAID configuration: RAID 5 over 11 disks + 1 hot spare. RAID 5 is chosen for space purposes… -s size=4096, mount -o nobarrier Benchmark: For the benchmark I took a sysbench uniform oltp rw workload. 256 tables, 50mil… (3TB) to 32 (375GB). As a backend database I use Percona Server 5.5.19. I should mention that on these datasizes, sysbench workload…
Post: Intel SSD 910 vs HDD RAID in tpcc-mysql benchmark
September 11, 2012 By 6 Comments
… Storage: Hardware RAID10 over 8 disks, card: Perc H710, disks: Seagate ST9750420AS 750GB, 2.5“, 7200RPM, 16MB, SATA. Intel SSD 910 (software… Software OS: Ubuntu 12.04.1 MySQL Version: Percona Server 5.5.27-28.1 Benchmark specification Benchmark name: tpcc-mysql Scale…, which in comments to previous post was called cheating. So I ran another round with innodb_flush_log_at_trx_commit…
Post: Linux schedulers in tpcc like benchmark
January 30, 2009 By 19 Comments
… problems. I ran tpcc scripts against XtraDB on our Dell PowerEdge R900 server (16 cores, 8 disks in RAID10, controller Perc/6i with BBU) to compare cfq, deadline, noop and anticipatory (last one just to get number, I did not expect a lot from anticipatory). Here is result (in transactions per minute, more is better): cfq2793.5 noop6586…
Post: SSD, XFS, LVM, fsync, write cache, barrier and lost transactions
March 2, 2009 By 32 Comments
… Intel X25-E I got HighPoint 2300 controller and CentOS 5.2 just could not start with two RAID controllers (Perc/6i and… transactions on permanent storage. I am having some déjà vu here, as Peter was rolling this 5 years ago http://lkml.org/lkml/2004/3/17/188 regarding regular IDE disks, and I did not…
Comment: How many fsync / sec FusionIO can handle
March 4, 2010 By 13 Comments
… 8 2.5” Disk 533GB RAID-10 with BBC on a PERC-6 the price performance still beats out Fusion I/O for the same space requirement. I hope by 2011 for that gap to shrink so I can deploy SSD as the standard for my DB Farm. …
