Comments on: MySQL 5.7 key features

By: Felice Cutruzzula

Felice Cutruzzula — Tue, 05 Jan 2016 19:11:58 +0000

Is there a projected release date of Percona XtraBackup support for MySQL 5.7?

By: tom60

tom60 — Mon, 02 Nov 2015 15:41:46 +0000

For now a big disadvantage is that Percona Xtrabackup doesn’t support MySQL 5.7 yet.

By: Jonatas

Jonatas — Wed, 24 Jun 2015 00:33:34 +0000

Thanks! That was a very nice summary!

By: Bhola

Bhola — Sat, 20 Jun 2015 06:55:47 +0000

I have been using MySQL since three years and its one of the best features are that its multi-platform and very easy to manage and setup.
Thanks for providing the Key features of this nice DB Platform.

By: Ian W

Ian W — Fri, 29 May 2015 14:10:31 +0000

Any idea on when it’ll launch as a Percona 5.7 once the MySQL version goes live?

By: Mark Callaghan

Mark Callaghan — Wed, 27 May 2015 16:12:06 +0000

In reply to Morgan Tocker. I hoped that Oracle would have results by now especially given the problems described in the post by Domas

By: trimurthy

trimurthy — Wed, 27 May 2015 15:19:48 +0000

Good post Muhammad.

And show grants for a particular user doesn’t show the password hash key any more and the mysql.user table structure has been changed, dropped the password column and changed it as authentication_string.

sys schema comes default with the instance installation now.

Thank you,
Trimurthy

By: Morgan Tocker

Morgan Tocker — Wed, 27 May 2015 15:15:56 +0000

@Mark: It is in 5.7.8 (not yet released):
https://dev.mysql.com/doc/refman/5.7/en/innodb-page-compression.html

I’m looking forward to seeing benchmark results when it’s out.

By: Mark Callaghan

Mark Callaghan — Wed, 27 May 2015 13:16:12 +0000

Has anyone done a long running test on a realistic workload to show that punchhole compression doesn’t kill performance? See http://dom.as/2015/04/09/how-innodb-lost-its-advantage/

By: Morgan Tocker

Morgan Tocker — Wed, 27 May 2015 12:46:23 +0000

A few to add:

– I have a feeling that the new query hints + query rewrite features will be something we don’t know how we lived without.
– InnoDB supports tablespaces, undo truncation and punch hole compression. Barracuda is now the default row format.
– The optimizer cost model has been improved.
– The optimizer also better handles derived tables in the from clause, and uses less memory to sort variable length data.
– The performance of semi-sync replication has greatly improved.

By: Abdel-Mawla Gharieb

Abdel-Mawla Gharieb — Wed, 27 May 2015 10:49:44 +0000

Nice summary Muhammad.
Also – in my opinion – one of the important enhancements in 5.7 is creating the implicit or internal on-desk temporary tables using InnoDB SE instead of MyISAM by setting the variable:
internal_tmp_disk_storage_engine=InnoDB

https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_internal_tmp_disk_storage_engine