I would like to read a book about MySQL database with emphasis on performance and optimization on Linux server. I appreciate your suggestions.
I actually answered a question like this on July 9, 2011
Let me expand on this answer:
When it comes to MySQL, the must have book is the MySQL 5.0 Certification Study Guide. I have studied this book with a fine-toothed comb. At the time I bought the book, there was an errata page (list of typos in the book) provided my MySQL (the original MySQL, pre-Oracle, pre-Sun).
It forms a very good base for learning MySQL. However, to keep things in persepctive, let me tell you my experience using the book.
I actually purchased the book in September 2006 along with MySQL Stored Procedure Programming and starting using it for everything tasks as a first year MySQL 5.0 DBA (I already had 2 years with MySQL 4.0 as Developer/DBA). After 10 months, I took the exams July 28, 2007 and August 11, 2007. I passed both exams on the first try because of two things: (1) Thorough study of the book and (2) practical experience.
Nothing can substitute for actual usage of MySQL. After proper due diligence and logging enough miles in MySQL, then this book will definitely help you get certified.
Other books will enlighten you further
- MySQL Administrator's Guide and Language Reference
- MySQL Database Design and Tuning
- High Performance MySQL
- Understanding MySQL Internals
- MySQL High Availability
BTW Yes, I do own all these books. I have read them and still use them !!!