Subscribe / Unsubscribe Enewsletters | Login | Register

Pencil Banner

What’s new in MySQL 8.0

Serdar Yegulalp | Sept. 29, 2017
Better Unicode support, better JSON and document handling, and long-requested features like window functions are part of the next big release for the popular open source database.

Another improvement related to JSON involve MySQL’s document-store abilities. Reads and writes to MySQL’s document store are transactionally consistent, allowing rollback operations on changes to JSON data. Document data stored in the open GeoJSON format for geospatial data can be indexed, so you can search by proximity.

 

The other key features in MySQL 8.0

Other changes planned for MySQL 8.0 include:

  • More options for how to handle locked rows, via the SKIP LOCKED and NOWAIT keywords. SKIP LOCKED allows locked rows to be skipped during an operation; NOWAIT throws an error immediately on encountering a locked row.
  • MySQL can automatically scale to the total amount of memory available, to make the best possible use of virtual machine deployments.
  • Indexes can be manually excluded from the query optimizer via the “invisible index” feature. Indexes marked as invisible are kept up to date with changes to tables, but aren’t used to optimize queries. One suggested use for this is to nondestructively determine if a particular index needs to be kept or not.

 

Where to download MySQL 8.0

You can download the beta versions of MySQL 8.0 now for Windows, MacOS, several versions of Linux, FreeBSD, and Solaris; the source code is also available. Scroll down the downloads page and go to the Development Releases tab to get them.

 

Previous Page  1  2 

Sign up for Computerworld eNewsletters.