EmergencyEMERGENCY? Get 24/7 Help Now!

TIMESTAMP Columns, Amazon RDS 5.6, and You

 | July 8, 2014 |  Posted In: Cloud and MySQL, Cloud and NoSQL, Insight for DBAs, Insight for Developers, MySQL

This comes from an issue that I worked on recently, wherein a customer reported that their application was working fine under stock MySQL 5.6 but producing erroneous results when they tried running it on Amazon RDS 5.6. They had a table which, on the working server, contained two TIMESTAMP columns, one which defaulted to CURRENT_TIMESTAMP […]

Read More

The small improvements of MySQL 5.6: Duplicate Index Detection

 | May 31, 2013 |  Posted In: Insight for DBAs, MySQL, Percona Toolkit

Here at the MySQL Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based replication, InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL and several other InnoDB and query optimizer improvements. However, I plan to focus on a series of posts on the small but handy improvements – […]

Read More