Codetown
Codetown ::: a software developer's community
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
Comment
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.
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.
InfoQ Reading List
MCP C# SDK Aligns with New Protocol Specification, Bringing Security and Tooling Updates
The Model Context Protocol (MCP) C# SDK has been updated to support the latest specification, version 2025-06-18. As reported, this release introduces several new features for .NET developers working on AI applications, including an updated authentication protocol, elicitation support, structured tool output, and resource links in tool responses.
By Almir VukOpenAI's GPT-5 Now Generally Available on Microsoft Azure AI Foundry
Microsoft and OpenAI launched GPT-5 on the Azure AI Foundry, revolutionizing enterprise AI with its advanced reasoning and task-specific model orchestration. This suite enhances applications like Microsoft 365 Copilot and GitHub Copilot, enabling seamless interactions and high-quality outputs tailored for real-world scenarios. GPT-5 empowers organizations to drive AI transformation efficiently.
By Steef-Jan WiggersPresentation: Timeouts, Retries and Idempotency In Distributed Systems
Sam Newman discusses the three golden rules of distributed computing and how they necessitate robust handling of timeouts, retries, and idempotency. He provides practical, data-driven strategies for implementing these principles, including using request IDs and server-side fingerprinting to create safe, resilient distributed systems.
By Sam NewmanPresentation: Supporting Engineering Productivity for All
Emerson Murphy-Hill explains how to prioritize investments in engineering productivity using data from Google, National Instruments, and ABB. He discusses a ranked list of productivity drivers, the impact of biases in code reviews and documentation, and the practices of exceptionally diverse and inclusive engineering teams.
By Emerson Murphy-HillClaude Code Subagents Enable Modular AI Workflows with Isolated Context
Anthropic has recently made Claude Code Subagents generally available, enabling developers to create independent, task-specific AI agents with their own context, tools, and prompts.
By Hien Luu
© 2025 Created by Michael Levin.
Powered by
You need to be a member of Codetown to add comments!
Join Codetown