Download section three of our newest eBook, “Practical MySQL Performance Optimization,” by Percona CEO Peter Zaitsev and Principal Consultant Alexander Rubin. The content in this eBook will enable you to troubleshoot and optimize your own database...
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.
Mar 31, 2016
Alexander Rubin, Peter Zaitsev
Download section two of our newest eBook, “Practical MySQL Performance Optimization,” by Percona CEO Peter Zaitsev and Principal Consultant Alexander Rubin. The content in this eBook will enable you to troubleshoot and optimize your own database...
Nov 17, 2015
Alexander Rubin, Peter Zaitsev
A hands-on, business-case-driven guide to understanding MySQL query parameter tuning and database performance optimization. With the increasing importance of applications and networks in both business and personal interconnections, performance has...
Dec 17, 2014
Aurimas Mikalauskas, Stephane Combaudon, Alexander Rubin
The Percona eBook "MySQL Performance Tuning" (vol. 1) walks DBAs through the top 10 MySQL settings to tune after installation of your server. Subsequent chapters introduce techniques for advanced MySQL query tuning, share Linux performance tuning tips...
Nov 14, 2014
Tushar Katarki, Jervin Real, Vadim Tkachenko, Peter Zaitsev
In this Percona eBook, the first in a series on MySQL backups, Jervin Real elaborates on encrypted and incremental MySQL backups with Percona XtraBackup; Tushar Katarki details backup and restore of MySQL to OpenStack Swift; Vadim Tkachenko offers...
Nov 4, 2014
Jervin Real
In this Percona eBook, the first in a series on MySQL High Availability, senior MySQL consultant Jervin Real introduces mysqlnd_ms with a simple HA solution using asynchronous MySQL replication. He then demonstrates how to leverage an all-primary...
Oct 21, 2014
Dimitri Vanoverbeke, Stephane Combaudon, Tushar Katarki, Tim Sharp, Terry Erisman
OpenStack, the fastest-growing open cloud platform, is a highly scalable operating system for public and private clouds and is winning the support of service providers and organizations of all sizes. Trove is the "Database as a Service" (DBaaS) for...
Oct 9, 2014
David Busby, Ernest Souhrada, Peter Zaitsev
MySQL security is more important today than ever. In this Percona eBook, we'll examine MySQL 5.6 security vs ease of use, why it's important to review your current database security measures - along with real-world best practices and advice.
Sep 22, 2014
Aurimas Mikalauskas, Stephane Combaudon, Muhammad Irfan
MySQL's built-in replication is the foundation for building large, high-performance applications on top of MySQL using the "scale-out" architecture. MySQL replication enables DBAs to configure one or more server as replicas of another server - keeping...
Jul 14, 2014
Fernando Ipar, Martin Arrieta
MySQL Fabric is an integrated framework for managing farms of MySQL servers with support for both high-availability and sharding. This Percona eBook examines using it to manage MySQL server farms and also looks at High Availability with MySQL Fabric....
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...
