Skip to main content

MySQL for Developers Screencast and Slides

Posted by caroljmcdonald on March 18, 2009 at 10:31 PM PDT


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


You can read more about this at

for Developers

and MySQL, Part 4: Creating a RESTful Web Service and JavaFX Client

High Performance
MySQL book

MySQL Pluggable
Storage Engine Architecture

Storage Engine Architecture, Part 2: An In-Depth Look

Queries with EXPLAIN

Java Persistence with
Hibernate book

Jay Pipes blog  style="text-decoration: underline;">

Colin Charles blog

mysql performance blog

Ronald Bradford blog

JPA for a Test Drive

Pro EJB 3: Java
Persistence API

MySQL, Chapter 6: Benchmarking and Profiling

Related Topics >>


Nice, good stuff :)