InnoDB is one of the most commonly used database engines in the world today. Knowing how to effectively manage this technology can make or break a MySQL database environment. The Instant InnoDB addresses everything you need to know for the installation, configuration, load testing, analysis, and long term support of an InnoDB-based database environment.
Explore in-depth features and performance tuning options for running the InnoDB database engine in production environments. The Instant InnoDB contains detailed discussions for a range of simple to advanced topics. If you've ever wanted to learn more about InnoDB but didn't want to sit down with a dauntingly large or stale read then this reference guide is the answer to your queries. You will learn about common InnoDB monitoring and reporting applications as well as learn how to measure, analyze, and load test InnoDB workloads before going into production. This book also offers an in-depth explanation of configuration and tuning parameters in addition to troubleshooting and performance analysis methodologies.
Chapter 1, Getting Started with InnoDB, provides a quick overview of the core terminology and initial setup of the testing environment.
Chapter 2, Basic Configuration Parameters, will teach you about the most common settings and prerequisites for performance tuning.
Chapter 3, Advanced Configuration Parameters, covers advanced settings that can make or break a high performance installation of InnoDB.
Chapter 4, Load Testing InnoDB for Performance, explains all about general purpose InnoDB load testing as well as common methods for simulating production workloads.
Chapter 5, Maintenance and Monitoring, covers the important sections of InnoDB to monitor, tools to use, and processes that adhere to industry best practices.
Chapter 6, Troubleshooting InnoDB, explains all about identifying and solving common production issues that may arise.
Chapter 7, References and Links, can be referred to for informative data for further reading.
To run the examples in the book, the following software will be required:
Linux server:
Linux OS running Version 2.6.x or 3.x kernel
MySQL applications:
MySQL Server 5.5 or later
MySQL Client 14.14 Distrib 5.5.x or later
The Instant InnoDB features content for all skill levels of MySQL administrators, developers, and engineers. Presented in an easy to read format, you will find answers to common questions and solutions to common problems, that will help you achieve higher performance and greater stability in your InnoDB based databases. If you've ever wondered how InnoDB manages memory buffers, how it can be used to scale from hundreds to thousands of queries per second, or how to monitor advanced analytics for an in-depth look at the health and performance during production use, then the Instant InnoDB is the book for which you have been searching.
In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.
Code words in text are shown as follows: "InnoDB uses the fsync() call to flush data and logs to disk."
Any command-line input or output is written as follows:
mysql> create database test; use test; Query OK, 1 row affected (0.00 sec) Database changed mysql> CREATE TABLE `test` ( -> `id` int(8) NOT NULL auto_increment, -> `data` varchar(255), -> `date` datetime, -> PRIMARY KEY (`id`), -> INDEX `date_ix` (`date`) -> ) ENGINE=InnoDB; Query OK, 0 rows affected (0.06 sec)
New terms and important words are shown in bold.
Feedback from our readers is always welcome. Let us know what you think about this book—what you liked or may have disliked. Reader feedback is important for us to develop titles that you really get the most out of.
To send us general feedback, simply send an e-mail to <[email protected]>, and mention the book title via the subject of your message.
If there is a topic that you have expertise in and you are interested in either writing or contributing to a book, see our author guide on www.packtpub.com/authors.
Now that you are the proud owner of a Packt book, we have a number of things to help you to get the most from your purchase.
Although we have taken every care to ensure the accuracy of our content, mistakes do happen. If you find a mistake in one of our books—maybe a mistake in the text or the code—we would be grateful if you would report this to us. By doing so, you can save other readers from frustration and help us improve subsequent versions of this book. If you find any errata, please report them by visiting http://www.packtpub.com/support, selecting your book, clicking on the errata submission form link, and entering the details of your errata. Once your errata are verified, your submission will be accepted and the errata will be uploaded on our website, or added to any list of existing errata, under the Errata section of that title. Any existing errata can be viewed by selecting your title from http://www.packtpub.com/support.
Piracy of copyright material on the Internet is an ongoing problem across all media. At Packt, we take the protection of our copyright and licenses very seriously. If you come across any illegal copies of our works, in any form, on the Internet, please provide us with the location address or website name immediately so that we can pursue a remedy.
Please contact us at <[email protected]> with a link to the suspected pirated material.
We appreciate your help in protecting our authors, and our ability to bring you valuable content.
You can contact us at <[email protected]> if you are having a problem with any aspect of the book, and we will do our best to address it.