MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 461 to 470 of 474 total results

https://dev.mysql.com/doc/refman/8.0/en/sys-format-path.html

Given a path name, returns the modified path name after replacing subpaths that match the values of the following system variables, in order: datadir tmpdir slave_load_tmpdir or replica_load_tmpdir innodb_data_home_dir innodb_log_group_home_dir ...

30.4.4.25 The statement_performance_analyzer() Procedure

https://dev.mysql.com/doc/refman/8.0/en/sys-statement-performance-analyzer.html

Creates a report of the statements running on the server. The views are calculated based on the overall and/or delta activity. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system ...

13.2.5 Automatic Initialization and Updating for TIMESTAMP and DATETIME

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

TIMESTAMP and DATETIME columns can be automatically initialized and updated to the current date and time (that is, the current timestamp). For any TIMESTAMP or DATETIME column in a table, you can assign the current timestamp as the default value, ...

13.2.9 2-Digit Years in Dates

https://dev.mysql.com/doc/refman/8.0/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 ...

14.3 Type Conversion in Expression Evaluation

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

When an operator is used with operands of different types, type conversion occurs to make the operands compatible. For example, MySQL automatically converts strings to numbers as necessary, and vice versa. mysql> SELECT 1+'1'; -> 2 mysql> SELECT ...

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

As of MySQL 8.0.16, a MySQL Cluster upgrade can be performed as a regular rolling upgrade, following the usual three ordered steps: Upgrade MGM nodes. This section describes how to upgrade MySQL binary and package-based installations on Unix/Linux.

3.4 What the MySQL Upgrade Process Upgrades

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

From MySQL 8.0.30, when Step 2 is upgrading the system tables in the mysql schema, the column order in the primary key of the mysql.db, mysql.tables_priv, mysql.columns_priv and mysql.procs_priv tables is changed to place the host name and user name ... 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.2.21 Setting Account Resource Limits

https://dev.mysql.com/doc/refman/8.0/en/user-resources.html

One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero value. This limits the number of simultaneous connections that can be made by any given account, but places no ...

7.6.6.3 Using Version Tokens

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

Order of tokens is not significant except that if a token list contains multiple instances of a given token name, the last value takes precedence over earlier values. Before using Version Tokens, install it according to the instructions provided at ...

10.2.1.21 Window Function Optimization

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

The optimizer processes multiple windows that have the same ordering requirements in sequence, so sorting can be skipped for windows following the first one. Window functions affect the strategies the optimizer considers: Derived table merging for ...

Displaying 461 to 470 of 474 total results