InnoDB, the default storage engine for MySQL, is one of the most robust and commonly used in the world today. It can, however, be initially daunting to learn how to start implementing its features, and it can pose unique problems to the beginner user. This guide is written to address these problems.
"InnoDB Quick Reference Guide" addresses everything you need to know for the installation, configuration, load testing, analysis, and long term support of an InnoDB based database environment. If you've ever wanted to learn more about InnoDB but didn't want to sit down with a formidably large or dry read, then the InnoDB Quick Reference Guide is your ideal companion.
"InnoDB Quick Reference Guide" guides you expertly through the initial setup and system requirements for getting up and running with a simple environment that can be used for the development and testing of the InnoDB engine.
After an in-depth look at basic and advanced configuration settings we delve into the internals of InnoDB that allow it to handle Multi-Version Concurrency Control and ACID transaction compliance. We will then dig deeper into advanced topics, such as memory buffer tuning methods and transaction log file handling. We'll then cover typical approaches and solutions to monitoring the database and reporting on operational states.
By the end of the InnoDB Quick Reference Guide, we will have covered the common approaches to troubleshooting and error handling, as well as providing you with solutions to the most common architectural, administrative, and engineering related situations that arise when working with the InnoDB database engine.
This book is a complete reference guide, designed to provide you with answers and solutions to all the common problems you encounter within InnoDB, helping you achieve higher performance and greater stability in your InnoDB databases.
Who this book is for
The "InnoDB Quick Reference Guide" features content for all skill levels of MySQL administrators, developers, and engineers.
- File Size: 351 KB
- Print Length: 88 pages
- Publisher: Packt Publishing (February 1, 2013)
- Publication Date: February 1, 2013
- Sold by: Amazon Digital Services LLC
- Language: English
- ASIN: B00BAQ77MW
- Text-to-Speech: Enabled
- X-Ray: Not Enabled
- Word Wise: Not Enabled
- Lending: Not Enabled
- Screen Reader: Supported
- Enhanced Typesetting: Enabled