Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 30 of 46 Next 16 Older Entries

Displaying posts with tag: High Performance MySQL (reset)

What’s your opinion of High Performance MySQL?
+0 Vote Up -1Vote Down

The second edition of High Performance MySQL has 27 reviews on Amazon, but the third edition only has 5 so far. By this point I assume many of you have a copy and have read it cover to cover. I’d really appreciate your reviews — when purchasing, people look not only at the star rating but at the number of reviews. You can create a review here. And thanks!

Further Reading:

  [Read more...]
High Performance MySQL 3rd edition now available
+10 Vote Up -0Vote Down

The third edition is now available in ePub, Mobi, and PDF formats. Print format should be available early next week.

Further Reading:

  [Read more...]
Get a free copy of High Performance MySQL 3rd Edition!
+0 Vote Up -0Vote Down

Want a free copy of High Performance MySQL, Third Edition? If you register before the early-bird pricing expires for the MySQL Conference in April, and use the discount code PL-Book, you’ll get to take a free copy home from the conference!

And now, a status update: I’m currently proofing the QC2 (quality control #2) revision of the book; after this, the book goes to manufacturing. The PDF is now 820 pages, which is a lot of work to proofread. You can imagine how much more in-depth we’ve been able to go with so many more pages.

The

  [Read more...]
High Performance MySQL Third Edition pre-order available
+8 Vote Up -1Vote Down

You can pre-order the new edition of High Performance MySQL now on Amazon or via O’Reilly’s website.

Eric Bergen called the second edition “the best MySQL book on the planet“. What will the third edition be called? The best in the solar system? This reminds me of a joke, supposed to be a true story: three pizza restaurants next to each other had signs saying “best pizza in town,” “best pizza in the world,” and “best pizza on this block.”

Further Reading:

  [Read more...]
Status update on High Performance MySQL
+4 Vote Up -0Vote Down

The third edition is nearly done. I’ve committed first drafts of all chapters, and all but one appendix. I need to do the last appendix and then rewrite the preface, which is a few days of work at my current pace. After that, it’s the usual tech review, copyediting, updates to figures, etc — and then it’s off to production.

I’m really pleased with this edition. I was planning on it just being a refresh of the second edition to reflect what’s new in MySQL-land, but it’s almost a complete rewrite. There’s a lot more focus on a logical approach throughout: what happens in the server, what are the limitations, why this matters, what are the practical consequences and applications, and therefore…. The “and therefore” is the real reason you buy a book such as this one.

Further

  [Read more...]
Progress on High Performance MySQL 3rd Edition
+3 Vote Up -0Vote Down

A few people have asked me how it’s going, so I thought I’d just share it with everyone. Things are going great. I’m writing much more quickly than I thought I would be, and as a result I’m finding I have time to do more changes than I thought I could, which makes me happy. I should be finished drafting the chapters by the end of the year.

In particular, the faster than expected pace is giving me a chance to address one of the big weaknesses of the second edition. In many places, the second edition is a collection of facts and experiences. It says what and why, but it doesn’t convey a process or method, and it doesn’t teach you how to think about things and apply the results to situations beyond what the book covers. I’m finding a number of key areas to remedy that: performance optimization, profiling, indexing,

  [Read more...]
High Performance MySQL, Third Edition
+9 Vote Up -0Vote Down

I have just signed the contract for High Performance MySQL, Third Edition. The third edition will include major updates and new content in these areas:

  • Recent performance and reliability advances, particularly in MySQL 5.5 and the InnoDB storage engine.
  • A new chapter on using MySQL in cloud computing environments.
  • Updates on modern hardware, including many CPUs, large memory, and solid-state storage.
  • Improvements in clustering and high availability, including middleware and third-party solutions.
  • Improvements in replication.
  • New material on profiling MySQL, benchmarking, and tools and techniques to help you measure, monitor, and manage your MySQL installations.

The book will be available for purchase early next year. It’s been a great three years since the

  [Read more...]
High Performance MySQL in your language
+0 Vote Up -0Vote Down
O’Reilly tells me that translation rights for our book, High Performance MySQL Second Edition have been purchased in the following languages: Korean Russian Portuguese Polish Spanish Czech Some of them were sold quite a while ago, and some are more recent. Portuguese was the first. I’m looking forward to learning all these languages (except for Spanish, which I already sort [...]
Update on High Performance MySQL, 2nd Edition
+0 Vote Up -0Vote Down
I just thought I’d drop a line about our book. Sales appear to be doing well still: the book is still at Amazon sales rank 3,213 and seems to hold pretty steady there. A lot of people have discovered it and are recommending it — including members of MySQL’s professional services team. [...]
High Performance MySQL 2nd Edition gets revised and translated
+0 Vote Up -0Vote Down

Just thought I’d update you. We got quite a few good errata from readers, and I took a couple weekends and went through the book with a fine-toothed comb, catching typos and subtle errors that crept in at some point (TPC benchmarks were labeled as TCP benchmarks — did you catch that one?). I marked up my book and mailed it to O’Reilly, who went well above and beyond what they normally do for errata. Normally, once a book is in print they will fix only serious technical errors. They fixed everything, even going as far as rearranging page breaks and moving figures to improve readability.

The second printing is on Monday August 4th. Already! I think the book has been selling a lot better than anticipated. I know I am psyched to see it remain in the top couple thousand on Amazon. And they thought it was a big deal

  [Read more...]
Are you sure you?re reading the second edition of High Performance MySQL?
+0 Vote Up -0Vote Down

I have been getting a lot of comments and errata from people who seem to be mistakenly buying the first edition and believing it’s the second edition. A lot of the blame for this probably rests with Amazon, who did not distinguish between the two editions at all until the editor and I (among others) leaned on them persistently for about 6 weeks. I think some people are buying the second edition and getting the first edition.

I’ve even spoken to people in person who said “yeah, I’ve been reading it” and I give them a copy of the second edition to hold in their hands, and they go “whoa, that is like twice the size. I don’t have this edition at all.”

If you have any question at all, just look at the front cover. If you have the second edition, you will see it clearly in

  [Read more...]
High Performance MySQL is going to press, again
+0 Vote Up -0Vote Down

Apparently High Performance MySQL, 2nd Edition is selling quite well — I’m not sure exactly how well — because we’re preparing for a second printing. This makes me very happy. I don’t think they anticipated going back to the press for quite some time.

The book fluctuates between sales rank 1000 and 2000 on Amazon during the day, and has reached as high as 600 or so. This is just phenomenal. The O’Reilly team was psyched when it broke 5000, and so was I — but now we’ve stayed under 2000 for a long time (except when Amazon sold out of it). Frankly I’d have thought that for a niche-market book like this, we’d have been in the 10,000 range or something like that.

Clearly we (the authors, editors, publisher, etc) have done something right!

  [Read more...]
Sphinx 0.9.8 is released!
+0 Vote Up -0Vote Down

The Sphinx project just released version 0.9.8, with many enhancements since the previous release. There’s never been a better time to try it out. It’s really cool technology.

What is Sphinx? Glad you asked. It’s fast, efficient, scalable, relevant full-text searching and a heck of a lot more. In fact, Sphinx complements MySQL for a lot of non-search queries that MySQL frankly isn’t very good at, including WHERE clauses on low-selectivity columns, ORDER BY with a LIMIT and OFFSET, and GROUP BY. A lot of you are probably running fairly simple queries with these constructs and getting really bad performance in MySQL. I see it a lot when I’m working with clients, and there’s often not much room for optimization. Sphinx can execute a subset of such queries very efficiently, due to its smart I/O

  [Read more...]
What if you find errors in High Performance MySQL?
+0 Vote Up -0Vote Down

The book is done now, right? What’s next?

Don’t tell my wife this, but a book is never done.

Right now I’m proofreading the printed copy. I proofread PDF after PDF during production, but some problems will always slip through and make it to paper. I’m finding quite a few little mistakes. For example, at one point we refer to TPC as TCP three times in a row. Oops.

These problems will be corrected in the next printing. Please notify me if you find any errors yourself, and I’ll add them to the list of things to fix! Also let me know if you find things that should just be “fixed” in general. For example, the layout and page-breaking on pages 364 and 365 is totally confusing — it’s hard to tell which figures are associated with which text.

  [Read more...]
What it?s like to write a technical book, continued
+0 Vote Up -0Vote Down

My post on what it’s like to write a technical book was a stream-of-consciousness look at the process of writing High Performance MySQL, Second Edition. I got a lot of responses from it and learned some neat things I wouldn’t have learned if I hadn’t written the post. I also got a lot of questions, and my editor wrote a response too. I want to follow up on these things.

Was I fair, balanced and honest?

I really intended to write the post as just “here’s what it’s like, just so you’re prepared.” But at some point I got really deep into it and lost my context. That’s

  [Read more...]
High Performance MySQL is here!
+0 Vote Up -0Vote Down

The book, that is. My dog is already studying it. You should buy a few copies for yourself, your family, and all your pets.

No Tags
What is it like to write a technical book?
+0 Vote Up -0Vote Down

As you probably know, I recently finished writing a book with a few co-authors. I kept notes along the way and wanted to describe the process for those who are thinking about writing a book, too.

Update: see the followup post for more of the story, including my editor’s responses.

I think it’s important to be objective; my purpose here is to help prospective authors get a feeling of what it’s like, and it’s not all good (but I’d encourage people to do it anyway). Hopefully I won’t come off as sounding peeved at anyone or like I’m trying to put people down. I’ll have a lot to say about what went right and wrong, and how it helped and hindered

  [Read more...]
Grab your High Performance MySQL sample content
+0 Vote Up -0Vote Down

Final versions of High Performance MySQL, Second Edition sample content are posted at the official website. You can download unrestricted PDFs of the foreword, table of contents, chapter 4 (Query Performance Optimization), and the index.

PDF, Sample Chapter
High Performance MySQL Second Edition goes to press!
+0 Vote Up -0Vote Down

Today High Performance MySQL, Second Edition went to press. I’ve been working with the production team over the last couple of weeks, proofreading and checking the index and working with the artist who re-drew the illustrations.

I spoke to the production editor this morning and she told me the schedule is for the bound-book date to be the 16th of June. The official in-stock date is June 19th. I don’t know how many copies they’re printing for the first printing. But I think there have been a lot of pre-orders (rumors I’ve heard from my Amazon Affiliate account).

I cannot wait to hold my copy in my hands!

Publishing
Official website launched for High Performance MySQL
+0 Vote Up -0Vote Down

In preparation for the book’s launch next month, I’ve created a website for it: High Performance MySQL. You may notice that the URL isn’t the same as the site for the first edition. It proved to be difficult to transfer that domain. If we accomplish it later on, I’ll set up a redirect.

Why an official site? To give you free stuff, of course. Final drafts of the front matter (TOC, preface, foreword), a sample chapter, and the index are there already. When the final quality control is done, I’ll update these. Right now they don’t have professionally drawn figures. That will change soon.

Also, you’ll eventually various things such as errata* and book-related info that I feel belongs there instead of here. You can subscribe to the site’s RSS

  [Read more...]
High Performance MySQL Second Edition Schedule
+0 Vote Up -0Vote Down

I just got the rest of the production schedule from the publisher, plus the PDF files for quality control, for our upcoming book. (Now I have to proofreeed the whole book!) This is the first time I’ve seen the entire production schedule. The book is supposed to go to the printer in the first week of June. I don’t know what the on-the-shelf date will be, but I think very shortly after that. The publisher has promised that it’ll physically be on sale at Velocity.

I also took a peek at the PDFs. Without the appendixes, the last page of Chapter 14 (Tools for High Performance)

  [Read more...]
Come to beCamp 2008
+0 Vote Up -0Vote Down

I’m going to be at beCamp 2008, the followup to the first beCamp, which I sadly missed.

beCamp is a BarCamp un-conference. Tonight was about meeting, greeting, and throwing ideas at the wall to see which ones stick. Literally. We stuck pieces of paper on the wall with our ideas — things we can either talk about or want to hear about — and then scratched our votes on them to see which are popular.

I live and breathe MySQL for a decent part of the day, so I hesitated, but then stuck “MySQL Performance” on the wall. It got quite a few votes, so I assume will be giving a talk on MySQL performance basics at some point during the conference. (The exact schedule is probably being determined right now, in my absence, but I’m so tired right now that I’ll just take my chances on it not being

  [Read more...]
Pre-Order High Performance MySQL Second Edition
+0 Vote Up -0Vote Down

If you’re waiting for High Performance MySQL Second Edition to hit the shelf, you’re not the only one. I am too! I can’t wait to actually hold it in my hands.

But you don’t have to wait idly. No, not at all! You can

  [Read more...]
Spring 2008 issue of MySQL Magazine
+0 Vote Up -0Vote Down

Keith Murphy and his hard-working crew have released the spring 2008 issue of MySQL Magazine. Go take a look — it includes quite a few articles on various topics, even a mention of our upcoming book (High Performance MySQL, Second Edition).

Keith Murphy, mysql, MySQL Magazine
Get a free sample chapter of High Performance MySQL Second Edition
+0 Vote Up -0Vote Down

If you’re at the MySQL Conference and Expo, you can get a free sample chapter of the upcoming High Performance MySQL Second Edition. Just go to the exhibition area. As you go through the doors, take an immediate left and look for the sample chapter on O’Reilly’s table. It’s a rough draft and contains typos and my incredibly crude drawings instead of those that will go into the final book, but it should serve to give you an idea of the book’s depth and scope. Kudos to Andy Oram, our editor, who was able to get these done for us on very short notice.

Andy Oram, mysqluc2008
A different angle on the MySQL Conference
+0 Vote Up -0Vote Down

There are quite a few business angles you might see only if you’re here at the conference, and you won’t get from blogs. For example, let’s take a look at the contents of the shoulder bags they hand out with your registration. (This is only a partial list.)

  • SnapLogic’s flyer gets it right: their system is compatible with “GNU Linux.” Hooray, a commercial company acknowledging the GNU operating system for what it is!
  • MySQL Enterprise’s flyer has three big bullet points: MySQL Load Balancer, MySQL Connection Manager, and MySQL Enterprise Monitor Query Analyzer. The first two look like they’re probably built on MySQL Proxy. The last has a visual explain plan feature, which according to an elevator conversation is not yet built. I’ll stop by their booth and see. As you may know,
  [Read more...]
High Performance MySQL 2nd Edition is in production
+0 Vote Up -0Vote Down

Just a quick note to say we have reached the production stage of the book project. Production is the process of transforming our OpenOffice.org files into the final page layout using a professional typesetting program.

As you can probably guess, this is later than we would have wished. This also means we won’t have the book for sale at the upcoming MySQL Conference and Expo. We will have a display copy at the O’Reilly booth at the conference, and you will be able to pre-order the book at a discount at that booth. (Several details remain to be worked out — do not trust the Amazon.com information on the book, as it is a weird blend of the first and second editions).

The book is very, very good. You will not be disappointed. I can’t think of a credible way

  [Read more...]
Henceforth, I dub thee GLAMP
+0 Vote Up -0Vote Down

I've decided to start replacing L with GL in acronyms where L supposedly stands for Linux.

I'm not a big user of acronyms, because I think they are exclusionist and they obscure, rather than revealing. (This wouldn't matter if I wrote for people who already knew what I meant and agreed with me, but that's a waste of time). However, LAMP is one that I've probably used a few times, without thinking that it is supposed to stand for Linux, Apache, MySQL, and PHP/Perl/Python. In fact, it doesn't refer to Linux, it refers to GNU/Linux. Therefore, it should be GLAMP.

Why does this matter? I try not to say Linux, unless I'm referring to a kernel, because a kernel is not an operating system. I try to be pretty careful about saying GNU/Linux when I'm talking about an operating system. An

  [Read more...]
How pre-fetching relay logs speeds up MySQL replication slaves
+0 Vote Up -0Vote Down

I dashed off a hasty post about speeding up replication slaves, and gave no references or explanation. That's what happens when I write quickly! This post explains what the heck I was talking about.

More progress on High Performance MySQL, Second Edition
+0 Vote Up -0Vote Down

Whew! I just finished a marathon of revisions. It's been a while since I posted about our progress, so here's an update for the curious readers.

Showing entries 1 to 30 of 46 Next 16 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.