Here is a screencast about MySQL for Developers
If you are a developer using MySQL, you should learn enough to take advantage of its strengths, because having an understanding of the database can help you develop better-performing applications. This session will talk about MySQL database design and SQL tuning for developers. Some topics include:
- MySQL Storage Engine Architecture
- Schema, the basic foundation of performance
- Think about performance when choosing Data Types
- Indexes and SQL tuning
- Understanding SQL Statements using EXPLAIN
- Scans and seeks
- Solving performance problems in your queries
- A Few Things to consider for JPA/Hibernate devlopers, Lazy loading and Optimistic locking
You can download the slides here
https://techdayscode.dev.java.net/servlets/ProjectDocumentList?folderID=9890
You can read more about this at
MySQL for Developers
GlassFish and MySQL, Part 4: Creating a RESTful Web Service and JavaFX Client
High Performance MySQL book
MySQL Pluggable Storage Engine Architecture
MySQL Storage Engine Architecture, Part 2: An In-Depth Look
Optimizing Queries with EXPLAIN
Java Persistence with Hibernate book
Jay Pipes blog
Colin Charles blog
mysql performance blog
Ronald Bradford blog
Taking JPA for a Test Drive
Pro EJB 3: Java Persistence API
Pro MySQL, Chapter 6: Benchmarking and Profiling