MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 351 to 360 of 362 total results

https://dev.mysql.com/doc/refman/8.0/en/update.html

Note Unlike the case when using PARTITION with an INSERT or REPLACE statement, an otherwise valid UPDATE ... UPDATE is a DML statement that modifies rows in a table. An UPDATE statement can start with a WITH clause to define common table ...

3.3 Upgrade Best Practices

https://dev.mysql.com/doc/refman/8.0/en/upgrade-best-practices.html

MySQL supports upgrading between minor versions (within an LTS series) and to the next major version (across an LTS series). LTS releases have 8+ years of support and are meant for production use. Performing a minor version upgrade is ...

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

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

In-Place Upgrade Logical Upgrade MySQL Cluster Upgrade In-Place Upgrade An in-place upgrade involves shutting down the old MySQL server, replacing the old MySQL binaries or packages with the new ones, restarting MySQL on the existing data directory, ... This section describes how to upgrade MySQL binary and package-based installations on ...

3.4 What the MySQL Upgrade Process Upgrades

https://dev.mysql.com/doc/refman/8.0/en/upgrading-what-is-upgraded.html

If the actual data dictionary version is lower than the current expected version, the server creates data dictionary tables with updated definitions, copies persisted metadata to the new tables, atomically replaces the old tables with the new ones, ... Installing a new version of MySQL may require upgrading these parts of the existing installation: The mysql system schema, which contains tables that store information required by the MySQL server as it runs (see Section 7.3, “The mysql System ...

8.3.1 Configuring MySQL to Use Encrypted Connections

https://dev.mysql.com/doc/refman/8.0/en/using-encrypted-connections.html

It is sufficient to replace the existing file contents with a nonexpired certificate and execute ALTER INSTANCE RELOAD TLS to cause the new file contents to be read and used for new connections. Several configuration parameters are available to ...

10.8.1 Optimizing Queries with EXPLAIN

https://dev.mysql.com/doc/refman/8.0/en/using-explain.html

The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. When EXPLAIN is used with an explainable statement, MySQL displays information from the ...

7.6.6.4 Version Tokens Reference

https://dev.mysql.com/doc/refman/8.0/en/version-tokens-reference.html

| +--------------------------------------------------------+ version_tokens_set(token_list) Replaces the server's list of version tokens with the tokens defined in the token_list argument and returns a binary string that indicates the outcome of the ... The following discussion serves as a reference to these Version Tokens elements: Version Tokens Functions Version Tokens System Variables Version Tokens Functions The Version Tokens plugin library includes several ...

B.3.1 How to Determine What Is Causing a Problem

https://dev.mysql.com/doc/refman/8.0/en/what-is-crashing.html

If the Caps Lock light does not change, you have to replace your keyboard. This can normally be checked by pressing the Caps Lock key. (Before doing this, you should try to restart your computer and check all cables to the keyboard.) The mouse ...

10.2.1.21 Window Function Optimization

https://dev.mysql.com/doc/refman/8.0/en/window-function-optimization.html

Window functions affect the strategies the optimizer considers: Derived table merging for a subquery is disabled if the subquery has window functions. Semijoins are not applicable to window function optimization because semijoins apply to ...

10.12.2.3 Using Symbolic Links for Databases on Windows

https://dev.mysql.com/doc/refman/8.0/en/windows-symbolic-links.html

Using Windows Explorer or the command line, move the directory mydb from the data directory to D:\data, replacing the directory of the same name. On Windows, symbolic links can be used for database directories. This enables you to put a database ...

Displaying 351 to 360 of 362 total results