PacktLib: Instant InnoDB [Instant]

Instant InnoDB

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

Getting Started with InnoDB

Basic features of InnoDB

System requirements and supported platforms

Downloading MySQL with InnoDB

Creating your first InnoDB table

Summary

Basic Configuration Parameters

MySQL memory allocation equations

InnoDB memory and data file configuration

Summary

Advanced Configuration Parameters

InnoDB and input/output resources

Disk speed: standard IOPS

InnoDB variables

Summary

Load Testing InnoDB for Performance

Open source system monitoring tools

Open source MySQL load testing applications

MySQL Benchmark Suite

Filesystem benchmarking

InnoDB Flush methods

Thread concurrency testing

Advisory on transaction-isolation level

Summary

Maintenance and Monitoring

Maintenance procedures

Monitoring InnoDB

Summary

Troubleshooting InnoDB

Troubleshooting system issues

Troubleshooting InnoDB performance

Global status variables – trending statistics

Get to grips with InnoDB error codes

InnoDB troubleshooting and backup applications

Summary

References and Links

General documentation

Reference books

Index