I'm a web developer looking to improve my MySQL skillset. Basic CRUD, joins, etc are all pretty par for the course; I'm looking to learn more about efficiency, avoiding bottlenecks, optimizing queries, and lots more awesome stuff that I don't know the words to explain.
+2
A:
If you're looking for performance related things and getting down into the nitty gritty on the storage engines, optimizer, etc, High Performance MySQL 2nd Edition is the way to go.
http://oreilly.com/catalog/9780596101718/?CMP=AFC-ak_book&ATT=High+Performance+MySQL
Grant Limberg
2008-10-21 03:12:16
A:
CMS
2008-10-21 04:11:06
+1
A:
Here are the SQL books on my bookshelf:
- SQL for Smarties, Joe Celko
- SQL Programming Style, Joe Celko
- SQL Performance Tuning, Peter Gulutzan and Trudy Pelzer
- SQL-99 Complete, Really, Peter Gulutzan and Trudy Pelzer
Bill Karwin
2008-10-21 06:13:35
Thanks! I'll hop over to Amazon now and check this out.
ironkeith
2008-10-21 20:17:31
I have to second this recommendation of Pro Mysql (I even try to market this book on my blog). Apart from being extremely useful, I found this book very readable. Another new book that is getting reviews is the MySql Administrators Bible.
DBMarcos99
2009-08-06 14:49:40
Yada
2009-11-26 20:48:18