MySQL Database Design and Tuning [Paperback]

Robert D Schneider (Author)

Book Description

ISBN-10: 0672327651 | ISBN-13: 978-0672327650 | Publication Date: June 23, 2005

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.

Editorial Reviews

About the Author

MySQL® Database Design and TuningAbout 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 [e-mail].

© Copyright Pearson Education. All rights reserved.

Product Details

• Paperback: 432 pages
• Publisher: MySQL Press (June 23, 2005)
• Language: English
• ISBN-10: 0672327651
• ISBN-13: 978-0672327650
• Product Dimensions: 9 x 7.1 x 1 inches
• Shipping Weight: 1.5 pounds (View shipping rates and policies)
• Average Customer Review: 4.3 out of 5 stars  See all reviews (3 customer reviews)
• Amazon Best Sellers Rank: #518,330 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

9 of 9 people found the following review helpful:

5.0 out of 5 stars I was about to buy Oracle, but chose MySQL instead (and saveed big $$$), September 8, 2007

By 

Pearly "canyonheathmom" (United States) - See all my reviews

This review is from: MySQL Database Design and Tuning (Paperback)

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.

15 of 21 people found the following review helpful:

4.0 out of 5 stars 64 Terabytes of table space!, July 24, 2005

By 

W Boudville (Terra, Sol 3) - See all my reviews
(VINE VOICE)    (TOP 1000 REVIEWER)    (HALL OF FAME REVIEWER)    (REAL NAME)   

This review is from: MySQL Database Design and Tuning (Paperback)

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.

4.0 out of 5 stars Easy to understand and fantastic optimization tips for MySQL and even MS-SQL or Oracle databases, July 8, 2010

By 

Jose A. Campo "SQL DBA [MCTS on SQL2005 & 2008]" (Houston, TX) - See all my reviews
(REAL NAME)   

This review is from: MySQL Database Design and Tuning (Paperback)

I am really impressed with the writing style and content of this book. Even though is not really a recent publication its content is still valid and full of nice tuning tips.

The main topic is of course MySQL but author talks about Index and Query tuning, topics than can be easily extrapolated to other RDBMS like MS-SQL or Oracle, helping you with other RDBMS during the process in case you're just a seasonal MySQL dba.

He does not go too much in detail, maybe MySQL (4th Edition) by Paul DuBois fills that hole better but Robert's book I think that is easier to read, without being a dummy book. For a complete MySQL coverage after reading this one, browse for any of Paul's books, he's really the best choice on MySQL books right now (content and easy to read books)

The chapter dedicated to the storage engines is one of my favorites and the one which differentiates this book for any other MS-SQL or Oracle tuning book. MySQL uses a modular approach for storage engine, allowing you to create tables and assign those to that particular engine taking advantage of a better transaction handling (InnoDB engine) or an improved speed for read only or tables (MyISAM engine). It was awesome to open my eyes, see the light and compare with MS-SQL (my main expertise) or see that the database world, like Operating Systems, is not black and white, not just Oracle vs MS-SQL. Actually, MySQL and Oracle are products of the same company and no wonder why after reading this book.

Good book, recommended, and I can assure you that if you're new into MySQL you will start considering this one as a good choice for your production database, especially if your databases are not OLTP but mostly read only or for reporting purposes; MySQL beauty and stronger point ... MyISAM engine ...