MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 411 to 420 of 421 total results

https://dev.mysql.com/doc/refman/8.0/en/testing-server.html

After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works satisfactorily. This section assumes that your current location is the MySQL installation directory and that it has a bin ...

7.6.3.3 Thread Pool Operation

https://dev.mysql.com/doc/refman/8.0/en/thread-pool-operation.html

For each thread group, a maximum of one statement per 10ms (100 per second) is moved from the low-priority queue to the high-priority queue. The thread pool consists of a number of thread groups, each of which manages a set of client connections.

13.2.5 Automatic Initialization and Updating for TIMESTAMP and DATETIME

https://dev.mysql.com/doc/refman/8.0/en/timestamp-initialization.html

If a TIMESTAMP or DATETIME column definition includes an explicit fractional seconds precision value anywhere, the same value must be used throughout the column definition. TIMESTAMP and DATETIME columns can be automatically initialized and updated ...

14.3 Type Conversion in Expression Evaluation

https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html

If the two values have the same JSON type, a second level of comparison occurs using type-specific rules. When an operator is used with operands of different types, type conversion occurs to make the operands compatible. For example, MySQL ...

15.2.17 UPDATE Statement

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

For example, the following statement sets col1 to one more than its current value: UPDATE t1 SET col1 = col1 + 1; The second assignment in the following statement sets col2 to the current (updated) col1 value, not the original col1 value. UPDATE 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

If mysql_upgrade has been run successfully, there should be no such messages the second time you start the server. This section describes how to upgrade MySQL binary and package-based installations on Unix/Linux. In-Place Upgrade Logical Upgrade ...

3.6 Preparing Your Installation for Upgrade

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

In-place upgrade to MySQL 8.0 is not supported if tables contain old temporal columns in pre-5.6.4 format (TIME, DATETIME, and TIMESTAMP columns without support for fractional seconds precision). Before upgrading to the latest MySQL 8.0 release, ...

7.6.6.3 Using Version Tokens

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

Before using Version Tokens, install it according to the instructions provided at Section 7.6.6.2, “Installing or Uninstalling Version Tokens”. A scenario in which Version Tokens can be useful is a system that accesses a collection of MySQL ...

2.1.2 Which MySQL Version and Distribution to Install

https://dev.mysql.com/doc/refman/8.0/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 a bugfix series like MySQL 8.4, or use an innovation release like MySQL 9.6. Both tracks include bug ...

22.5.5 Connection Compression with X Plugin

https://dev.mysql.com/doc/refman/8.0/en/x-plugin-connection-compression.html

From MySQL 8.0.19, X Plugin supports compression of messages sent over X Protocol connections. Connections can be compressed if the server and the client agree on a mutually supported compression algorithm. Enabling compression reduces the number ...

Displaying 411 to 420 of 421 total results