Download MySQL Download Free – 9.0.1

MySQL Classic Edition is the ideal embedded database for ISVs, OEMs and VARs developing read-intensive applications using the MyISAM storage engine. It is proven as a high performance, zero administration database.

• Lower TCO – MySQL allows you to minimize your database TCO.
• Ease of Use – MySQL is known for “15 minutes to success” from download to installation.
• Low administration – MySQL is easy to administer, enabling DBAs to manage multiple servers.
• Supports over 20 platforms and operating systems, including Linux, Unix, Mac and Windows, giving you ultimate flexibility in development and deployment options.

MySQL Classic Edition is only available to ISVs, OEMs and VARs to license as an embedded database.

When you need additional functions, it is easy to upgrade to MySQL Standard Edition, MySQL Enterprise Edition or MySQL Cluster Carrier Grade Edition.

What is new

Changes in MySQL 9.0.1 (2024-07-23, Innovation Release)

Error fixed

• InnoDB: In some cases, after the creation of a very large number of tables (8001 or more), the server could not be restarted. (bug #36808732)
• References: This issue is a regression of: Bug #33398681.
• InnoDB: Improved tablespace file scan performance at startup. (Bug #110402, Bug #35200385)
• Group Replication: Executing a CREATE TABLE … SELECT statement on a source coming from an asynchronous channel to group replication caused the replica to fail. (bug #36784284)

This section summarizes what has been added, deprecated, changed, and removed from MySQL 9.0 since MySQL 8.4. A companion section lists MySQL server options and variables that have been added, deprecated, or removed in MySQL 9.0; see Section 1.5, “Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 9.0 Since 8.4”.

Features added or changed in MySQL 9.0

• JavaScript stored programs. MySQL Enterprise Edition now includes support for stored programs written in JavaScript, such as this simple example created with the CREATE FUNCTION statement and JavaScript code
• Support is included for both stored procedures and stored functions written in JavaScript, and is provided by the Multilingual Engine Component (MLE). For more information on how to determine whether your distribution includes this component and how to enable it, see Section 7.5.6, “Multilingual Engine Component (MLE)”.
• JavaScript language support in MySQL conforms to the ECMAScript 2023 specification and uses strict mode by default. Strict mode cannot be disabled. This implementation includes all standard ECMAScript library objects such as Object, Function, Math, Date, String, and so on. console.log() and console.error() are also supported (see Section 27.3.9, “Examples of Stored JavaScript Programs”).
• Most MySQL data types are supported for JavaScript stored program input and output arguments, as well as for return data types. Strings must use the utf8mb4 character set. MySQL BLOB and TEXT types are supported, as are many MySQL time types. JSON is also supported. The VECTOR type is not supported by the MLE component or by JavaScript stored programs. for more information, see Section 27.3.4, “JavaScript Stored Program Data Types and Argument Handling”, and Section 27.3.8, “JavaScript Stored Program Limitations and Restrictions”.
• Stored programs written in JavaScript support an API to execute and retrieve results from SQL statements, provided by the MLE component. See Section 27.3.6, “JavaScript SQL API”, and Section 27.3.7, “Using the JavaScript SQL API”, for more information. Prepared statements are also supported in programs written in JavaScript; see section 27.3.7.2, “Prepared Statements”.
• The MLE component provides a number of session information and management functions including mle_session_state() and mle_session_reset(). Section 7.5.6.1, “MLE Component Option and Variable Reference”, and Section 7.5.6.2, “MLE Component Status and Session Information”, provide information about MLE configuration options and status variables; see also Section 27.3.5, “JavaScript Stored Programs—Session Information and Options”.
• VECTOR type support. MySQL 9.0 supports a VECTOR column type. A vector is a data structure consisting of a list of entries (4-byte floating-point values) that can be expressed as either a binary string value or a list-formatted string. A VECTOR column is declared with a maximum length or number of entries (in parentheses); default is 2048, and maximum is 16383.