This isn't really news, but hey... better late than never.

In case it isn't obvious, some images just don't scale well. So until I ask O'Reilly for a thumbnail image, it's probably best to look at the full-sized one on the book web site:

If you can do a better job, grab the original and show me. I freely admit to having no graphics (or design) skill at all.

There isn't a lot on-line there yet. Once most of the writing is done, there will be news, an RSS feed, and other good stuff. For now, you're probably asking yourself "what's this book about?" In case the name isn't relatively obvious (don't get me started on how difficult it is to name a book), here's the Table of Contents--subject to changes before this thin appears on shelves somewhere. But it should be sufficient to give you an idea of what's covered.

  1. Back To Basics
  2. Storage Engines
  3. Benchmarking
  4. Indexes
  5. Query Performance
  6. Server Performance Tuning
  7. Replication
  8. Load Balancing
  9. Backup and Recovery
  10. Security

If there's a topic you think is missing, let me know. I doubt we can do much about it, but you never know.

"We?" you ask. Yes, I recruited another fool to help get the book out the door. That's why there are two names on the cover. :-)

Oh, and for those of you wondering about the book known as "Advanced MySQL", this is the same book. The old title was really just a working title. Yeah, that's it.

Update: Thanks for all the scaled covers! You can stop sending them now. I've used one from Jon Abernathy, simply because he was first and it looks good.

Posted by jzawodn at July 22, 2003 01:46 PM

Reader Comments
# Simon Willison said:

Nice cover! What species of bird of prey is that? (I'm one of those people who turns straight to the colophon).

on July 22, 2003 02:16 PM
# Jon said:

I just sent you off a decent scaled-down version of the book cover. See what you think.

on July 22, 2003 02:25 PM
# Jeremy Zawodny said:

I'm told it's a Sparrow Hawk.

on July 22, 2003 02:32 PM
# justin said:
on July 22, 2003 02:35 PM
# said:

you should add "border=0" to the img tag as it look odd when you have a border around a white image.. 2 cents

on July 22, 2003 02:39 PM
# Kevin Bourrillion said:

Oh man, we could use that book. When?

on July 22, 2003 03:23 PM
# Paul said:

The problem that I have with many books is that they do not go into enough detail!! For example you can get several books that already cover mysql and all the above topics mentioned BUT they really skim the topics and add lots of code fillers. Give me the f*cking (to the other authors not you :) idea and I can write the code! I don't need 10 pages code examples!

My suggestion would be to go into as much detail as possible in the following areas

- Benchmarking
- Replication
- Load Balancing

As the above topics are fairly hard to research online and I personally have not found an abundance of information (If Iím wrong please correct me!). These topics are extremely important to anyone wishing to implement mysql in an enterprise environment. Most of the other topics you mentioned there is already a fair amount of information available.

In conclusion you might want to mention something about scalablitiy and the problems that appear.

on July 22, 2003 03:48 PM
# BillSaysThis said:

Not sure if this is out of scope for your plans, but how about coverage of Data Warehousing using MySQL?

on July 22, 2003 04:32 PM
# havoc said:

I think Chapter 5 should be "Query Performance and Optimization," then approach the subject in that order. a) What issues affect performance. b) How do you start optimizing queries, and tools available to help. Query optimization is probably the hardest part of someone who's never had any formal training on SQL, and gets all of his knowlege about such things from a book... not that I know anyone like that... personally... ;D

on July 22, 2003 09:53 PM
# said:

Congrats Jermey! Out of curiosity, why the choice of a Sparrow Hawk? (Or do I have to wait until it comes out and read the back? ;-)

on July 22, 2003 11:26 PM
# Dan Isaacs said:

I don't think the animals have anything to do with the book. Last time I asked about this (many blue moons ago) I was told Tim's assistant or someone picks them, and they have nothing to do really with the title or contents of a book. At least, I think that's what I was told. I'm over 30 now, so I don't really trust myself.

on July 23, 2003 05:19 AM
# Joe Grossberg said:

Why Red? The other O'Reilly open source DB books are pink (the other MySQL one, and the Postgres one).

on July 23, 2003 10:19 AM
# Yusuf said:

Jeremy, A while ago you were going to do some head-to-head comparision of mysql on FreeBSD and Redhat Linux 9 (maybe see how NPTL impacts mysql)

Did you ever get round to this ?

on July 23, 2003 10:55 PM
# Chris said:

I can't wait to get my paws on this book.

On a barely related topic, is there a good source anywhere about using a RDBMS like mysql to house and consume Attribute-based data structures; specifically the methodologies use to turn attributes back into "rows"?

on July 25, 2003 11:09 AM
# RickySilk said:

Any word on when this book will be released?

on July 28, 2003 06:52 AM
Disclaimer: The opinions expressed here are mine and mine alone. My current, past, or previous employers are not responsible for what I write here, the comments left by others, or the photos I may share. If you have questions, please contact me. Also, I am not a journalist or reporter. Don't "pitch" me.


Privacy: I do not share or publish the email addresses or IP addresses of anyone posting a comment here without consent. However, I do reserve the right to remove comments that are spammy, off-topic, or otherwise unsuitable based on my comment policy. In a few cases, I may leave spammy comments but remove any URLs they contain.