Followers | 686 |
Posts | 142929 |
Boards Moderated | 35 |
Alias Born | 03/10/2004 |
![](https://investorshub.advfn.com/uicon/35728.png?cb=1539773763)
Wednesday, August 11, 2021 10:06:34 AM
By: Cision | August 10, 2021
AUSTIN, Texas, Aug. 10, 2021 /PRNewswire/ -- Oracle today announced availability of MySQL Autopilot, a new component of MySQL HeatWave service, the in-memory query acceleration engine for MySQL Database Service in Oracle Cloud Infrastructure (OCI). MySQL Autopilot uses advanced machine learning techniques to automate HeatWave which make it easier to use and further improves performance and scalability. No other cloud vendor provides such advanced automation capabilities for their database offerings. Autopilot is available at no additional charge for MySQL HeatWave customers.
MySQL Autopilot automates many of the most important and often challenging aspects of achieving high query performance at scale—including provisioning, data loading, query execution and failure handling. It uses advanced techniques to sample data, collect statistics on data and queries, and build machine learning models using Oracle AutoML to model memory usage, network load and execution time. These machine learning models are then used by MySQL Autopilot to execute its core capabilities. MySQL Autopilot makes the HeatWave query optimizer increasingly intelligent as more queries are executed, resulting in continually improving system performance over time—a capability not available on Amazon Aurora, Amazon Redshift, Snowflake, or other MySQL-based database services.
MySQL Autopilot includes the following capabilities:
Auto provisioning predicts the number of HeatWave nodes required for running a workload by adaptive sampling of table data on which analytics is required. This means that customers no longer need to manually estimate the optimal size of their cluster. No other database service provides this capability.
Auto parallel load can optimize the load time and memory usage by predicting the optimal degree of parallelism for each table being loaded into HeatWave. No other cloud vendor offers this capability.
Auto data placement predicts the column on which tables should be partitioned in-memory to help achieve the best performance for queries. It also predicts the expected gain in query performance with the new column recommendation. This minimizes data movement across nodes due to suboptimal choices that can be made by operators when manually selecting the column. No other database service provides this capability.
Auto encoding can determine the optimal representation of columns being loaded into HeatWave, taking the queries into consideration. This optimal representation provides the best query performance and minimizes the size of the cluster to minimize costs.
Auto query plan improvement learns various statistics from the execution of queries and can improve the execution plan of future queries. This improves the performance of the system as more queries are run. No other database service provides this capability.
Auto query time estimation can estimate the execution time of a query prior to executing the query. This provides a prediction of how long a query will take, enabling customers to decide if the duration of the query is too long and instead run a different query.
Auto change propagation intelligently determines the optimal time when changes in MySQL Database should be propagated to the HeatWave Scale-out Data Management layer. This helps ensure that changes are being propagated at the right optimal cadence. No other cloud vendor offers this capability.
Auto scheduling can determine which queries in the queue are short running and prioritize them over long running queries in an intelligent way to reduce overall wait time. Most other databases use the First In, First Out (FIFO) mechanism for scheduling.
Auto error recovery provisions new nodes and reloads necessary data if one or more HeatWave nodes is unresponsive due to software or hardware failure.
"Oracle's MySQL Database Service with HeatWave is the only MySQL database that efficiently supports both OLTP and OLAP, enabling users to run mixed workloads or real-time analytics against their MySQL database with 10 to 1,000 times better performance and less than half the cost compared to other analytical or MySQL-based databases," said Edward Screven, Chief Corporate Architect, Oracle. "MySQL HeatWave is one of the fastest growing cloud services on OCI and an increasing number of customers are moving their MySQL workloads to HeatWave. Today, we are announcing a number of innovations which are the result of years of research and advanced development at Oracle. The combination of these innovations delivers massive improvements in automation, performance and cost—further distancing HeatWave from other database cloud services."
* * *
Read Full Story »»»
![](http://studentaid.gov/universal-navigation/assets/us_flag_small.png)
Information posted to this board is not meant to suggest any specific action, but to point out the technical signs that can help our readers make their own specific decisions. Caveat emptor!
• DiscoverGold
Recent ORCL News
- Salam Taps Oracle to Optimize Business Operations and Innovate with New Service Offerings • PR Newswire (US) • 07/25/2024 12:00:00 PM
- Odyssey House Implements Oracle Health to Help Enhance Patient Care, Improve Revenue Management • PR Newswire (US) • 07/24/2024 01:00:00 PM
- Oracle Helps HR Teams Boost Employee Productivity and Drive Success • PR Newswire (US) • 07/23/2024 12:00:00 PM
- Berkshire Sells BofA Holdings, Ryanair Shares Drop 12%, Delta Still Struggling After IT Disruption • IH Market News • 07/22/2024 09:44:17 AM
- Form 4 - Statement of changes in beneficial ownership of securities • Edgar (US Regulatory) • 07/11/2024 10:24:52 PM
- Oracle Announces Exadata Exascale, World's Only Intelligent Data Architecture for the Cloud • PR Newswire (US) • 07/11/2024 03:00:00 PM
- Form 144 - Report of proposed sale of securities • Edgar (US Regulatory) • 07/10/2024 08:37:48 PM
- Global Organizations Boost Growth with Oracle Cloud VMware Solution • PR Newswire (US) • 07/10/2024 03:00:00 PM
- Oracle Advances Safety Case Management for Life Science Organizations • PR Newswire (US) • 07/10/2024 12:00:00 PM
- Microsoft and Apple Exit OpenAI Board, TSMC Exceeds Forecasts with Record Revenue, and Other Key Updates • IH Market News • 07/10/2024 10:42:17 AM
- Oracle and Palantir Unlock New Innovation in Cloud and AI to Power Businesses and Governments Around the World • PR Newswire (US) • 07/09/2024 12:00:00 PM
- Hitachi Construction Machinery Drives Digital Transformation by Moving Large-scale Systems to Oracle Cloud Infrastructure • PR Newswire (US) • 07/01/2024 03:00:00 PM
- Oracle Announces Industry First In-Database LLMs and an Automated In-Database Vector Store with HeatWave GenAI • PR Newswire (US) • 06/26/2024 03:00:00 PM
- Oracle Cloud Helps Health Insurers Reduce Data Complexity and IT Costs • PR Newswire (US) • 06/25/2024 12:00:00 PM
- SolarEdge Stock Falls 13%, Wegovy Approved in China, Grail Nasdaq Debut, Apple Rejects Meta Chatbot • IH Market News • 06/25/2024 10:36:11 AM
- Oracle Named a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics and Business Intelligence Platforms • PR Newswire (US) • 06/24/2024 04:00:00 PM
- AI-Powered Oracle Clinical Digital Assistant Transforms Interactions Between Practitioners and Patients • PR Newswire (US) • 06/24/2024 10:00:00 AM
- Honeywell Acquires CAES Systems for $1.9 Billion, Sarepta Therapeutics Surges 34%, Gilead Continues Gains • IH Market News • 06/21/2024 12:00:38 PM
- Oracle to Invest More Than $1 Billion in AI and Cloud Computing in Spain • PR Newswire (US) • 06/20/2024 04:00:00 PM
- Oracle Autonomous Database Now Generally Available on Oracle Database@Azure • PR Newswire (US) • 06/20/2024 12:00:00 PM
- Oracle APEX AI Assistant Enables Natural Language-Based Development of Enterprise Applications • PR Newswire (US) • 06/17/2024 03:00:00 PM
- U.S. Department of Veterans Affairs Extends Oracle EHR Modernization Contract • PR Newswire (US) • 06/13/2024 05:12:00 PM
- Panasonic Information Systems Selects Oracle Cloud Infrastructure to Drive Modernization of Internal Systems Across the Group • PR Newswire (US) • 06/13/2024 03:00:00 PM
- Paramount Ends Skydance Talks, Oracle Shares Surge 8.7% on New Partnerships, and More News • IH Market News • 06/12/2024 11:19:10 AM
- Form 8-K - Current report • Edgar (US Regulatory) • 06/11/2024 08:15:50 PM
FEATURED Southern Silver Files NI43-101 Technical Report for its Updated Preliminary Economic Assessment for the Cerro Las Minitas Project • Jul 25, 2024 8:00 AM
Greenlite Ventures Completes Agreement with No Limit Technology • GRNL • Jul 19, 2024 10:00 AM
VAYK Expects Revenue from First Airbnb Property Starting from August • VAYK • Jul 18, 2024 9:00 AM
North Bay Resources Acquires Mt. Vernon Gold Mine, Sierra County, California, with Assays up to 4.8 oz. Au per Ton • NBRI • Jul 18, 2024 9:00 AM
Nightfood Holdings Signs Letter of Intent for All-Stock Acquisition of CarryOutSupplies.com • NGTF • Jul 17, 2024 1:00 PM
Kona Gold Beverages Reaches Out to Largest Debt Holder for Debt Purchase Negotiation • KGKG • Jul 17, 2024 9:00 AM