Tag - MySQL 5.7

Upgrading to MySQL 5.7? Beware of the new STRICT mode

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
SQL_MODE to
NO_ENGINE_SUBSTITUTION (same as in MySQL 5.6):

MySQL

mysql> set global SQL_MODE=”NO_ENGINE_SUBSTITUTION”;

1

mysql> set global SQL_MODE=”NO_ENGINE_SUBSTITUTION”;

MySQL 5.7, dates and default values
The default
SQL_MODE in […]

Read more

MySQL 5.7 Performance Tuning After Installation

MySQL 5.7 Performance Tuning

This blog updates Stephane Combaudon’s blog on MySQL performance tuning and covers MySQL 5.7 performance tuning immediately after installation.
A few years ago, Stephane Combaudon wrote a blog post on Ten MySQL performance tuning settings after installation that covers the (now) older versions of MySQL: 5.1, 5.5 and 5.6. In this post, I will look into […]

Read more

Severe performance regression in MySQL 5.7 crash recovery

MySQL 5.7 Crash Recovery

In this post, we’ll discuss some insight I’ve gained regarding severe performance regression in MySQL 5.7 crash recovery.
Working on different InnoDB log file sizes in my previous post:
What is a big innodb_log_file_size?

I tried to understand how we can make InnoDB crash recovery faster, but found a rather surprising 5.7 crash recovery regression.
Basically, crash recovery in […]

Read more

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

binary logs make MySQL 5.7 slower

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 threads, SSD, Centos 7.2.1511
mysql-5.6.30-linux-glibc2.5-x86_64
mysql-5.7.12-linux-glibc2.5-x86_64
mysqld –options:

–no-defaults –log-bin=mysql-bin –server-id=2
Run details:
Sysbench version 0.5, 4 threads, socket file connection
Sysbench Prepare: 

Shell

sysbench –test=/usr/share/doc/sysbench/tests/db/parallel_prepare.lua –oltp-auto-inc=off –mysql-engine-trx=yes –mysql-table-engine=innodb –oltp_table_size=1000000 […]

Read more

Percona XtraBackup 2.4.3 is now available

Percona XtraBackup 2.4.3

Percona is glad to announce the GA release of Percona XtraBackup 2.4.3 on May 23rd, 2016. Downloads are available from our download site and from apt and yum repositories.
Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods […]

Read more