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
Uber Improves Restaurant Recommendations Using Real-Time Signals and Listwise Ranking
Uber updates its Uber Eats Home Feed recommendation system using near real-time user sequence features and a Generative Recommender model. The system evolves from hand-crafted features to transformer-based sequence modeling, reduces feature freshness from 24 hours to seconds, and shifts from pointwise scoring to listwise GenRec for improved contextual ranking and real-time personalization.
By Leela KumiliInfoQ Launches Online AI Engineering Cohort and Certification for Senior Software Practitioners
InfoQ has launched a five-week online AI Engineering certification for senior practitioners working on production AI systems, covering RAG, agents, AI platforms, evals, reliability, and operational trade-offs.
By Artenisa ChatziouDiscord Rebuilds Database Operations Around Automation to Manage ScyllaDB at Massive Scale
Discord has detailed how it rebuilt its database operations around a new internal orchestration framework called the Scylla Control Plane (SCP), enabling its small infrastructure team to automate large-scale ScyllaDB cluster management tasks that previously took days of manual work.
By Craig RisixAI Releases Grok Skills and Updates Tool Calling Responses API
xAI has released Grok Skills together with enhancements to the Responses API for Grok 4.3, enabling persistent custom expertise that the model retains across all conversations.
By Daniel DominguezCloudflare Completes Its Agent Infrastructure Stack with Browser Run Rebuild and Six-Layer Platform
Cloudflare rebuilt Browser Run on its own Containers platform, delivering 4x higher concurrency and 50% faster response times. The upgrade completes a six-layer agent infrastructure stack: compute (Dynamic Workers + Sandboxes), orchestration (Dynamic Workflows), memory (Agent Memory), browsing (Browser Run), and commerce (Stripe Projects).
By Steef-Jan Wiggers
© 2026 Created by Michael Levin.
Powered by
You need to be a member of Codetown to add comments!
Join Codetown