MySQL Database Design and Tuning

MySQL Database Design and Tuning

4.0 1
by Robert D Schneider
     
 

View All Available Formats & Editions

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

See more details below

Overview

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.

Product Details

ISBN-13:
9780672332692
Publisher:
Pearson Education
Publication date:
06/13/2005
Series:
Novell Press
Sold by:
Barnes & Noble
Format:
NOOK Book
Pages:
432
File size:
8 MB

Meet the Author

MySQL® Database Design and Tuning About the Author

Robert D. Schneider has more than 15 years of experience developing and delivering sophisticated software solutions worldwide. He has provided database optimization, distributed computing, and other technical expertise to a wide variety of enterprises in the financial, technology, and government sectors. Clients have included Chase Manhattan Bank, VISA, HP, SWIFT, and the governments of the United States, Brazil, and Malaysia.

He is the author of Optimizing Informix Applications and Microsoft SQL Server: Planning and Building a High Performance Database. He has also written numerous articles on technical and professional services topics. He can be reached at Robert.Schneider@Think88.com.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >

MySQL Performance Optimization 4 out of 5 based on 0 ratings. 1 reviews.
Guest More than 1 year ago
Many of you might be tempted to go with the free MySQL, instead of possibly paying big bucks to Oracle or IBM for their databases. But what may have been holding you back could be a worry that when you go with MySQL, you are on your own. Unless you are already well versed with it, are there pitfalls in the implementation of table design or tuning that render the choice of MySQL a false economy? It's a reasonable worry. Schneider does well here to disabuse you of that notion. He addresses both issues. On the subject of table design, the advice is clear. Actually, it seems that the discussion is broadly applicable to any SQL/relational implementation. If you already know some SQL, you won't feel that MySQL is some weird variant. Which speaks well of its designers. Most of the book, however, deals with tuning aspects. Now here, you'll probably have to learn new things. Each SQL implementation seems to have specific tuning characteristics. There is little standardisation here across implementations. As what I hope is a reasonable guess, check out the sections on improving the efficiency of searches (ie. queries). This may be the most important thing to optimise in many applications. In passing, let me make one remark about MySQL's InnoDB data storage engine. It can hold a table space of as much as 64 Terabytes! For the vast majority of you, this should be adequate addressing. And it's a rejoinder to competitors who say MySQL is limited.