Since we’re very busy working on Percona Toolkit 2.2 and other projects, I thought 2.1.8 (the current latest Percona Toolkit release) would be the last release in that series, but it introduced a new bug in pt-heartbeat (despite all the tool’s tests) that I’d like to fix. A single bug fix is probably underkill for a [...]
Hidden columns of query_review_history table
August 28, 2012 By Leave a Comment
You can use pt-query-digest to process a MySQL slow query log and store historical values for review trend analysis into query_review_history table. According to its official documentation you can populate many columns in that table but there are other important ones such as ‘user’, ‘host’, ‘db’ which are not included by default. I will explain [...]
Dot-Org Pavilion at the Percona Live MySQL Conference
February 8, 2012 By Leave a Comment
This is a cross-post from my personal blog. Are you involved with an open-source project that’s interesting to MySQL users, such as Nginx, PHPMyAdmin, Drupal, Jenkins, PHP, and so on? Percona just published the application form for dot-org groups to have a free expo hall booth in the Percona Live MySQL Conference in April. Please [...]
Percona Toolkit 1.0.1 released
September 7, 2011 By 13 Comments
Daniel and I and the Percona release engineering team are proud to announce version 1.0.1 of Percona Toolkit. This toolkit is Percona’s suite of DBA and sysadmin productivity tools for MySQL. It is the successor to the popular Maatkit and Aspersa toolkits. Percona Toolkit is available for immediate download at percona.com/downloads/percona-toolkit/. Helpful links: Reference Manual [...]
Announcing Percona Live MySQL Conference and Expo 2012
August 9, 2011 By 11 Comments
We’re thrilled to announce that we have signed a contract with the Hyatt Regency Santa Clara and the Santa Clara Convention Center, to host a Percona Live MySQL Conference and Expo on April 10-12, 2012. This event is part of our Percona Live series of conferences, but it’s not just another event in the series. [...]
Aspersa tools bit.ly download shortcuts
April 17, 2011 By 4 Comments
I use Aspersa tools a lot and I find myself going to the website just to download one of the tools all the time. I love I can download maatkit with a simple wget maatkit.org/get/tool command so I made bit.ly shortcuts for all of the current aspersa tools. Here’s the full list with my favorite [...]
Percona Announces Drizzle Support
April 15, 2011 By 2 Comments
As you might have heard, at the MySQL Conference this earlier this week we announced our launch of Drizzle support services. We added Drizzle to the list of database servers that is covered under our MySQL support contracts. This includes MySQL, Percona Server, Amazon RDS, MariaDB, and the XtraBackup and Maatkit tools.
Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
I don’t use many tools in my consulting practice but for the ones I do, I try to know them as best as I can. I’ve been using mk-query-digest for almost as long as it exists but it continues to surprise me in ways I couldn’t imagine it would. This time I’d like to share [...]
Maatkit’s mk-query-digest filters
March 28, 2011 By Leave a Comment
Have you ever seen BIG weird numbers in mk-query-digest report that just seem wrong? I have! Here’s one report I got today:
Logging MySQL queries from the client instead of the server
February 2, 2011 By 2 Comments
The “slow query log” is the single most valuable way to examine query execution on your MySQL server. Queries are logged with timing information, and in the case of Percona Server, a great deal of additional performance and other diagnostic information. But the execution time recorded in the log is the time the query took [...]
