PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/verifying-index-usage.html
Use the EXPLAIN statement, as described in Section 10.8.1, “Optimizing Queries with EXPLAIN”. Always check whether all your queries really use the indexes that you have created in the tables.
https://dev.mysql.com/doc/refman/8.0/en/window-function-optimization.html
For EXPLAIN, windowing execution plan information is too extensive to display in traditional output format. To see windowing information, use EXPLAIN FORMAT=JSON and look for the windowing element. Window functions affect the strategies the ...
https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html
Options and Variables Introduced in MySQL 8.0 Options and Variables Deprecated in MySQL 8.0 Options and Variables Removed in MySQL 8.0 This section lists server variables, status variables, and options that were added for the first time, have been ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table.html
While the nonunique indexes are disabled, they are ignored for statements such as SELECT and EXPLAIN that otherwise would use them. ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD ...
https://dev.mysql.com/doc/refman/8.0/en/analyze-table.html
You can make the statistics collected by ANALYZE TABLE more precise and more stable by enabling innodb_stats_persistent, as explained in Section 17.8.10.1, “Configuring Persistent Optimizer Statistics Parameters”. ANALYZE [NO_WRITE_TO_BINLOG | ...
https://dev.mysql.com/doc/refman/8.0/en/assignment-operators.html
Section 11.4, “User-Defined Variables”, explains why you should avoid doing this. Table 14.6 Assignment Operators Name Description := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE ...
https://dev.mysql.com/doc/refman/8.0/en/backup-methods.html
These binary logs are the incremental backup; at restore time, you apply them as explained in Section 9.5, “Point-in-Time (Incremental) Recovery”. Making a Hot Backup with MySQL Enterprise Backup Customers of MySQL Enterprise Edition can use the ...
https://dev.mysql.com/doc/refman/8.0/en/backup-policy.html
The description for the PURGE BINARY LOGS statement explains what should be verified before deleting the MySQL binary logs. A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. For example, MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/change-master-to.html
The correspondence between the two sets of options, and the use of the MASTER_SSL_xxx and MASTER_TLS_xxx options to set up a secure connection, is explained in Section 19.3.1, “Setting Up Replication to Use Encrypted Connections”. ] CHANGE ...
https://dev.mysql.com/doc/refman/8.0/en/change-replication-source-to.html
The correspondence between the two sets of options, and the use of the SOURCE_SSL_xxx and SOURCE_TLS_xxx options to set up a secure connection, is explained in Section 19.3.1, “Setting Up Replication to Use Encrypted Connections”. ] CHANGE ...