What would you like to see in MySQL 5.8?

By my count MySQL 5.7 added over 150 new features, and some of my favourite ones are based on community ideas and contributions:

Statement Timeout (contributed by Davi Arnaut)
Disabled Storage Engines (suggested by the community)
MySQL Command Line client Ctrl+C support fixed (bug reported by the community)
Barracuda + Dynamic row format enabled by default (change made to better support WordPress and Drupal communities)
Multiple GET_LOCK locks can be acquired per connection (Contributed by Konstantin Osipov)

With 5.7 now in RC2, it is time for us to start planning for MySQL 5.8, and we are actively seeking community input and feature requests. There are multiple ways you can leave feedback:

Via the comments here
In person: Both myself and colleagues will be at Percona Live next week, and MySQL Central at the end of October.
Via the Bugs Database: We pay close attention to bugs with a high ‘affects me’ count. If you file a feature request, please blog about it so that we can all provide input 🙂
Via email

Thank you!

Published by

morgo

I joined MySQL AB in 2006, left, and am now back at Oracle working on the MySQL team. I’ve also worked at Percona and InPowered.

View all posts by morgo

ymmt2005

I will much appreciate if 5.8 have 128bit integer types as well as INET_NTOP & INET_PTON functions.
They are useful to store IPv6 addresses.
- Morgan Tocker
  
  Great suggestion, thank you!
- Daniël van Eeden
  
  Like https://dev.mysql.com/doc/refman/5.6/en/miscellaneous-functions.html#function_inet6-aton ?
  I would like an IP-address datatype
Gary

The Last update to the Unicode Collation Algorithm implementation in MySQL was the introduction of utf8mb4_unicode_520_ci, which was released nearly 5 years ago.

The latest revision includes a bunch of useful changes, it’d be nice to see them available.
- Morgan Tocker
  
  Thank you, this is a good suggestion! Kamipo also had a request on Twitter to s/utf8/utf8mb4/
  https://twitter.com/kamipo/status/643416153247756289
Giuseppe Maxia

Thanks for asking!

I have summarized my wish list in this article:
http://datacharmer.blogspot.com.es/2015/08/mysql-usability-issues-for-replication.html

The bottom line is: better usability and monitoring.
Peter Laursen

CHECK constraints.
- Morgan Tocker
  
  Thank you! https://bugs.mysql.com/bug.php?id=3464 for reference (please click ‘affects me’)
Peter Laursen

+ Some way (‘an API’) to debug inside ‘stored programs’ implemented *in the server* – not in an external utility/client
Simon J Mudd

Like an IPv6 storage type probably a storage type to hold binary uuid values. While the size is the same the explicit type makes the intent clearer. (and string -> uuid validation can be forced, if needed)
Daniël van Eeden

CTE’s and windowing functions.
https://bugs.mysql.com/bug.php?id=16244

Also some of this:
http://www.slideshare.net/MarkusWinand/modern-sql
Mathias

Hi Morgan, I would love to if the MySQL 5.8 will can have partition and foreign key functionalities “innodb” in the same table! Will be great
- Morgan Tocker
  
  Hi Mathias, good suggestion. We do have a better foundation for this now, and it is one of the future goals of native partitioning: http://mysqlserverteam.com/innodb-native-partitioning-early-access/
Joe Grasse

I would like to see http://bugs.mysql.com/bug.php?id=1542 implemented.
Bill Karwin

My suggestions include several SQL features that are widely supported by most other popular RDBMS implementations (Oracle, IBM DB2, Microsoft SQL Server, Sybase, PostgreSQL, and SQLite).

INTERSECT and EXCEPT, requested since 2003 (http://bugs.mysql.com/bug.php?id=1309) or 2007 (http://bugs.mysql.com/bug.php?id=31336).

Throw an error or at least a warning when DDL includes constraints not supported by the storage engine. Currently the DDL statement executes with no warning, but the constraint may not be saved. Requested since 2004 (http://bugs.mysql.com/bug.php?id=4919)

REFERENCES as a column option, requested since 2004 (https://bugs.mysql.com/bug.php?id=4711).

CHECK constraints, requested since 2004 (mentioned already by Peter Laursen).

MERGE statement, requested since 2005 (http://bugs.mysql.com/bug.php?id=9018).

CTE’s and windowing functions, requested since 2006 (mentioned already by Daniël van Eeden).

INSTEAD OF triggers, requested since 2006 (http://bugs.mysql.com/bug.php?id=16525).

Implement FULL OUTER JOIN, requested since 2006 (http://bugs.mysql.com/bug.php?id=18003).
Or at least make FULL a reserved word (http://bugs.mysql.com/bug.php?id=69858).
- Morgan Tocker
  
  Detailed list. Thanks Bill!
  - Bill Karwin
    
    One more long-time feature request. This one came up again today at my company.
    
    Regular expression support in REPLACE(), even better with backreferences in the substitution string.
    Requested since 2007 ( https://bugs.mysql.com/bug.php?id=27389 )
  - Bill Karwin
    
    One more pet peeve: please make FULL a reserved word. ( http://bugs.mysql.com/bug.php?id=69858 )
Weixiang Zhai

Will the new Data dictionary implementation be merged into 5.7 ? If not ,I hope it can be merged into 5.8. 🙂
- Morgan Tocker
  
  I have an update on this here:
  http://www.tocker.ca/2015/05/20/a-quick-update-on-our-native-data-dictionary.html
  
  (Unfortunately it will miss 5.7)
Stewart Robinson

I would very much appreciate items 1 and 4
- Morgan Tocker
  
  They are in 5.7 🙂 The DYNAMIC row format part specifically hits 5.7.9 (not yet released.)
  - Stewart Robinson
    
    OOPS ! Thanks.
Sveta Smirnova

Small easy-to-do fix, but will be useful: bug #78068.
Fernando Ipar

I think Fabric would be better if the server supported:
– super_read_only
– selective read_only (make a table read_only when a given WHERE condition is met, so you can have better guarantees that writes would not go to the wrong shard)

Also, please consider https://bugs.mysql.com/bug.php?id=75161

Thanks!
- Morgan Tocker
  
  Hi Fernando, 5.7 has super_read_only: http://www.tocker.ca/2015/07/09/mysql-5-7-8-now-featuring-super_read_only-and-disabled_storage_engines.html – It also has something called offline_mode which was added at the request of the Fabric team 🙂
  
  The protocol extension FR you listed is very useful. Thank you!
Laurynas Biveinis

Single-thread performance getting some love: http://bugs.mysql.com/bug.php?id=78176, http://bugs.mysql.com/bug.php?id=74342, http://bugs.mysql.com/bug.php?id=69350, http://bugs.mysql.com/bug.php?id=69236, http://bugs.mysql.com/bug.php?id=68825
–innodb-log-checksum-algorithm=crc32 default change

MyISAM converted to a non-mandatory plugin, its MTR tests in separate suite or suites. This implies converting the last of system tables to InnoDB, if any still exist.

InnoDB data dictionary pushed to GA, FRMs killed.

Parser refactoring finished.

http://bugs.mysql.com/bug.php?id=69558 would be nice as well!
- Laurynas Biveinis
  
  Filed http://bugs.mysql.com/bug.php?id=78553 and http://bugs.mysql.com/bug.php?id=78554
- Laurynas Biveinis
  
  One more thing: merge InnoDB and core system runtimes. Why have two sets of mutex, malloc, etc. primitives in the server now? This would have nice benefits too: core server would get mutex locking order checks, hardware crc32, etc.
Peter Laursen

+https://bugs.mysql.com/bug.php?id=20307
Nikolaos Vyzas

Analytical functions (such as those available in OracleDB http://docs.oracle.com/cd/E11882_01/server.112/e41084/functions004.htm#SQLRF06174)
Federico Razzoli

External languages for stored procedures. https://lists.launchpad.net/maria-discuss/msg02831.html
ymmt2005

Pub/Sub functions.
Database changes are notified (helped by triggers, maybe) to subscribers.

Currently, we need to use other pub/sub services like Redis.
It is simply great if MySQL could provide pub/sub.
Shlomi Noach

Please see my bunch of suggestions here: http://code.openark.org/blog/mysql/new-features-id-like-to-see-in-mysql-5-8 (most of them repeat my ideas as presented in PerconaLive)
Przemek

Deprecate the non-consistent and dangerous replication filters. Instead, introduce ones that work regardless of binlog format, default database and of what is actually replicated (DML, DDL, SP, event, trigger, etc.)
Dennis Cheung

Is there any roadmap or plan to support SQL:2008 or SQL:2012 ?
or https://modern-sql.com/ will say everything not working in MySQL?
- Daniël van Eeden
  
  Did you see this page?
  https://dveeden.github.io/modern-sql-in-mysql/
Red Amancio

partitioned tables with foreign keys
Pavel Dvorak

I would like alter table for federated engine