High Performance MySQL
by Jeremy Zawodny and Derek J. Balling

This errata page lists errors corrected in the most recent printing.

If you have technical questions or error reports, you can send them to
booktech@oreilly.com.  Please specify the printing date of your copy.

This page was updated August 7, 2007.

Here's a key to the markup:
	[page-number]: serious technical mistake
	{page-number}: minor technical mistake
	<page-number>: important language/formatting problem
	(page-number): language change or minor formatting problem
	?page-number?: reader question or request for clarification



Confirmed errors:


(xv)  3rd paragraph;
"and for handeling XML grunt work, Chapter 10 Appendix C, and all"

missing comma between Chapter 10 and Appendix C


(3)  2nd paragraph;
'Finally, you can downloaded' should be 'Finally, you can download'


(3)  2nd paragraph;
The word "nstall" in the second line should be "install".


(5)  2nd paragraph-like section;
There's an extra space before the period: "global configuration file ."


[7] 2nd to last paragraph, first sentence;
To use a sample file, simply copy it to /etc/my.cnf (or systemdir\win.ini on Windows) and...
should be:
To use a sample file, simply copy it to /etc/my.cnf (or systemdir\my.ini on Windows) and...


(22)  Table 2-1;
Under "locking strategy", the line 
"Table socks" 
should be 
"Table locks"


(22)  2nd paragraph;
"bank's database with a two tables: checking and savings" 
should be
"bank's database with two tables: checking and savings"


(26)  2nd paragraph;
It says: "Table 2-2 summarizes the various isolation levels...",
but it should be "Table 2-4 ...".


(39)  6th Paragraph (third line from page bottom);
"If you're have"
should be
"If you have"


(43) 2nd paragraph following "Locking and concurrency"
"In an InnoDB transaction, You"
should be
"In an InnoDB transaction, you"


(44) First line:
"InnoDB doesn't allow you to insert add records"
should be either insert or add


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


(69)  1st paragraph;
"Range-base queries" should be "Range-based queries"


(72)  3rd paragraph;
There should be a colon after "relatively unknown features"


{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')


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


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


(98)  2nd paragraph;
"this hint has no affect"  should be effect


(108)  2nd to last paragraph of 'buying Server Hardware' Section;
'building a singer server' should be 'building a single server'


(p127)  Footnote;
"spare time of handful of yahoo's..."
s/b
"spare time of a handful of yahoo's..."


(135)  SHOW GRANTS screen;
the SQL output doesn't appear to line up.


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

(177)  3rd paragraph, end of first sentence;
Mispelled 'servers' as 'severs'.


(177)  End of 3rd paragraph;
Unecessary inclusion of 'se' right before the word 'servers'.

"...that the se servers are configured..."


(189)  3rd paragraph, end of second sentence;
'that' should be 'than'

"...more complex that you might think."


(248)  1st paragraph, 5th line;
useful it the tool felt
should read:
useful if the tool felt