]]> ]]>

MySQL eBooks

You are here

MySQL eBooks from Percona are collections of the most helpful and insightful posts from the MySQLPerformanceBlog by our MySQL technology experts from the Percona Support, Consulting, Remote DBA, Development, and Training teams. They cover topics such as MySQL server, Percona Server, Percona XtraDB Cluster, MySQL performance, and MySQL troubleshooting. All the eBooks are available for free download.

InnoDB Full Text Search in MySQL 5.6

by Ernest Souhrada. On March 26th, 2014

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 between MyISAM FTS and InnoDB FTS over the same data sets and also provides insight into query performance. He closes by revisiting some of the “quirks” from Chapters 1 and 2 to see if the behavior has changed. - Read More

InnoDB Logs

by Stéphane Combaudon, Vadim Tkachenko. On March 20th, 2014

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 being rolled back. This Percona eBook focuses on one basic area: InnoDB logs. In Chapter 1, Stephane Combaudon shares is experience in MySQL performance audits, listing the top 10 MySQL settings to tune after installation - many of which include InnoDB settings. In Chapter 2 he explains why choosing a good InnoDB log file size is key to InnoDB write performance. Vadim Tkachenko, in Chapter 3, details the expected recovery time from 8G innodb_log_file. - Read More

MySQL Logs

by Aleksandr Kuzminsky, Bill Karwin, Peter Boros, Peter Zaitsev. On March 11th, 2014

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 SQL queries, and analyzing which queries are accounting for your database load. In Chapter 2, "Rotating MySQL slow logs safely," Peter Boros shares key lessons he learned when logging a high volume of queries to the slow log. In Chapter 3, "Impact of logging on MySQL's performance," Aleksandr Kuzminsky uses Percona's microslow patch to reveal logging impacts on performance. Chapter 4, by Percona CEO and founder Peter Zaitsev, answers the question: "How to find MySQL queries worth optimizing?” Visit Percona's eBook Library for more selections (new additions added regularly).  - Read More

InnoDB Performance Optimization

by Fernando Laudares Camargos, Michael Benshoof, Muhammad Irfan, Nickolay Ihalainen. On March 10th, 2014

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 sequence number (LSN) forward (when it is stuck in the future) and finally we'll open the hood of MySQL 5.6 and expose InnoDB Memcached Plugin as a caching layer. - Read More

MySQL Server Memory Usage

by Nilnandan Joshi, Roel Van de Paar. On February 24th, 2014

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 the impact of memory allocators on MySQL performance and the rest of the book looks at profiling MySQL memory usage with Valgrind Massif by Roel Van de Paar. - Read More

Percona XtraDB Cluster 5.6

by Jay Janssen, Jervin Real. On January 27th, 2014

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. - Read More

Percona XtraDB Cluster

by Jay Janssen, Jervin Real, Peter Zaitsev. On January 24th, 2014

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 Flow Control and investigate MySQL replication latency. - Read More

Contact Us 24 Hours A Day
Support Contact us 24×7
Emergency? Contact us for help now!
Sales North America (888) 316-9775 or
(208) 473-2904
+44-208-133-0309 (UK)
0-800-051-8984 (UK)
0-800-181-0665 (GER)
Training (855) 55TRAIN or
(925) 271-5054


Share This