Buy Percona ServicesBuy Now!

Percona eBooks

Percona eBooks are collections of the most helpful and insightful posts from the Percona Performance Blog by our technology experts from the Percona Support, Consulting, and Managed Services teams. They cover topics such as DBA best practices related to database performance and troubleshooting, as well MySQL, NoSQL, cloud and polyglot deployments. All Percona eBooks are available for free download.



  Jun 5, 2014   Alexander Rubin, Vadim Tkachenko

MySQL Performance Schema is a tool for monitoring database execution with minimal impact on server performance. In the Percona eBook, "MySQL Performance Schema," the authors address MySQL 5.6 Performance Schema in multi-tenant environments;...

  May 7, 2014   Vadim Tkachenko

MySQL has useful extension to the GROUP BY operation: function GROUP_CONCAT:

GROUP_CONCAT(expr) – This function returns a string result with the concatenated non-NULL values from a group.

When is GROUP_CONCAT useful? Usually while...

  Apr 25, 2014   Roel Van de Paar

For Roel Van de Paar, finding bugs in MySQL is not only fun, it’s also something he's been doing the last four years of his professional life.

Whether you want to become the next Shane Bester (who is generally considered the most skilled MySQL...

  Mar 26, 2014   Ernest Souhrada

In "InnoDB Full-text Search in MySQL 5.6," senior consultant Ernie Souhrada opens with a quick overview of Full-text Search (FTS) in InnoDB and some observations that he's made while getting it configured. In Chapter 2, he compares query results...

  Mar 20, 2014   Stephane Combaudon, Vadim Tkachenko

InnoDB is the default transactional storage engine for MySQL and the most important and broadly useful engine overall. It was designed for processing many short-lived transactions that usually complete rather than...

  Mar 11, 2014   Bill Karwin, Peter Zaitsev, Peter Boros

The Percona eBook, "MySQL Logs," is comprised of 4 chapters. The first, by Percona Senior Knowledge Manager Bill Karwin, focuses on Percona Toolkit's pt-query-digest, a tool indispensable for identifying your top...

  Mar 10, 2014   Nickolay Ihalainen, Muhammad Irfan, Fernando Laudares Camargos, Michael Benshoof

In this eBook we'll begin with a review of InnoDB performance optimization basics and continue with the revelation of one common pitfall you'll want to avoid when working with InnoDB file formats. Next we'll show you how to move the InnoDB log...

  Feb 24, 2014   Roel Van de Paar, Nilnandan Joshi

This Percona eBook features MySQL server memory usage. The first chapter offers popular troubleshooting tips from Percona support engineer Nilnandan Joshi based on his many customer interactions. Chapters Two and Three, by Alexey Stroganov, focus on...

  Jan 27, 2014   Jervin Real, Jay Janssen

In this issue Percona XtraDB Cluster 5.6 users will learn how to find a good IST donor, using keepalived with reader and writer VIPs, and also get introduced to new wsrep_provider_options.

  Jan 24, 2014   Jay Janssen, Jervin Real, Peter Zaitsev

This issue offers a peak at some of the useful MySQL 5.6 features that you get for free in Percona XtraDB Cluster, explains how to migrate to Percona XtraDB Cluster and then walks users through setting up a simple cluster. We'll also examine Galera...

Visit Percona Store