MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 171 to 180 of 181 total results

https://dev.mysql.com/doc/refman/9.7/en/tracing-example.html

Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** 1. row *************************** QUERY: SELECT ...

13.2.9 2-Digit Years in Dates

https://dev.mysql.com/doc/refman/9.7/en/two-digit-years.html

Date values with 2-digit years are ambiguous because the century is unknown. Such values must be interpreted into 4-digit form because MySQL stores years internally using 4 digits. For DATETIME, DATE, and TIMESTAMP types, MySQL interprets dates ...

3.1 Before You Begin

https://dev.mysql.com/doc/refman/9.7/en/upgrade-before-you-begin.html

The backup should include the mysql system database, which contains the MySQL data dictionary tables and system tables. Important Downgrade from MySQL 9.7 to MySQL 9.6, or from a MySQL 9.7 release to a previous MySQL 9.7 release, is not supported.

3.7 Upgrading MySQL Binary or Package-based Installations on Unix/Linux

https://dev.mysql.com/doc/refman/9.7/en/upgrade-binary-package.html

This section describes how to upgrade MySQL binary and package-based installations on Unix/Linux. In-Place Upgrade Logical Upgrade MySQL Cluster Upgrade In-Place Upgrade An in-place upgrade involves shutting down the old MySQL server, replacing the ...

3.2 Upgrade Paths

https://dev.mysql.com/doc/refman/9.7/en/upgrade-paths.html

Notes Make sure you understand the MySQL release model for MySQL for MySQL long long-term support (LTS) and Innovation versions before proceeding with a downgrade. We recommend checking upgrade compatibility with MySQL Shell's Upgrade Checker ...

3.13 Upgrade Troubleshooting

https://dev.mysql.com/doc/refman/9.7/en/upgrade-troubleshooting.html

A schema mismatch in a MySQL 9.6 instance between the .frm file of a table and the InnoDB data dictionary can cause an upgrade to MySQL 9.7 to fail. To address this issue, dump and restore affected tables before attempting the upgrade again. If ...

Chapter 3 Upgrading MySQL

https://dev.mysql.com/doc/refman/9.7/en/upgrading.html

This chapter describes the steps to upgrade a MySQL installation. Upgrading is a common procedure, as you pick up bug fixes within the same MySQL release series or significant features between major MySQL releases. You perform this procedure first ...

10.2.1.1 WHERE Clause Optimization

https://dev.mysql.com/doc/refman/9.7/en/where-optimization.html

This section discusses optimizations that can be made for processing WHERE clauses. The examples use SELECT statements, but the same optimizations apply for WHERE clauses in DELETE and UPDATE statements. Note Because work on the MySQL optimizer is ...

2.1.2 Which MySQL Version and Distribution to Install

https://dev.mysql.com/doc/refman/9.7/en/which-version.html

When preparing to install MySQL, decide which version and distribution format (binary or source) to use. First, decide whether to install from an LTS series like MySQL 8.4, or install from an Innovation series like MySQL 9.6. Both tracks include ...

2.3.3.5 Starting the Server for the First Time

https://dev.mysql.com/doc/refman/9.7/en/windows-server-first-start.html

This section gives a general overview of starting the MySQL server. The following sections provide more specific information for starting the MySQL server from the command line or as a Windows service. The information here applies primarily if you ...

Displaying 171 to 180 of 181 total results