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


http://mediacast.sun.com/users/caroljmcdonald/media/mysqlproj.swf

You can download the slides here
https://techdayscode.dev.java.net/servlets/ProjectDocumentList?fold...

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

Views: 48

Comment

You need to be a member of Codetown to add comments!

Join Codetown

Happy 10th year, JCertif!

Notes

Welcome to Codetown!

Codetown is a social network. It's got blogs, forums, groups, personal pages and more! You might think of Codetown as a funky camper van with lots of compartments for your stuff and a great multimedia system, too! Best of all, Codetown has room for all of your friends.

When you create a profile for yourself you get a personal page automatically. That's where you can be creative and do your own thing. People who want to get to know you will click on your name or picture and…
Continue

Created by Michael Levin Dec 18, 2008 at 6:56pm. Last updated by Michael Levin May 4, 2018.

Looking for Jobs or Staff?

Check out the Codetown Jobs group.

 

Enjoy the site? Support Codetown with your donation.



InfoQ Reading List

IBM Releases Granite-Docling-258M, a Compact Vision-Language Model for Precise Document Conversion

IBM Research has recently introduced Granite-Docling-258M, a new open-source vision-language model (VLM) designed for high-fidelity document-to-text conversion while preserving complex layouts, tables, equations, and lists.

By Robert Krzaczyński

11 Sessions Not to Miss at QCon San Francisco 2025

As QCon San Francisco (Nov 17-21, 2025) approaches, the conference's program committee and track hosts are sharing their top picks from this year's lineup. Their selections span a wide range of topics, from AI-accelerated development and platform engineering to resilience patterns and career growth, all with QCon's signature focus on real-world case studies and lessons learned.

By Artenisa Chatziou

Presentation: Building Distributed Event-Driven Architectures Across Multi-Cloud Boundaries

Teena Idnani explains how to architect and build resilient event-driven distributed systems in a multi-cloud reality. Using a fictional bank's migration journey, she shares practical, code-level solutions for overcoming major challenges: managing cross-cloud latency, ensuring event ordering and consistency, building resilience by design, and preventing duplicate events.

By Teena Idnani

GitHub Adds Post-Quantum Secure SSH Key Exchange to Protect Git Data in Transit

GitHub is introducing a hybrid post-quantum secure key exchange algorithm for SSH access when interacting with Git over SSH.

By Craig Risi

Meta Ships React 19.2 Featuring Activity API, Cache Signals, and SSR Enhancements

React 19.2 introduces new APIs and performance improvements focused on better UI control and server rendering. Key additions include the new Activity component for managing UI states without losing component state, and the useEffectEvent hook, which separates event logic from effect dependencies.

By Daniel Curtis

© 2025   Created by Michael Levin.   Powered by

Badges  |  Report an Issue  |  Terms of Service