… to Turbocharge Your MySQL Performance Using Flash Storage” (From Virident side: Shridar Subramanian and Shirish Jamthe). Running MySQL on SSD… MySQL environments Evaluation criteria and techniques for selecting the suitable flash-storage technology for the relevant MySQL workloads Price/performance …
Post: Webinar "How to Turbocharge Your MySQL Performance Using Flash Storage"
March 13, 2012 By 5 Comments
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… tbl WHERE key_column=x This query will roughly be evaluated in following steps, without MRR: SELECT key_column, pk_column…. MySQL Status Counters These status counters were captured when performing the benchmark on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w…
Comment: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… 2009, so this is really 3 years of testing and evaluations for me. At this point I believe it has good quality. We used following tools for evaluations: randgen (lp:randgen), kewpie (lp:kewpie) and for stressing and performance: sysbench and tpcc-mysql.
Comment: Introducing new type of benchmark
February 26, 2012 By 16 Comments
… cases – I know I only use sysbench to evaluate hardware to gage what I reckon we can …mirrors. You dont know your 9x percentile response time performance until you use it against your work load …a sharded datastore. A possible solution is to use mysql proxy and an alterate server with a snapshotted …
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… overview of these two approaches to hosting MySQL in the Amazon cloud. In general, MySQL performance overall on EC2 and EBS isn’t… contention. The performance improvements I got with Percona Server were similar to the performance improvements I saw versus stock MySQL 5.1. This… a plug into this post’s comments. I haven’t evaluated their technology, so I can’t comment on it. I…
Post: Clustrix benchmarks under tpcc-mysql workload
October 26, 2011 By 9 Comments
… time on the evaluation of Clustrix product, and this is the report on performance characteristics of Clustrix under tpcc-mysql workload. I tested… comparison. Standard dislaimer: this post is part of paid evaluation we perform for Clustrix, but is totally independent and fully reflects our…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first edition). From… at this point, it looks like MySQL is probably a good place to look for performance problems. Everything I’ve done up… entirely (we may suggest caching, or tell the customer to evaluate Sphinx, or something like that.) In the common case, though…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… for others it is many month projects. Why is that ? Performing MySQL upgrade two things should normally worry you. It is Regressions… with different result and performance regressions when performance (in a broad sense) is negatively affected. In general even minor MySQL version upgrade can… years is change of TIMESTAMP output format in MySQL 4.1 or changing JOIN evaluation in 5.0 (which could both cause…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
… Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on standard EC2 servers with EBS volumes (see SSD versus EBS death match), and one of them wanted to evaluate… workload is not very revealing. To understand the sustained write performance of an RDS instance, we need a multi-threaded long…
Post: Finding your MySQL High-Availability solution - The definitions
October 9, 2009 By 10 Comments
… MySQL Performance Blog, I joined Percona at the beginning September, I chose to cover the various high-availability (HA) options available for MySQL… unresponsive according to the defined performance threshold. In many cases, people don’t define a performance threshold, it is basically the… a subject of debate and it is something hard to evaluate since, most of the time, the samples are small and…
