EmergencyEMERGENCY? Get 24/7 Help Now!

Easy query metrics with MySQL Performance Schema

 | March 12, 2015 |  Posted In: MySQL, Percona Cloud Tools, Percona Server for MySQL

The MySQL Performance Schema exposes so much data that it’s not trivial to learn, configure, and use. With recently released Percona Agent 1.0.11 you can get query metrics – like min, max, and average query execution time – with a few clicks: Click “Apply” and about two minutes later you’ll have query metrics from Performance Schema, collected and […]

Read More

Faster fingerprints and Go packages for MySQL

 | February 2, 2015 |  Posted In: MySQL, Percona Cloud Tools

I’m happy to announce Go packages for MySQL. Particularly exciting is a new query fingerprint function which is very fast and efficient, but I’ll talk about that later. First, go-mysql is currently three simple Go packages for parsing and aggregating MySQL slow logs. If you’ve been following Percona development, you’ve no doubt heard of Percona Cloud Tools (PCT), a […]

Read More

Managing data using open source technologies? Learn what’s hot in 2015!

 | January 8, 2015 |  Posted In: MySQL, MySQL DBaaS, OpenStack, Percona Cloud Tools, Technical Webinars

Whether you’re looking at the overall MySQL ecosystem or the all-data management landscape, the choice of technologies has never been larger than it is in 2015. Having so many options is great but it also can be very hard to make a selection. I’m going to help narrow the list next week during a Webinar […]

Read More

How small changes impact complex systems – MySQL example

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

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

Innodb transaction history often hides dangerous ‘debt’

 | October 17, 2014 |  Posted In: MySQL, Percona Cloud Tools, Percona Server for MySQL

In many write-intensive workloads Innodb/XtraDB storage engines you may see hidden and dangerous “debt” being accumulated – unpurged transaction “history” which if not kept in check over time will cause serve performance regression or will take all free space and cause an outage. Let’s talk about where it comes from and what can you do […]

Read More

Galera data on Percona Cloud Tools (and other MySQL monitoring tools)

 | August 29, 2014 |  Posted In: MySQL, Percona Cloud Tools, Percona MySQL Support, Percona XtraDB Cluster, XtraDB Cluster

I was talking with a Percona Support customer earlier this week who was looking for Galera data on Percona Cloud Tools. (Percona Cloud Tools, now in free beta, is a hosted service providing access to query performance insights for all MySQL uses.) The customer mentioned they were already keeping track of some Galera stats on Cacti, and […]

Read More

OpenStack Trove Day 2014 Recap: MySQL and DBaaS

 | August 28, 2014 |  Posted In: MySQL, OpenStack, Percona Backup Service, Percona Cloud Tools

I just returned from a week in Cambridge, Massachusetts where I was attending the OpenStack Trove Day and the Trove mid-cycle meetup, both sponsored by the great folks at Tesora. I am relatively new to the OpenStack and Trove arenas so this was a fantastic opportunity for me to learn more about the communities, the […]

Read More