MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 161 to 170 of 171 total results

10.12.2.2 Using Symbolic Links for MyISAM Tables on Unix

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

For InnoDB tables, use the alternative technique explained in Section 17.6.1.2, “Creating Tables Externally” instead. Note Symbolic link support as described here, along with the --symbolic-links option that controls it, and is deprecated; ...

10.12.2 Using Symbolic Links

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

For InnoDB tables, use the DATA DIRECTORY clause of the CREATE TABLE statement instead of symbolic links, as explained in Section 17.6.1.2, “Creating Tables Externally”. You can move databases or tables from the database directory to other ...

10.15.2 System Variables Controlling Tracing

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

This also affects the output of EXPLAIN FORMAT=JSON in those versions of MySQL which support this statement. The following system variables affect optimizer tracing: optimizer_trace: Enables or disables optimizer tracing. optimizer_trace_features: ...

10.2.1.23 Avoiding Full Table Scans

https://dev.mysql.com/doc/refman/8.0/en/table-scan-avoidance.html

The output from EXPLAIN shows ALL in the type column when MySQL uses a full table scan to resolve a query. This usually happens under the following conditions: The table is so small that it is faster to perform a table scan than to bother with a ...

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

"resulting_clause_is_simple": true, "resulting_clause": "`test`.`alias1`.`col_int_key`" } /* clause_processing */ }, The shorter ORDER BY clause (which is not visible in in the output of EXPLAIN) can be implemented as an index scan, since it uses ...

3.5 Changes in MySQL 8.0

https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html

The following sections explain the changes to defaults and any impact they might have on your deployment. Before upgrading to MySQL 8.0, review the changes described in this section to identify those that apply to your current MySQL installation ...

8.3.1 Configuring MySQL to Use Encrypted Connections

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

However, runtime changes to these variables do not immediately affect the TLS context for new connections, as explained later in this section. Several configuration parameters are available to indicate whether to use encrypted connections, and to ...

22.5.3 Using Encrypted Connections with X Plugin

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

This section explains how to configure X Plugin to use encrypted connections. To enable configuring support for encrypted connections, X Plugin has mysqlx_ssl_xxx system variables, which can have different values from the ssl_xxx system variables ...

22.5.6.2 X Plugin Options and System Variables

https://dev.mysql.com/doc/refman/8.0/en/x-plugin-options-system-variables.html

When enabled, clients which do not support X Protocol that attempt to connect to the server X Protocol port receive an error explaining they are using the wrong protocol. To control activation of X Plugin, use this option: --mysqlx[=value] ...

Displaying 161 to 170 of 171 total results