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 LOCKEDallows locked rows to be skipped during an operation;
NOWAITthrows 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.
Sign up for Computerworld eNewsletters.