Few days ago I have run very similar test: sysbench OLTP RW benchmark on spinning (non-SS) disks. The file systems … I recreated the benchmark fs as xfs and repeated the sysbench run. Up to 8 threads xfs was few percent faster…
Comment: Percona XtraDB Cluster Feature 1: High Availability
January 18, 2012 By 20 Comments
…-only, it also isn’t write-only. For instance in sysbench oltp, all transactions have 75% selects and 25% writes. You could… offloads the selects of your mixed workload. So in the sysbench case you can easily scale 4x with this method (by…
Post: Should I buy a Fast SSD or more memory?
April 8, 2010 By 10 Comments
… if this is the case: Percona-XtraDB-9.1 release Sysbench OLTP workload with 80 million rows (about 18GB worth of data… note: This graph and these results are valid only for sysbench uniform. In your particular workload the points B and C…
Post: MySQL versions shootout
October 10, 2011 By 6 Comments
… not. I took our Cisco UCS C250 and ran simple sysbench oltp read-write all data fits into memory workload. Versions in…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
… DB Instance. I used default settings for RDS, and default sysbench oltp settings. The default settings for RDS are pretty reasonable, although…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
… size is lesser question. I also assume this is default sysbench oltp settings which uses skewed distribution, so we’re not speaking…
Post: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
… the peak throughput as my target configuration. The benchmark was sysbench oltp complex, with 400 million rows (88GB of data and indexes…
Comment: Should I buy a Fast SSD or more memory?
December 8, 2010 By 10 Comments
Does sysbench oltp provide the whole dataset of the same temperature (no hot/…
Post: Percona Server scalability on multi-cores server
September 29, 2010 By 14 Comments
… Percona Server 5.1.47-11.2Â and ran the sysbench oltp read-only and read-write benchmarks using from 1 to…
Post: Query Response time histogram - new feature in Percona Server
July 11, 2010 By 11 Comments
… affects response time. There are histograms and pie charts for sysbench oltp runs for 1, 32 and 128 concurrent threads 1 thread…
