Errata

Print Print Icon

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 "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



Version Location Description Submitted By 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 
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  Dec 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 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 
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  Aug 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  Aug 2008
Printed Page 292
4th full paragraph

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

 Anonymous  Dec 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  Dec 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 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  Dec 2008

"This is a good book that is well worth the cost. While it is not a newbie book, there is plenty here for novice and expert alike. I can pretty much guarantee that if you work with, or want to work with, MySQL, you will get some value from it."
--Lewis Cunningham, MySQL Database News