I’m pleased to announce that my first book, the InnoDB Quick Reference Guide, is now available from Packt Publishing and you can download it by clicking here. It covers the most common topics of InnoDB usage in the enterprise, including: general overview of its use and benefits, detailed explanation of seventeen static variables and seven dynamic variables, load testing methodology, maintenance and monitoring, as well as troubleshooting and useful analytics for the engine. The current version of MySQL ships with InnoDB as the default table engine, so whether you program your MySQL enabled applications with PHP, Python, Perl or otherwise, you’ll likely benefit from this concise but comprehensive reference guide for InnoDB databases.
Here are the chapter overviews for reference:
- Getting Started with InnoDB: a quick overview of core terminology and initial setup of the testing environment.
- Basic Configuration Parameters: learn about the most common settings and prerequisites for performance tuning.
- Advanced Configuration Parameters: covers advanced settings that can make or break a high-perfomance installation of InnoDB.
- Load Testing InnoDB for Performance: learn all about general purpose InnoDB load testing as well as common methods for simulating production workloads.
- Maintenance and Monitoring: covers the important sections of InnoDB to monitor, tools to use, and processes that adhere to industry best practices.
- Troubleshooting InnoDB: learn all about identifying and solving common production issues that may arise.
- References and Links: informative data for further reading.