Post Profile






Upgrading to MySQL 5.7? Beware of the new STRICT mode

This blog post discusses the ramifications of STRICT mode in MySQL 5.7. In short By default, MySQL 5.7 is much “stricter” than older versions of MySQL. That can make your application fail. To temporarily fix this, change the [crayon-5806b85f22752219823635-i/] to [crayon-5806b85f22764623423250-i/] (same as in MySQL 5.6): [crayon-5806b85f2276d334838521/] MySQL 5.7, dates and default values The default [crayon-5806b85f22775852154130-i/] in MySQL 5.
read more

share

Related Posts


MySQL 5.7 By Default 1/3rd Slower Than 5.6 When Using Binary Logs

Programming / Database Development : MySQL Performance Blog

Researching a performance issue, we came to a startling discovery: MySQL 5.7 + binlogs is by default 37-45% slower than MySQL 5.6 + binlogs when otherwise using the default MySQL settings Test server MySQL versions used: i7, 8 threa...

Review of MySQL 5.6 Defaults Changes

Programming / Database Development : MySQL Performance Blog

James Day just posted the great summary of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general there are a lot of good changes and many defaults are now computed instead of hardcoded. Though some of changes are rather puz...

Upgrading to MySQL 5.7, focusing on temporal types

Programming / Database Development : MySQL Performance Blog

In this post, we’ll discuss how MySQL 5.7 handles the old temporal types during an upgrade. MySQL changed the temporal types in MySQL 5.6.4, and it introduced a new feature: microseconds resolution in the TIME, TIMESTAMP...

Percona Server 5.6.33-79.0 is now available

Programming / Database Development : MySQL Performance Blog

Percona announces the release of Percona Server 5.6.33-79.0 on October 18th, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.6.33, including all the bug fixes in it,...

MySQL Default Configuration Changes between 5.6 and 5.7

Programming / Database Development : MySQL Performance Blog

In this blog post, we’ll discuss the MySQL default configuration changes between 5.6 and 5.7. MySQL 5.7 has added a variety of new features that might excite you. However, there are also changes in the current variables that you mig...

Comments


Copyright © 2016 Regator, LLC