Sign in
Categories
Your Saved List Become a Channel Partner Sell in AWS Marketplace Amazon Web Services Home Help

MySQL 5.7 on Windows Server 2022 support by Hanwei

MySQL 5.7 on Windows Server 2022 support by Hanwei

By: Hanwei Software Technology Latest Version: v5.7
Windows
Windows

Product Overview

This is a repackaged software product wherein additional charges apply for seller support, as well as licensing fees paid to AWS. The additional cost is applicable to the extended support of 24-hour response time.
Compared to MySQL 5.6, the new features of MySQL 5.7 mainly include the following aspects.

  1. Significant improvement in performance
    MySQL 5.7 has significant performance improvements across all load models and has set a new benchmark record. In the Point Select query test of MySQL 5.7, the test score is more than three times that of MySQL 5.6.
  2. Supports JSON
    JSON (JavaScript Object Notation) is a format for storing information that can effectively replace XML. Starting from MySQL 5.7, JSON will be supported. Prior to this version, JSON files could only be stored in a generic form such as strings. The drawback of this approach is that it requires self confirmation and parsing of data, solving difficulties during updates, or enduring slower speeds when performing insertion operations.
    In MySQL 5.7, a new data type has been added to store JSON formatted data in MySQL tables. The main benefits of native support for JSON data type are as follows:
    (1) Document validation: Only data segments that comply with the JSON specification can be written into columns of type JSON, which is equivalent to having automatic JSON syntax validation.
    (2) Efficient Access: When storing JSON documents in JSON columns, the data is not stored as plain text, but in an optimized binary format for faster access to its object members and array elements.
    (3) Improving performance: Creating indexes on JSON columns can enhance data query performance.
    3.Performance Schema
    Monitoring is necessary for any data management system. The core monitoring strategy provided by MySQL is Performance Schema. The improvements to Performance Schema in MySQL 5.7 include a large number of newly added monitoring items, reduced space and load consumption, and significantly improved usability through the new SYS Schema mechanism.
    In terms of monitoring, Performance Schema provides the following new features:
    (1) Metadata Locking: Any transaction that has already started will hold the metadata lock of the table until the transaction is committed. Due to the fact that the initial transaction holds metadata locks for all tables associated with the transaction, any DDL operations cannot be performed until the previous transaction is committed.
    (2) Stage Tracking: Long term tracking of the progress of operations.
    (3) Transaction: Monitor all aspects of transactions at the service layer and storage engine layer.
    (4) Memory usage: By collecting information on memory usage, we can understand the consumption of memory.
    (5) Pre compiled statements: Provide aggregated statistical information through pre compiled statements and display pre compiled statements used by the service.
    4.SYS Schema
    MySQL SYS Schema is a data schema consisting of a series of objects (views, stored procedures, stored methods, tables, and triggers), mainly stored in the monitoring data resources of Performance Schema and Information_SCHEMA. MySQL SYS Schema is included by default in MySQL 5.7 and provides a summary view to address the following issues:
    (1) Which processes occupy all the resources in the database?
    (2) Which hosts have the highest access to the database server?
    (3) Where is the memory used on the database instance?
  3. Performance and Scalability
    Improve the scalability of InnoDB and the performance of temporary tables to achieve faster network and big data loading operations.
  4. Improve replication to enhance availability performance
    Including multi-source replication, enhanced multi slave threading functionality, online GTIDs, and enhanced semi synchronous replication.
  5. Performance mode provides a better perspective
    Added many new monitoring features to reduce space and overload, and significantly improved usability using the new SYS mode.
  6. Improve safety
    With the principle of safety first, many new features are provided to ensure the security of the database.
  7. Optimization
    Rewrite most of the parsers, optimizers, and cost models to improve maintainability, scalability, and performance.

Version

v5.7

Operating System

Windows, Windows Server 2022 Base server

Delivery Methods

  • Amazon Machine Image

Pricing Information

Usage Information

Support Information

Customer Reviews