EmergencyEMERGENCY? Get 24/7 Help Now!

Easy query metrics with MySQL Performance Schema

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

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

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

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

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.