Errata for High Performance MySQL
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 |
| Safari Books Online |
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 |
|
| |
