Errata

High Performance MySQL

Errata for High Performance MySQL, Second Edition

Submit your own errata for this product.

The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted By Date submitted Date corrected
6.3.2.3
6.3.2.3. The InnoDB tablespace, paragraph 10ish

"InnoDB stores the old versions in the tablespace, so the it"

should read:

"InnoDB stores the old versions in the tablespace, so it"

Note from the Author or Editor:
Right. This is already fixed in the second printing.

 Anonymous  Aug 05, 2008 
Printed
Page 48
first code snippet

"The following command runs the random read/write access file I/O benchmark:

$ sysbench --test=fileio --file-total-size=150G --file-test-mode=rndwr --init-rnd=on --max-time=300 --max-requests=0 run"

The --init-rnd option is not recognized by sysbench v0.4.8 on FC7, compiled from source.

It should be "--init-rng=on" instead.

Note from the Author or Editor:

* Note from reprints coordinator this is actually on page 47 in latest printing.

 Anonymous  Jul 22, 2008  Dec 01, 2008
Printed
Page 116
Figure 3.9, right-hand pane title

"MyISAM (non-lustered) table layout
should read
"MyISAM (non-clustered) table layout"

Note from the Author or Editor:
This should be fixed in the second printing already.

 Anonymous  Aug 12, 2008  Aug 01, 2008
Printed
Page 121
Paragraph 5 onwards

It would be much easier to follow the example if the create table statement was shown, since the "products" is not part of the sakila database. (at least not in the latest one on http://dev.mysql.com/doc/)

Note from the Author or Editor:
This is a valid complaint. I never got the CREATE TABLE statement from Vadim and Peter. I think it was a custom data set they created for some benchmarks. But I don't think this should be changed. I'll try to address it on my website and on the book's website.

 Anonymous  Aug 12, 2008 
Printed
Page 140
Last paragraph

The description of the subsequent query is incorrect. It says "... view the last 10 messages from each of the premium users." Since there's no "group by" in the query, it will actually return the last 10 messages by any premium user. In other words, if there are 5 premium users, the query returns up to 10 records, not up to 50 records.

Note from the Author or Editor:
Strike "from each of" in the last paragraph. This is fixed in the second printing already.

* Note from reprints coordinator - this is fixed in the [08/08] printing of the second edition.

 Anonymous  Jun 28, 2008  Aug 01, 2008
Printed
Page 292
4th full paragraph

Change
"so the it continues to grow"
to
"so it continues to grow"

Note from the Author or Editor:
* Note from reprints coordinator - this is fixed in the [08/08] printing of the second edition.

 Anonymous  Jul 01, 2008  Aug 01, 2008
Printed
Page 292
4th full paragraph

Change
"so the it continues to grow"
to
"so it continues to grow"

 Anonymous    Dec 01, 2008
Printed
Page 348
note on the top of the page

This book says the replication user actually needs only the REPLICATION CLIENT privilege on the master, and REPLICATION SLAVE for monitoring. That's not right. For replication the user only needs REPLICATION SLAVE and for monitoring REPLICATION CLIENT.

See: http://dev.mysql.com/doc/refman/5.0/en/privileges-provided.html

Note from the Author or Editor:
It's true -- we got CLIENT and SLAVE backwards. The note on top of page 348 should be changed to say

The replication user actually needs only the REPLICATION SLAVE privilege on the master, and doesn't really need the REPLICATION CLIENT privilege on either server. So why... <omitted> two reasons: ... <omitted> will need the REPLICATION CLIENT privilege, and...

 Anonymous  Oct 21, 2008  Dec 01, 2008
Printed
Page 365
There is a period missing from the sentence preceding Figure 8-6.

Anonymous   
Printed
Page 370

(370) Figure 8-12 is cut off.

Anonymous    Dec 01, 2008
Printed
Page 625
Line 35 and 40 in code example

Variable $result is used but this must be $res. (Line 35 and 40)

Note from the Author or Editor:
Change $result to $res on lines 35 and 40 of the code sample.

 Anonymous  Aug 08, 2008  Dec 01, 2008