Errata

High Performance MySQL

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