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/server-status-variable-reference.html
The following table lists all status variables applicable within mysqld. The last column indicates whether the scope for each variable is Global, Session, or both. Please see the corresponding item descriptions for details on setting and using the ...
https://dev.mysql.com/doc/refman/8.0/en/show-binlog-events.html
Note Issuing a SHOW BINLOG EVENTS with no LIMIT clause could start a very time- and resource-consuming process because the server returns to the client the complete contents of the binary log (which includes all statements executed by the server ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-best-practices.html
Run Upgrade Checker and Fix Incompatibilities MySQL Shell's Upgrade Checker Utility detects incompatibilities between database versions that must be addressed before performing the upgrade. These include incompatibilities in data types, storage ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-functions-plugin-specific.html
keyring_aws_rotate_keys() Associated keyring plugin: keyring_aws keyring_aws_rotate_keys() rotates keys stored in the keyring_aws storage file named by the keyring_aws_data_file system variable. Rotation changes only the key that AWS KMS uses for ...
https://dev.mysql.com/doc/refman/8.0/en/order-by-optimization.html
ORDER BY RAND() LIMIT 15; Influencing ORDER BY Optimization For slow ORDER BY queries for which filesort is not used, try lowering the max_length_for_sort_data system variable to a value that is appropriate to trigger a filesort. This section ...An ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-timeout.html
The data also shows the number of retries for the last transaction and the transaction currently in progress, and enables you to identify the transient errors that caused the transactions to be retried. Transactions are automatically retried when ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-launching.html
If your data dictionary was initialized using an earlier version you must perform the MySQL upgrade procedure (see Chapter 3, Upgrading MySQL). If you used plugin_load_add='group_replication.so' in the option file then the Group Replication plugin ... It is first necessary to ensure that the Group Replication plugin is installed on server ...It should show something like this: mysql> SHOW PLUGINS; +----------------------------+----------+--------------------+----------------------+-------------+ | Name | Status | Type | Library | License | +----------------------------+----------+--------------------+----------------------+-------------+ | binlog | ACTIVE | STORAGE ENGINE | NULL | PROPRIETARY | (...) | group_replication | ACTIVE | GROUP REPLICATION | group_replication.so | PROPRIETARY | ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-sql-statements.html
SELECT * FROM INFORMATION_SCHEMA.ENGINES [WHERE ENGINE LIKE 'NDB%'] This is the equivalent of SHOW ENGINES, but uses the ENGINES table of the INFORMATION_SCHEMA database. You can also query the tables in the ndbinfo information database for ... This ...See Section 15.7.7.15, “SHOW ENGINE Statement”, for a usage example and more detailed ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-aggregate-functions.html
If any geometry argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. If those arguments are not in the same SRS, an ER_GIS_DIFFERENT_SRIDS_AGGREGATION error occurs. For general information about these functions, ... MySQL supports aggregate functions that perform a calculation on a set of ...
https://dev.mysql.com/doc/refman/8.0/en/window-function-optimization.html
For nonfloating-point data types, inverse aggregation is always safe and is used regardless of the windowing_use_high_precision value. Window functions affect the strategies the optimizer considers: Derived table merging for a subquery is disabled ...Semijoins are not applicable to window function optimization because semijoins apply to subqueries in WHERE and JOIN ...