MySQL version 5.5 arrived quietly, replacing version 5.4, which was perhaps the shortest-lived release in the product’s history. To be honest, 5.5 is mostly a major “bug fixing” update aimed at resolving a number of issues, especially for those using partitioning.
We haven’t tested this new version yet, although we’ve already downloaded and installed it on a test machine. The most important thing now is to understand what has changed and whether it’s worth the risk to put it into production. Here are the main new features:
- Semi-synchronous replication (remember that MySQL replication is 100% asynchronous)
- Now you can use VAR/VARCHAR, DATE, and DATETIME types in RANGE and LIST partitions (previously only INT was allowed)
- MySQL pruning became smarter, allowing multiple parameters in the WHERE clause to retrieve rows contained in partitions
- Cache Index/Load Index is now allowed with partitions
- Maintenance commands (REPAIR/OPTIMIZE/ANALYZE) for partitions now work (there were several issues with partition maintenance)
- New: BACKUP and RESTORE TABLE commands
- New: LOAD TABLE & LOAD DATA FROM MASTER commands
- New: LOAD XML command
As I said, version 5.5 is primarily a big bug fix with some new commands and features. Once we test the version, we’ll publish the results. By the way, the “m2” suffix added at the end is quite fancy.
Visit our Blog
Learn more about databases
Learn about monitoring with advanced tools
Have questions about our services? Visit our FAQ
Want to see how we’ve helped other companies? Check out what our clients say in these testimonials!
Discover the History of HTI Tecnologia
