Note: This post is part 2 of 4 on building
our training workshop.
Last week I talked about why you don't want to shard. This week I'm following up with the top 10 enhancements that XtraDB has over the built-in InnoDB included in MySQL 5.0 and 5.1. Building this list was not really a scientific process - It's always difficult to say which feature is better than another, because a lot of it depends on the individual workload. My ranking method was to pick the features that have the highest impact and are most applicable to all workloads first:
- CPU scalability fixes - XtraDB improves performance on systems with multi-cpus (see docs …