]]> ]]>

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.

MySQL Security

by David Busby, Ernest Souhrada, Peter Zaitsev. On October 9th, 2014

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

MySQL Replication

by Aurimas Mikalauskas, Muhammad Irfan, Stephane Combaudon. On September 22nd, 2014

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 the data synced with the master copy. This Percona eBook, "MySQL Replication," covers the following: "How does MySQL Replication really work?" "How to identify and cure MySQL replication slave lag" "GTIDs in MySQL 5.6: New replication protocol; new ways to break replication”     - Read More

MySQL Fabric - Part 1

by Fernando Ipar, Martin Arrieta. On July 14th, 2014

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. The eBook concludes with a discussion with MySQL Fabric lead developer Mats Kindahl, senior principal software developer in MySQL at Oracle. - Read More

MySQL Performance Schema

by Alexander Rubin, Vadim Tkachenko. On June 5th, 2014

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; Performance Schema overhead; and Performance Schema tables stats. - Read More

MySQL Query Optimization

by Muhammad Irfan, Vadim Tkachenko, Peter Zaitsev. On May 22nd, 2014

MySQL query optimization should not be based on guesses, but exact measurements. A proper measurement of these units is the first important task in MySQL performance optimization. This Percona eBook explains how to do this with Percona Cloud Tools. We'll also examine the best way to analyze WordPress MySQL queries with "Query Analytics." We'll also share other tools and tips for analyzing MySQL's slow query log; and finally we'll compare PERFORMANCE_SCHEMA vs Slow Query Log. - Read More

The power of MySQL's GROUP_CONCAT

by Vadim Tkachenko. On May 7th, 2014

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 working with Support customers I recommend it when you have aggregation of many-to-many info. It makes the view simpler and more beautiful and it doesn’t need much effort to make it work. In the Percona eBook, "The power of MySQL’s GROUP_CONCAT,” authors Vadim Tkachenko and Michael Rikmas provide real-world examples of GROUP_CONCAT in action. - Read More

How to find bugs in MySQL

by Roel Van de Paar. On April 25th, 2014

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 bug hunter worldwide), or just want to prove you can outsmart some of the world’s best programmers, finding bugs in MySQL is a skill not reserved anymore to top QA engineers armed with a loads of scripts, expensive flash storage and top-range server hardware. As Percona's director of development services, Roel leads Percona's Development Services group, which includes Percona's QA, documentation, software packaging, build/release management and performance testing teams. - Read More

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 Stephane 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 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 Nickolay Ihalainen, Fernando Laudares Camargos, Muhammad Irfan, Michael Benshoof. 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 Roel Van de Paar, Nilnandan Joshi. 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
Sales
Europe
+44-208-133-0309 (UK)
0-800-051-8984 (UK Toll Free)
0-800-181-0665 (GER Toll Free)
More Numbers
Training (855) 55TRAIN or
(925) 271-5054

 

Share This
]]>