| CARVIEW |
Select Language
HTTP/2 302
server: nginx
date: Sun, 03 Aug 2025 09:25:51 GMT
content-type: text/plain; charset=utf-8
content-length: 0
x-archive-redirect-reason: found capture at 20081212143142
location: https://web.archive.org/web/20081212143142/https://www.oreilly.com/catalog/9780596003067/
server-timing: captures_list;dur=0.508290, exclusion.robots;dur=0.015348, exclusion.robots.policy;dur=0.007872, esindex;dur=0.012573, cdx.remote;dur=81.167581, LoadShardBlock;dur=207.678994, PetaboxLoader3.datanode;dur=63.640060, PetaboxLoader3.resolve;dur=118.547972
x-app-server: wwwb-app225
x-ts: 302
x-tr: 313
server-timing: TR;dur=0,Tw;dur=0,Tc;dur=1
set-cookie: wb-p-SERVER=wwwb-app225; path=/
x-location: All
x-rl: 0
x-na: 0
x-page-cache: MISS
server-timing: MISS
x-nid: DigitalOcean
referrer-policy: no-referrer-when-downgrade
permissions-policy: interest-cohort=()
HTTP/2 200
server: nginx
date: Sun, 03 Aug 2025 09:25:52 GMT
content-type: text/html
x-archive-orig-date: Fri, 12 Dec 2008 14:31:19 GMT
x-archive-orig-server: Apache
x-archive-orig-p3p: policyref="https://www.oreillynet.com/w3c/p3p.xml",CP="CAO DSP COR CURa ADMa DEVa TAIa PSAa PSDa IVAa IVDa CONo OUR DELa PUBi OTRa IND PHY ONL UNI PUR COM NAV INT DEM CNT STA PRE"
x-archive-orig-last-modified: Fri, 12 Dec 2008 06:25:02 GMT
x-archive-orig-accept-ranges: bytes
x-archive-orig-content-length: 40586
x-archive-orig-x-cache: MISS from olive.bp
x-archive-orig-x-cache-lookup: MISS from olive.bp:3128
x-archive-orig-via: 1.0 olive.bp:3128 (squid/2.6.STABLE13)
x-archive-orig-connection: close
x-archive-guessed-content-type: text/html
x-archive-guessed-charset: utf-8
memento-datetime: Fri, 12 Dec 2008 14:31:42 GMT
link: High Performance MySQL | O'Reilly Media
High Performance MySQL
Optimization, Backups, Replication, Load Balancing & More
Featured customer reviews
Fantastic!, June 05 2008
This is not a How To book.
This is the book you get once you understand basic MySQL and your boss starts talking about disaster recovery, replication, hot spares, backup snapshots and performance.
Amazing coverage of advanced MySQL use. I've already worn out the spine on it and it's dog-eared 8)
I saw only 3 reviews on this. It really needs to be in every bookshelf owned by people in charge of operational support of this DB.
It's a "can't live without it" title for me, right there with DNS/BIND, CVS and the various unix and programming titles I own.
Great job Jeremy and Derek!
-v
MySQL on Steroids, March 01 2008
High Performance MySQL opens with a quick chapter describing various MySQL installation options including binary packages and compiling from source code. The next chapter describes the different storage engines available in MySQL and why you would want to choose one over another. This is the book's first hint of what you can do to improve database performance: picking the right table type.
Skilled software developers use benchmarking to gain insight into how their software is performing and database benchmarking should be part of that strategy. A brief chapter introduces some database benchmarking strategies and tools.
Chapters on indexing and query performance follow, describing some of the most important skills to master. Following that, replication and load balancing are discussed. Backup and recovery options are covered, as is the topic of security.
A somewhat thin trio of goodies rounds off the book in the appendices: the SHOW STATUS / SHOW INNODB STATUS commands, the mytop tool, and the phpMyAdmin user interface.
Overall, I found many possible areas for performance improvement that I had not thought of before. At 278 pages, a lot of material is crammed into this book. It's a quick read and if you're a MySQL admin or a developer using MySQL, you're bound to find something useful here!
A must for those that use MySQL on a regular basis, December 15 2004
If you interact with MySQL on a regular basis, High Performance MySQL should be the next book that you read. High Performance MySQL does a great job at covering techniques on benchmarking your current configuration and how to increase performance at 3 major levels: 1) database architecture, 2) server tuning, and 3) scaling horizontally (with multiple servers).
Database architecture is where it really begins. Zawodny and Balling did a great job explaining the different storage engines along with their advantages and disadvantages, working with transactions, how to get the most of your database through indexing and how to optimize query performance.
Zawodny and Balling also did an excellent job on covering server tuning. It just wasn’t a turtorial on ‘this is how you should modify your configuration files.’ The authors whent into great detail in explaining different hardware configurations, what to look for in RAID configurations and different filesystems, and how to solve various bottlenecks.
For the most part, the authors reserved a complete 60 pages of the book for Replicaiton and Load Balancing configurations. The authors provided several scenarios to choose from along with the advantages and disadvantages of each.
Enterprise-level MySQL, April 19 2004
High Performance MySQL is a good look at the issues faced by DBAs in high performance environments..
MySQL books to date have tended to be reviews of basic installation and configuration. This books assumes you have covered that ground already, a welcome departure.
The book takes an intermedite-level approach to topics such as indexing, replication, backup, and tuning.
On the positive side, the book is engaging and very readable. Although the material is, by nature, theoretical, the authors have taken effort to attach real-world examples to the concepts they are covering.
On the negative side, there were a few typos and grammatical errors in the book, such as a diagram referring to the 'NBD' storage engine (should read BDB). Perhaps one more trip through the editing desk would have been helpful. However, the material itself is comprehensive and accurate, and is not affected by these minor slips.
Overall, the books is recommended for DBAs who do non-trivial work with MySQL.
Media reviews "If you have a site (or sites) that require tuning, or just want to make sure that your database development practices won’t cause you growing pains down the road, this book is a necessity. Jeremy and Derek bring a tremendous wealth of knowledge together for a very concise, easy read that provides immediate benefits."
--Mitchell Pirtle, International PHP Magazine, February 2005
"I was somewhat anxious to crack open a copy of the book High Performance MySQL published by O'Reilly and written by Jeremy [Zawodny] and Derek J. Balling. With such high expectations, it would be easy to be disappointed with the content or level of the material in the book. Far from disappointing, High Performance MySQL was exactly what I had hoped it would be and more...I believe High Performance MySQL is an excellent choice for the MySQL administrator or developer not only looking to improve their database performance but also to improve his knowledge of MySQL."
Rating: Excellent
--Steve Suehring, Slashdot.org, October 2004
https://books.slashdot.org/books/04/10/13/2016211.shtml?tid=198&tid;=221&tid;=172&tid;=6
"While there may be good books on MySQL development, it's nice to have a well-written book on MySQL administration. Zawodny and Balling certainly have the experience in this topic and in writing. It's definitely a book worth buying, and it's especially one that a MySQL administrator will find worth reading carefully and thoroughly. It's an excellent book for increasing your proficiency in MySQL."
--Russell Dyer, UnixReview.com, July 2004
https://www.unixreview.com/documents/s=9233/ur0407j/ur0407j.htm
Read all reviews
BUY THIS BOOK
By Jeremy Zawodny, Derek J. Balling
April 2004
Pages: 294
ISBN 10: 0-596-00306-4 |
ISBN 13: 9780596003067
(Average of 4 Customer Reviews)
This book is OUT OF PRINT. Please consider the latest edition.
DescriptionIn High Performance MySQL you will learn about MySQL indexing and optimization in depth so you can make better use of these key features. You will learn practical replication, backup, and load-balancing strategies with information that goes beyond available tools to discuss their effects in real-life environments. And you'll learn the supporting techniques you need to carry out these tasks, including advanced configuration, benchmarking, and investigating logs.
Full Description
As users come to depend on MySQL, they find that they have to deal with issues of reliability, scalability, and performance--issues that are not well documented but are critical to a smoothly functioning site. This book is an insider's guide to these little understood topics.
Author Jeremy Zawodny has managed large numbers of MySQL servers for mission-critical work at Yahoo!, maintained years of contacts with the MySQL AB team, and presents regularly at conferences. Jeremy and Derek have spent months experimenting, interviewing major users of MySQL, talking to MySQL AB, benchmarking, and writing some of their own tools in order to produce the information in this book.
In High Performance MySQL you will learn about MySQL indexing and optimization in depth so you can make better use of these key features. You will learn practical replication, backup, and load-balancing strategies with information that goes beyond available tools to discuss their effects in real-life environments. And you'll learn the supporting techniques you need to carry out these tasks, including advanced configuration, benchmarking, and investigating logs.
Topics include:
- A review of configuration and setup options
- Storage engines and table types
- Benchmarking
- Indexes
- Query Optimization
- Application Design
- Server Performance
- Replication
- Load-balancing
- Backup and Recovery
- Security
Featured customer reviews
Fantastic!, June 05 2008
Rating:
Submitted by
vippi-va-voom
[Respond | View]
This is not a How To book.
This is the book you get once you understand basic MySQL and your boss starts talking about disaster recovery, replication, hot spares, backup snapshots and performance.
Amazing coverage of advanced MySQL use. I've already worn out the spine on it and it's dog-eared 8)
I saw only 3 reviews on this. It really needs to be in every bookshelf owned by people in charge of operational support of this DB.
It's a "can't live without it" title for me, right there with DNS/BIND, CVS and the various unix and programming titles I own.
Great job Jeremy and Derek!
-v
MySQL on Steroids, March 01 2008
Rating:
Submitted by
Dave Walz-Burkett
[Respond | View]
High Performance MySQL opens with a quick chapter describing various MySQL installation options including binary packages and compiling from source code. The next chapter describes the different storage engines available in MySQL and why you would want to choose one over another. This is the book's first hint of what you can do to improve database performance: picking the right table type.
Skilled software developers use benchmarking to gain insight into how their software is performing and database benchmarking should be part of that strategy. A brief chapter introduces some database benchmarking strategies and tools.
Chapters on indexing and query performance follow, describing some of the most important skills to master. Following that, replication and load balancing are discussed. Backup and recovery options are covered, as is the topic of security.
A somewhat thin trio of goodies rounds off the book in the appendices: the SHOW STATUS / SHOW INNODB STATUS commands, the mytop tool, and the phpMyAdmin user interface.
Overall, I found many possible areas for performance improvement that I had not thought of before. At 278 pages, a lot of material is crammed into this book. It's a quick read and if you're a MySQL admin or a developer using MySQL, you're bound to find something useful here!
A must for those that use MySQL on a regular basis, December 15 2004
Rating:
Submitted by
ADR
[Respond | View]
If you interact with MySQL on a regular basis, High Performance MySQL should be the next book that you read. High Performance MySQL does a great job at covering techniques on benchmarking your current configuration and how to increase performance at 3 major levels: 1) database architecture, 2) server tuning, and 3) scaling horizontally (with multiple servers).
Database architecture is where it really begins. Zawodny and Balling did a great job explaining the different storage engines along with their advantages and disadvantages, working with transactions, how to get the most of your database through indexing and how to optimize query performance.
Zawodny and Balling also did an excellent job on covering server tuning. It just wasn’t a turtorial on ‘this is how you should modify your configuration files.’ The authors whent into great detail in explaining different hardware configurations, what to look for in RAID configurations and different filesystems, and how to solve various bottlenecks.
For the most part, the authors reserved a complete 60 pages of the book for Replicaiton and Load Balancing configurations. The authors provided several scenarios to choose from along with the advantages and disadvantages of each.
Enterprise-level MySQL, April 19 2004
Rating:
Submitted by
Dan
[Respond | View]
High Performance MySQL is a good look at the issues faced by DBAs in high performance environments..
MySQL books to date have tended to be reviews of basic installation and configuration. This books assumes you have covered that ground already, a welcome departure.
The book takes an intermedite-level approach to topics such as indexing, replication, backup, and tuning.
On the positive side, the book is engaging and very readable. Although the material is, by nature, theoretical, the authors have taken effort to attach real-world examples to the concepts they are covering.
On the negative side, there were a few typos and grammatical errors in the book, such as a diagram referring to the 'NBD' storage engine (should read BDB). Perhaps one more trip through the editing desk would have been helpful. However, the material itself is comprehensive and accurate, and is not affected by these minor slips.
Overall, the books is recommended for DBAs who do non-trivial work with MySQL.
Media reviews "If you have a site (or sites) that require tuning, or just want to make sure that your database development practices won’t cause you growing pains down the road, this book is a necessity. Jeremy and Derek bring a tremendous wealth of knowledge together for a very concise, easy read that provides immediate benefits."
--Mitchell Pirtle, International PHP Magazine, February 2005
"I was somewhat anxious to crack open a copy of the book High Performance MySQL published by O'Reilly and written by Jeremy [Zawodny] and Derek J. Balling. With such high expectations, it would be easy to be disappointed with the content or level of the material in the book. Far from disappointing, High Performance MySQL was exactly what I had hoped it would be and more...I believe High Performance MySQL is an excellent choice for the MySQL administrator or developer not only looking to improve their database performance but also to improve his knowledge of MySQL."
Rating: Excellent
--Steve Suehring, Slashdot.org, October 2004
https://books.slashdot.org/books/04/10/13/2016211.shtml?tid=198&tid;=221&tid;=172&tid;=6
"While there may be good books on MySQL development, it's nice to have a well-written book on MySQL administration. Zawodny and Balling certainly have the experience in this topic and in writing. It's definitely a book worth buying, and it's especially one that a MySQL administrator will find worth reading carefully and thoroughly. It's an excellent book for increasing your proficiency in MySQL."
--Russell Dyer, UnixReview.com, July 2004
https://www.unixreview.com/documents/s=9233/ur0407j/ur0407j.htm
Read all reviews
Got a Question?
 © 2008, O'Reilly Media, Inc. (707) 827-7000 / (800) 998-9938 All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners. |
About O'Reilly Privacy Policy Contacts Customer Service Authors Press Room Jobs User Groups Academic Solutions Newsletters Writing for O'Reilly RSS Feeds Terms of Service |
Other O'Reilly Sites O'Reilly Radar Ignite Tools of Change for Publishing Digital Media Inside iPhone O'Reilly FYI makezine.com craftzine.com hackszine.com perl.com xml.com |
Sponsored Sites Inside Aperture Inside Lightroom Inside Port 25 InsideRIA java.net |