EmergencyEMERGENCY? Get 24/7 Help Now!

How small changes impact complex systems – MySQL example

 | December 31, 2014 |  Posted In: Benchmarks, MySQL, Percona Cloud Tools, Percona Server

If you’ve been studying complex systems you know what minor changes might cause consequences of much greater proportions, sometimes causing some effects that are not easily explained at first. I recently ran across a great illustration of such behavior while doing MySQL benchmarks which I thought would be interesting to share. I’m using a very […]

Read More

Streamlined Percona XtraDB Cluster (or anything) testing with Consul and Vagrant

 | December 5, 2014 |  Posted In: Benchmarks, MySQL, Percona Cloud Tools, Percona XtraDB Cluster

Introducing Consul I’m always interested in what Mitchell Hashimoto and Hashicorp are up to, I typically find their projects valuable.  If you’ve heard of Vagrant, you know their work. I recently became interested in a newer project they have called ‘Consul‘.  Consul is a bit hard to describe.  It is (in part): Highly consistent metadata […]

Read More

MySQL benchmarking: Know your baseline variance!

 | November 26, 2014 |  Posted In: Benchmarks, MySQL

Often enough I find MySQL benchmark results where the difference between results is 1% or even less and some conclusions are drawn. Now it is not that 1% is not important – especially when you’re developing the product you should care about those 1% improvements or regressions because they tend to add up. However with […]

Read More

MySQL’s INNODB_METRICS table: How much is the overhead?

 | November 18, 2014 |  Posted In: Benchmarks, InnoDB, MySQL

Starting with MySQL 5.6 there is an INNODB_METRICS table available in INFORMATION_SCHEMA which contains some additional information than provided in the SHOW GLOBAL STATUS output – yet might be more lightweight than PERFORMANCE_SCHEMA. Too bad INNODB_METRICS was designed during the Oracle-Sun split under MySQL leadership and so it covers only InnoDB counters. I think this […]

Read More

RDS for Aurora unveiled at AWS re:Invent

 | November 14, 2014 |  Posted In: Benchmarks, Insight for DBAs, Insight for Developers, MySQL, Percona Server

One of the big announcements at the Amazon Web Services re:Invent 2014 conference this week was the unveiling of Aurora. The result of years of internal work, Aurora, currently in preview, is a MySQL 5.6-compatible option that “combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases” on […]

Read More

Using sysbench 0.5 for performing MySQL benchmarks

 | September 2, 2014 |  Posted In: Benchmarks, Insight for DBAs, MySQL, OpenStack, Percona MySQL Consulting, Percona MySQL Support

Given the recent excitement & interest around OpenStack I wanted to make sure I was ready to conduct appropriate evaluations of system performance.  I generally turn to sysbench since it comes with a variety of different tests (accessed via –test= option interface), including: fileio – File I/O test cpu – CPU performance test memory – […]

Read More

A closer look at the MySQL ibdata1 disk space issue and big tables

 | August 21, 2014 |  Posted In: Benchmarks, InnoDB, Insight for DBAs, MySQL, Percona MySQL Support

A recurring and very common customer issue seen here at the Percona Support team involves how to make the ibdata1 file “shrink” within MySQL. I can only imagine there’s a degree of regret by some of the InnoDB architects on their design decisions regarding disk-space management by the shared tablespace* because this has been a big […]

Read More