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: 49

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

Mini book: Architecture Through Different Lenses 2025

This eMag explores architecture through five distinct lenses: the socio-technical forces that invisibly shape our code, the paradox of infrastructure that succeeds by disappearing, the power of distributed intelligence over centralized control, the evolutionary advantage of iteration over revolution, and the pragmatic reality of designing for inevitable complexity.

By InfoQ

Podcast: Bridging the Open Source Gap: From Funding Paradoxes to Digital Sovereignty

Gabriele Columbro, managing director of the Linux Foundation Europe, discusses the differences in the open-source landscape between Europe, China and the US. Stressing that the open-source landscape is the last favorable ground for global innovation in the current geo-political landscape.

By Gabriele Columbro

BellSoft Unveils Hardened Java Images

BellSoft has launched Hardened Images for Java containers, claiming 95% fewer CVEs and 30% resource savings. Built on Alpaquita Linux, the 3-in-1 solution combines runtime optimisation, OS hardening, and CVE remediation. It offers a secure, flexible alternative to Chainguard and Distroless, available now in three tiers.

By Mark Silvester

Java News Roundup: JDK 26 in Rampdown, JDK 27 Expert Group, GlassFish, TornadoVM, Spring gRPC

This week's Java roundup for December 1st, 2025, features news highlighting: JDK 26 in Rampdown Phase One; the formation of the JDK 27 Expert Group; GA releases of TornadoVM 2.0 and Spring gRPC 1.0; a point release of GlassFish 7.1; the December 2025 edition of Open Liberty; the first beta release of JHipster 9.0 and the second release candidate of Hibernate Search 8.2.

By Michael Redlich

AWS CodeCommit Returns to General Availability After Backlash

AWS recently announced that the managed source control service AWS CodeCommit is again generally available and that new features, including Git Large File Storage, will be added early in 2026. This marks a shift for the cloud provider that previously announced the service would not be further developed, closed it to new accounts, and encouraged migration to external alternative services.

By Renato Losio

© 2025   Created by Michael Levin.   Powered by

Badges  |  Report an Issue  |  Terms of Service