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

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

AWS Introduces Open Source Model Context Protocol Servers for ECS, EKS, and Serverless

AWS has launched open-source Model Context Protocol (MCP) servers on GitHub to supercharge AI development within Amazon ECS, EKS, and Serverless environments. These specialized tools equip developers with real-time, context-specific insights, enhancing application deployment, troubleshooting, and operational efficiency. Empower your cloud experience today!

By Steef-Jan Wiggers

Podcast: Using AI Code Generation to Migrate 20000 Tests

In this podcast, Shane Hastie, Lead Editor for Culture & Methods spoke to Sergii Gorbachov, a staff engineer at Slack, about how they successfully used AI combined with traditional coding approaches to migrate 20,000 tests in 10 months, discovering that AI alone was insufficient and required human oversight and conventional tools to work effectively.

By Sergii Gorbachov

.NET Aspire 9.3 Brings GitHub Copilot Integration and Expanded Azure Support

The .NET team has released version 9.3 of .NET Aspire, introducing updates across diagnostics, integrations, and deployment workflows. As stated in the official announcement, this release aims to improve the developer experience by integrating GitHub Copilot into the Aspire dashboard, expanding tracing capabilities, and simplifying Azure deployments.

By Almir Vuk

GitLab Adds AI Code Assistance with Self-Hosted GitLab 18 Release

GitLab has released version 18.0 of its DevSecOps platform, introducing more AI features across the Premium and Ultimate tiers. The release includes AI-native development workflows, aligning GitLab with competitors like Microsoft's GitHub Copilot and other AI-assisted coding platforms.

By Matt Saunders

Flux 2.6 GA Release and Security Advancements

The Flux project announced the availability of Flux v2.6.0. This version marks the General Availability (GA) of the Flux Open Container Initiative (OCI) Artifacts features, representing a fundamental shift in how organizations approach GitOps.

By Claudio Masolo

© 2025   Created by Michael Levin.   Powered by

Badges  |  Report an Issue  |  Terms of Service