MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 811 to 820 of 829 total results

https://dev.mysql.com/doc/refman/8.0/en/solaris-installation.html

If you do not have GNU tar on your system, install it with the following command: pkg install archiver/gnu-tar You should mount any file systems on which you intend to store InnoDB files with the forcedirectio option. Note MySQL 8.0 supports ...

15.4.3.1 START GROUP_REPLICATION Statement

https://dev.mysql.com/doc/refman/8.0/en/start-group-replication.html

Note that user credentials set using these statements are stored in the replication metadata repositories, and are used when START GROUP_REPLICATION is specified without user credentials, including automatic starts if the ... START GROUP_REPLICATION ...

15.2.15.12 Restrictions on Subqueries

https://dev.mysql.com/doc/refman/8.0/en/subquery-restrictions.html

MySQL permits a subquery to refer to a stored function that has data-modifying side effects such as inserting rows into a table. In general, you cannot modify a table and select from the same table in a subquery. For example, this limitation ...

10.15.2 System Variables Controlling Tracing

https://dev.mysql.com/doc/refman/8.0/en/system-variables-controlling-tracing.html

The following system variables affect optimizer tracing: optimizer_trace: Enables or disables optimizer tracing. optimizer_trace_features: Enables or disables selected features of the MySQL Optimizer, using the syntax shown here: SET ...

8.4.1.12 Test Pluggable Authentication

https://dev.mysql.com/doc/refman/8.0/en/test-pluggable-authentication.html

For example: $> mysql --user=testuser --password Enter password: testpassword The plugin fetches the password as received from the client and compares it with the value stored in the authentication_string column of the account row in the mysql.user ... MySQL includes a test plugin that checks account credentials and logs success or failure to the server error ...

10.15.3 Traceable Statements

https://dev.mysql.com/doc/refman/8.0/en/traceable-statements.html

Statements which are traceable are listed here: SELECT INSERT REPLACE UPDATE DELETE EXPLAIN with any of the preceding statements SET DO DECLARE, CASE, IF, and RETURN as used in stored routines CALL Tracing is supported for both INSERT and REPLACE ...For statements which are prepared and executed in separate steps, preparation and execution are traced ...

10.15.12 Example

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

row *************************** QUERY: SELECT SUM(alias2.col_varchar_nokey) AS c1, alias2.pk AS c2 FROM t1 AS alias1 STRAIGHT_JOIN t2 AS alias2 ON alias2.pk = alias1.col_int_key WHERE alias1.pk GROUP BY c2 ORDER BY alias1.col_int_key, alias2.pk This ...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 ...

13.2.9 2-Digit Years in Dates

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

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

3.13 Upgrade Troubleshooting

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

To address this issue, dump and restore affected tables before attempting the upgrade again. The same is true if the new version of MySQL implements a built-in function with the same name as an existing stored function. A schema mismatch in a MySQL ...

17.6.1.1 Creating InnoDB Tables

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

Row Formats The row format of an InnoDB table determines how its rows are physically stored on disk. InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB; The ...

Displaying 811 to 820 of 829 total results