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.
| Version |
Location |
Description |
Submitted By |
Date Submitted |
Date Corrected |
| Printed |
Page xvi
1st paragraph after "From Derek" |
"My grandparents...., as she...."
NOW READS:
"My grandparents...., as they...."
|
Anonymous |
|
May 01, 2004 |
| Printed |
Page xv
3rd paragraph |
"and for handeling XML grunt work, Chapter 10 Appendix C, and all"
missing comma between Chapter 10 and Appendix C
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page p127
Footnote |
"spare time of handful of yahoo's..."
s/b
"spare time of a handful of yahoo's..."
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 3
2nd paragraph |
'Finally, you can downloaded' should be 'Finally, you can download'
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 3
2nd paragraph |
The word "nstall" in the second line should be "install".
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 5
2nd paragraph-like section |
There's an extra space before the period: "global configuration file ."
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 7
2nd to last paragraph, first sentence |
To use a sample file, simply copy it to /etc/my.cnf (or systemdirwin.ini on Windows) and...
should be:
To use a sample file, simply copy it to /etc/my.cnf (or systemdirmy.ini on Windows) and...
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 22
Table 2-1 |
Under "locking strategy", the line
"Table socks"
should be
"Table locks"
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 22
2nd paragraph |
"bank's database with a two tables: checking and savings"
should be
"bank's database with two tables: checking and savings"
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 26
2nd paragraph |
It says: "Table 2-2 summarizes the various isolation levels...",
but it should be "Table 2-4 ...".
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 39
6th Paragraph (third line from page bottom) |
"If you're have"
should be
"If you have"
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 43
2nd paragraph following "Locking and concurrency" |
"In an InnoDB transaction, You"
should be
"In an InnoDB transaction, you"
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 44
First line |
"InnoDB doesn't allow you to insert add records"
should be either insert or add
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 49
2nd paragraph following "The MySQL Benchmark Suite" |
"individually if you'd like compare a subset"
should be
"individually if you'd like to compare a subset"
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 69
1st paragraph |
"Range-base queries" should be "Range-based queries"
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 72
5th Paragraph, code line following |
PACKED_KEY = 1
NOW READS:
PACK_KEYS = 1
|
Anonymous |
|
Aug 01, 2004 |
| Printed |
Page 72
3rd paragraph |
There should be a colon after "relatively unknown features"
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 74
bottom page, last SQL statement |
The SQL statement:
select * from articles (body) match against ('database')
is incorrect. It should read:
select * from articles where match (body) against ('database')
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 87
3rd command |
Example is introduced as
"use a subquery to fetch a URL for the highest numbered headline?"
Mysql> EXPLAIN SELECT url
"After waiting five minutes, we killed the query." text continues leading to next example and states:
"lets explain it.."
mysql> EXPLAIN SELECT url.......
The first example command should not have the EXPLAIN command.
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 98
1st paragraph of section "Two Is Better Than One" |
"There are two tables involved: SymbolHistory and Symbols."
should be:
"There are two tables involved: PriceHistory and Symbols."
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 98
2nd paragraph |
"this hint has no affect" should be effect
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 108
2nd to last paragraph of 'buying Server Hardware' Section |
'building a singer server' should be 'building a single server'
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 135
SHOW GRANTS screen |
the SQL output doesn't appear to line up.
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 145
1st paragraph |
"20 slaves, which each need to pull an average of 500KB per second,
that's a total of 10,000KB/sec (or nearly 10 Mbits/sec) of bandwidth"
NOW READS:
"20 slaves, which each need to pull an average of 50KB per second,
that's a total of 1,000KB/sec (or nearly 10Mbits/sec) of bandwidth"
|
Anonymous |
|
Aug 01, 2004 |
| Printed |
Page 150
3rd paragraph |
In the following paragraph:
The two most important fields are Slave_IO_Running and
Slave_SQL_Running. They tell you if the IO and slave threads
are running.
The portion "IO and slave threads" should be "IO and SQL threads",
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 153
Tools section above "mysqlbinlog: Viewing data in logs" |
URL: http://highperformancemysql.com
The web page may still be in the process of being reconstructed.
|
Anonymous |
|
|
| Printed |
Page 177
3rd paragraph, end of first sentence |
Mispelled 'servers' as 'severs'.
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 177
End of 3rd paragraph |
Unecessary inclusion of 'se' right before the word 'servers'.
"...that the se servers are configured..."
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 189
3rd paragraph, end of second sentence |
'that' should be 'than'
"...more complex that you might think."
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 248
1st paragraph and 2nd paragraph |
Version 1.5 NOW READS Version 1.4
|
Anonymous |
|
Aug 01, 2004 |
| Printed |
Page 248
1st paragraph, 5th line |
useful it the tool felt
should read:
useful if the tool felt
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 253
1st and 2nd paragraphs |
5 references to mytop-1.5 NOW READ mytop-1.4
|
Anonymous |
|
Aug 01, 2004 |
