As of February, the latest GA version of MySQL is 5.6.10. There are a few nice features in this version and we should consider upgrading to it. The main consideration for NOT upgrading is that the hosting sites we might choose may not have this version to offer. Here are the versions of MySQL that some hosting sites offer at the moment.
Go Daddy: MySQL 5.0
Dreamhost: MySQL 5.0 ("contact support to upgrade")
Amazon RDS: MySQL 5.5.8 (5.5.27 is the default, many other older versions available)
The main things that could impact us are the limitation of 1 TIMESTAMP column with a CURENT_TIMESTAMP DEFAULT value. In addition to Time/Date imporovements, MySQL is claiming a significant performance improvement. Here is a feature set of 5.6:
As of February, the latest GA version of MySQL is 5.6.10. There are a few nice features in this version and we should consider upgrading to it. The main consideration for NOT upgrading is that the hosting sites we might choose may not have this version to offer. Here are the versions of MySQL that some hosting sites offer at the moment.
The main things that could impact us are the limitation of 1 TIMESTAMP column with a CURENT_TIMESTAMP DEFAULT value. In addition to Time/Date imporovements, MySQL is claiming a significant performance improvement. Here is a feature set of 5.6: