The authoritative, hands-on guide to advanced MySQL programming and administration techniques for high performance is here.
MySQL Database Design and Tuning is the only guide with coverage of both the basics and advanced topics, including reliability, performance, optimization and tuning for MySQL. This clear, concise and unique source for the most reliable MySQL performance information will show you how to:
- Deploy the right MySQL product for your performance needs.
- Set up a performance management and monitoring environment using tools from MySQL.
- Implement the right indexing strategy
- Apply good performance strategy when developing software to work with the MySQL database.
- Configure dozens of variable to correctly tune the MySQL engine.
If you deal with the intricacies and challenges of advanced MySQL functionality on a daily basis, you will be able to build on your knowledge with author
Robert Schneider's real-world experiences in
MySQL Database Design and Tuning.
Customer Reviews & Comments
I'm a DBA for a mid-sized manufacturing company. We were about to upgrade our SQL Server to Oracle 10g, which was going to set ups back a lot of money. I had been experimenting with MySQL and bought this helpful book to give me a better understanding of how to make it run fast. I really liked the case studies, because they cover a lot of different senarios. To make long story short, I was able to convert the SQL Server database to MySQL, and things have been going great.