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

MySQL 5.5 and MySQL 5.6 default variable values differences

 | February 21, 2013 |  Posted In: Insight for DBAs, MySQL

As the part of analyzing surprising MySQL 5.5 vs MySQL 5.6 performance results I’ve been looking at changes to default variable values. To do that I’ve loaded the values from MySQL 5.5.30 and MySQL 5.6.10 to the different tables and ran the query:

Lets go over to see what are the most important changes […]

Read More