by Alexey Zhebel | May 7, 2015 | MySQL, Percona Software
For those PCT users who forget to regularly check query performance, you can now get server query reports delivered to your email daily or weekly. The report contains a digest of the most critical performance information related to a particular MySQL instance,...
by Daniel Nichter | Mar 12, 2015 | MySQL, Percona Software
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...
by Daniel Nichter | Feb 2, 2015 | MySQL, Percona Software
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...
by Michael Coburn | Jan 23, 2015 | MySQL, Percona Software
For months when speaking with customers I have been positioning Percona Cloud Tools (PCT) as a valuable tool for the DBA/Developer/SysAdmin but only recently have I truly been able to harness the data and make a technical recommendation to a customer that I feel would...
by Peter Zaitsev | Jan 8, 2015 | Insight for DBAs, MySQL, Percona Software, 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...
by Jay Janssen | Dec 5, 2014 | Benchmarks, MySQL, Percona Software
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...
by Andrew Moore | Dec 2, 2014 | Insight for DBAs, MySQL, Percona Services
This post is a follow-up to my November 19 webinar, “Tips from the Trenches: A Guide to Preventing Downtime for the Over-Extended DBA,” during which I described some of the most common reasons DBAs experience avoidable downtime. The session was aimed at...
by Peter Zaitsev | Oct 17, 2014 | MySQL, Percona Software
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...
by Fernando Laudares Camargos | Aug 29, 2014 | MySQL, Percona Services, Percona Software
I was talking with a Percona Support customer earlier this week who was looking for Galera data on Percona Cloud Tools. (Percona Cloud Tools is a hosted service providing access to query performance insights for all MySQL uses.) The customer mentioned they were...
by Tim Sharp | Aug 25, 2014 | Insight for DBAs, MySQL, Percona Software
In a previous post, my colleague mission statement declares, the Trove project seeks to provide a scalable and reliable cloud database service providing functionality for both relational and non-relational database engines. With the current release of Icehouse, the...
by Daniel Nichter | Aug 19, 2014 | Cloud, Insight for DBAs, MySQL, Percona Software
It’s been three months since we announced anything for Percona Cloud Tools, not because we’ve been idle but because we’ve been so busy the time flew by! Here’s the TL;DR to pique your interest: EXPLAIN queries in real-time through the web app Query Analytics for...
by Matt Griffin | Aug 1, 2014 | Insight for DBAs, MySQL, Percona Services, Percona Software
MySQL plays a critical role in OpenStack. It serves as the host database supporting most components such as Nova, Glance, and Keystone and is the most mature guest database in Trove. Many OpenStack operators use Percona open source software including the MySQL drop-in...
by Vadim Tkachenko | Jul 22, 2014 | Insight for DBAs, MySQL, Percona Software
We designed Percona Cloud Tools (both hardware and software setup) to handle a very high-intensive MySQL write workload. For example, we already observe inserts of 1bln+ datapoints per day. So I wanted to share what kind of hardware we use to achieve this result. Let...
by Vadim Tkachenko | Jul 9, 2014 | Insight for DBAs, MySQL, Percona Software
We are using Percona Server + TokuDB engine extensively in Percona Cloud Tools and getting real usage operational experience with this engine. So I want to share some findings we came across, in hope it may help someone in their work with TokuDB. So, one problem I...
by Vadim Tkachenko | Jun 18, 2014 | Insight for DBAs, MySQL, Percona Software, Webinars
We recently released a new version of Percona Cloud Tools with MySQL monitoring capabilities. Join me June 25 and learn the details about all of the great new features inside Percona Cloud Tools – which is now free in beta. The webinar is titled...
by Alexander Rubin | Jun 11, 2014 | Insight for DBAs, MySQL, Percona Software
When you make a change to your MySQL configuration in production it would be great to know the impact (a “before and after” type of picture). Some changes are obvious. For many variables proper values can be determined beforehand, i.e....
by Vadim Tkachenko | Jun 4, 2014 | Insight for Developers, MySQL, Percona Software, Webinars
We recently open-sourced our percona-agent and if you check out the source code, you’ll find that it is written in the Go programming language (aka Golang). For those not up to speed, the percona-agent is a real-time client-side agent for Percona Cloud Tools....
by Peter Zaitsev | Jun 3, 2014 | Benchmarks, Insight for DBAs, MySQL, Percona Software
I’ve been running a benchmark today on my old test box with conventional hard drives (no raid with BBU) and noticed something unusual in the CPU utilization statistics being reported. The benchmark was run like this: sysbench --num-threads=64 --max-requests=0...
by Vadim Tkachenko | May 28, 2014 | Insight for DBAs, MySQL, Percona Software
First, I would like to invite you to my webinar, “this post. Basically our agent allows users to collect ALL MySQL metrics plus important environment’s metrics, like CPU, memory, IO stats. And when I talk all MySQL it is: Metrics from SHOW GLOBAL STATUS (I...
by Daniel Nichter | May 23, 2014 | Insight for DBAs, MySQL, Percona Software
There are many cool, new things happening with Percona Cloud Tools. To avoid “tl;dr” I will highlight only one new feature after a brief, general announcement. The new feature is a 3-minute MySQL monitor. I’ll blog later about other features. The...
