Session
MySQL Performance Under a Microscope
Tobias Asplund, Instructor and Performance Tuning Consultant, MySQL AB
Jay Pipes, Community Relations Manager, North America, MySQL AB
Track: Performance Tuning and Benchmarks
Date: Wednesday, April 25
Time: 2:30pm
- 3:15pm
Location: Ballroom E
This talk is about all those little things that you may have wondered about, but never had time to research. This is not a session about the big things, we're looking at things at a component level, and trying to find low-level best practices for query writing and database design using micro benchmarks.
Is it faster to use a trigger to update a last-changed column instead of a time-stamp datatype?
How much faster is a binary search compared to a collation-sensitive?
Is it faster to search if the column I'm retrieving is at the start of the table compared to the end?
Is there a speed difference when using compressed tables or compressed indexes for specific types of searches?
Ever wondered about any of those things? We'll take a look at this and some of the smaller things in this session.