Oracle tweaks MySQL and boosts storage engine

Date:
Wed, 11 Aug 2021 11:01:44 +0000

Description:
With MySQL Autopilot, Oracle promises HeatWave customers less hassle and more automation.

FULL STORY ======================================================================

Oracle has announced a free upgrade to its MySQL HeatWave service which it says promises to make life easier for clients, while at the same time improving performance and stability.

The upgrade comes in the form of MySQL Autopilot, an entirely new component
to Oracle's cloud -hosted version of the database system.

According to the companys press release, MySQL Autopilot uses advanced
machine learning techniques to automate much of HeatWaves features -
including provisioning, data loading, query execution and failure handling,
to name a few - all of which should help users achieve high query performance at scale. Heres our list of the best cloud storage services right now Weve built a list of the best cloud database services on the market Check out our list of the best small business servers available

It works by sampling data, collecting statistics on data and queries, and
then building machine learning models using Oracle AutoML to model memory usage, network load, and execution time, Oracle explained. MySQL Autopilot would then use these machine learning models to execute its core
capabilities.

As more queries get executed, system performance gets improved over time.
With MySQL Autopilot, Oracle promises, HeatWave query optimizer gets increasingly intelligent. Improving performance while cutting costs

Among the different features of the new offering are auto provisioning and auto encoding. The former predicts the number of HeatWave nodes required for running a workload by adaptive sampling of table data on which analytics is required. As a result, customers are freed from manually estimating their clusters optimal size. The latter, on the other hand, determines the optimal representation of columns being loaded into HeatWave, taking the queries into consideration.

Through optimal representation, users get the best query performance, while minimizing cluster size and cutting costs.

In the same announcement, Oracle also unveiled MySQL Scale-out Data Management, a service that improves the performance of reloading data into HeatWave by up to 100 times.

Cluster size support increased from 24 nodes up to 64 nodes now, with
HeatWave now being able to process 32 TB of data, instead of the previous 12TB.

MySQL HeatWave users can now use Autopilot with no additional cost, the company concluded. Heres our rundown of the best laptops for programming out there



======================================================================
Link to news story: https://www.techradar.com/news/oracle-tweaks-mysql-and-boosts-storage-engine/


--- Mystic BBS v1.12 A47 (Linux/64)
* Origin: tqwNet Technology News (1337:1/100)