Oracle has announced the general availability of MySQL 5.7, with promises of greater performance, scalability and manageability, along with JSON support. 

It was showcased yesterday at Oracle OpenWorld in San Francisco by Tomas Ulin, Oracle vice president, MySQL Engineering, 

The improvements in speed have been demonstrated using SysBench Read-only Point-Selects. With 1,024 connections, MySQL 5.7 delivered 1,600,000 queries per second (QPS), which is three times faster than MySQL 5.6. Some of the performance improvement is down to optimization of InnoDB, MySQL’s database engine. Other improvements to InnoDB include concurrency, enhanced on-line operations, spatial indexes, and native partitioning.

MySQL’s replication is another area where improvements have been made. Multi-source replication has been added, along with enhanced Global Transaction Identifiers (GTIDs), and improved multi-threaded slaves for better scalability and availability. There’s also a new dynamic cost model for the MySQL optimizer giving better query performance and greater user control.

The JSON support comes in the form of a new native JSON data type, the addition of JSON functions, and index management on the JSON documents using generated columns. The changes mean that CREATE TABLE and ALTER TABLE can create JSON columns, and the Field class now allows INSERT to and SELECT from JSON typed fields. The server side, built-in JSON functions mean you can construct JSON data values from other relational data, extract relational data from JSON data values, introspect the structure of JSON values and text (validity, length, depth, keys), search within, and manipulate JSON data.

The developers have also introduced a JSON comparator, similar to the DATE/TIME/DATETIME comparator, that allow comparisons of JSON scalars vs SQL constants, and JSON scalars vs JSON scalars. The comparator converts the SQL constant to a JSON scalar and then compares the values. inline JSON path expressions in SQL queries have also been added, so that MySQL now executes queries like:

SELECT … FROM t1 WHERE t1.json_field->”$.path.to[0].key”= 123;

The Performance Schema has been improved to deliver better insights. Performance Schema is a specialized MySQL Storage Engine that is used for storing dynamically created events. It has a SQL interface that you can use to query and monitor those events. The new version can be used to monitor metadata locking, transactions, memory usage, and stored programs.

The Geographic Information System (GIS) system has been replaced in this new version. Writing about the new release on the MySQL Server blog, Geir Hoydalsvik said:

“After a careful evaluation of various open source geometry engines, we decided to replace our original GIS algorithms with Boost.Geometry. For those that build MySQL from source, it’s important to read about the new CMake options we added in the process.”

The team has also and added support for a number of additional SQL/MM standard spatial operations. Support for two new import and export formats, GeoJSON and geohash, has been added. New GeoJSON functions ST_AsGeoJSON and ST_GeomFromGeoJSON will encode and decode GeoJSON documents. A number of helper functions have also been added, specifically ST_Distance_Sphere, ST_MakeEnvelope, ST_IsValid, ST_Validate and ST_Simplify. While GIS support in MySQL still only uses a flat 2d plane, ST_Distance_Sphere will calculate distance between two points (or multipoints) on a sphere with a given radius.

There’s also a new MySQL Router, which simplifies application development by intelligently routing queries to MySQL databases for increased performance and uptime. MySQL Router also provides cross-language support for MySQL Fabric.

Related Articles

Improved Performance In MySQL Developer Milestone Release

MySQL 5.7 Hits 1 million NoSQL Queries per Second

SQLite 3.9

Amazon Launches Supercharged MySQL Alternative

 

 

To be informed about new articles on I Programmer subscribe to the RSS feed, follow us on, Twitter, Facebook, Google+ or Linkedin,  or sign up for our weekly newsletter.

 

 

 

Wasmer 5 Adds iOS Support 12/11/2024 The Wasmer team has released Wasmer 5.0. The WebAssembly runtime adds experimental support for more back ends including V8, Wasmi and WAMR. It also now has iOS support, and upgraded compilers includin [ ... ] + Full Story

TestSprite Announces End-to-End QA Tool 14/11/2024 TestSprite has announced an early access beta program for its end-to-end QA tool, along with $1.5 million pre-seed funding aimed at accelerating product development, expanding the team, and scaling op [ ... ] + Full Story

More News The Feds Want Us To Move On From C/C++ Flutter Forked As Flock C23 ISO Standard Is Here But You Probably Won't Read It Remembering Thomas Kurtz, Co-creator of BASIC Google Opensources Privacy Library Data Wrangler Gets Copilot Integration Random Gifts For Programmers IBM Opensources AI Agents For GitHub Issues CSS Ecosystem In the Spotlight Zitadel Announces Funding And Future Plans Google Updates Responsible AI Toolkit Rust And C++ Should Be Friends? AI Breakthrough For Robot Surgery

 

 

 

Comments

Make a Comment or View Existing Comments Using Disqus

or email your comment to: comments@i-programmer.info