Search Results
https://dev.mysql.com/doc/refman/8.4/en/derived-condition-pushdown-optimization.html
When a derived table cannot be merged into the outer query (for example, if the derived table uses aggregation), pushing the outer WHERE condition down to the derived table should decrease the number of rows that need to be processed and thus speed ...
https://dev.mysql.com/doc/refman/8.4/en/describe.html
The DESCRIBE and EXPLAIN statements are synonyms, used either to obtain information about table structure or query execution plans. For more information, see Section 15.7.7.6, “SHOW COLUMNS Statement”, and Section 15.8.2, “EXPLAIN ...
https://dev.mysql.com/doc/refman/8.4/en/drop-resource-group.html
DROP RESOURCE GROUP group_name [FORCE] DROP RESOURCE GROUP is used for resource group management (see Section 7.1.16, “Resource Groups”). The FORCE modifier determines statement behavior if the resource group has any threads assigned to it: If ...
https://dev.mysql.com/doc/refman/8.4/en/drop-role.html
DROP ROLE removes one or more roles (named collections of privileges). To use this statement, you must have the global DROP ROLE or CREATE USER privilege. When the read_only system variable is enabled, DROP ROLE additionally requires the ...
https://dev.mysql.com/doc/refman/8.4/en/drop-trigger.html
DROP TRIGGER [IF EXISTS] [schema_name.]trigger_name This statement drops a trigger. If the schema is omitted, the trigger is dropped from the default schema. DROP TRIGGER requires the TRIGGER privilege for the table associated with the trigger. Use ...
https://dev.mysql.com/doc/refman/8.4/en/enterprise-encryption-function-reference.html
MySQL Enterprise Encryption functions are provided by the MySQL component_enterprise_encryption component.
https://dev.mysql.com/doc/refman/8.4/en/enterprise-encryption-usage.html
To use MySQL Enterprise Encryption in applications, invoke the functions that are appropriate for the operations you wish to perform. MySQL Enterprise Encryption functions are provided by a MySQL component component_enterprise_encryption. For ...
https://dev.mysql.com/doc/refman/8.4/en/error-access-denied.html
Often the problem is related to the MySQL accounts that the server permits client programs to use when connecting. See Section 8.2, “Access Control and Account Management”, and Section 8.2.22, “Troubleshooting Problems Connecting to MySQL”.
https://dev.mysql.com/doc/refman/8.4/en/error-creating-innodb.html
The troubleshooting steps for InnoDB I/O problems depend on when the problem occurs: during startup of the MySQL server, or during normal operations when a DML or DDL statement fails due to problems at the file system level. Initialization Problems ...
https://dev.mysql.com/doc/refman/8.4/en/error-handling.html
This appendix describes the types of error information MySQL provides and how to obtain information about them. It describes common problems and errors that may occur and potential resolutions.