… cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on standard EC2 servers with EBS volumes (see SSD versus EBS… see how the Amazon RDS instance performed at various thread counts on the OLTP benchmark. Update Vadim and Peter have rightly…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
…’t need high concurrency from your MySQL database. When you do, the limitations on the core counts and effective CPU speeds can be… I saw versus stock MySQL 5.1. This leads me to a second unverifiable speculation, that Amazon RDS’s version of MySQL is… there is not a huge performance difference between EC2+EBS+MySQL versus RDS, in most cases, unless you use Percona Server; but…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…name, c_address, c_comment order by revenue desc LIMIT 20; In-memory workload Now let’s see… extra cost for memory access at random locations versus memory access at sequential locations. In fact there …MySQL 5.6 code? As MRR was used in both MySQL 5.6 and MariaDB 5.5. Handler_mrr_rowid_refills counts…
Post: Distributed set processing performance analysis with ICE 3.5.2pl1 at 20 nodes.
May 14, 2011 By Leave a Comment
… performance of 20 m1.large machines cold, versus hot. I did not record the cold … examine the entire data set doing origin/count(distinct destination) combinations across two dimension (origin/dest…processing is handled by a Gearman queue which limits the maximum number of concurrent storage node …
