MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 241 to 250 of 769 total results

https://dev.mysql.com/doc/refman/8.0/en/partitioning-pruning.html

Some queries using BETWEEN in the WHERE clause can also take advantage of partition pruning. The optimization known as partition pruning is based on a relatively simple concept which can be described as “Do not scan partitions where there can be ...

15.7.1.8 REVOKE Statement

https://dev.mysql.com/doc/refman/8.0/en/revoke.html

[IGNORE UNKNOWN USER] REVOKE [IF EXISTS] ALL [PRIVILEGES], GRANT OPTION FROM user_or_role [, user_or_role] ... [IGNORE UNKNOWN USER] REVOKE [IF EXISTS] PROXY ON user_or_role FROM user_or_role [, user_or_role] ... [IGNORE UNKNOWN USER] REVOKE [IF ...

10.2.2.2 Optimizing Subqueries with Materialization

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

The optimizer uses materialization to enable more efficient subquery processing. Materialization speeds up query execution by generating a subquery result as a temporary table, normally in memory. The first time MySQL needs the subquery result, it ...

8.2.21 Setting Account Resource Limits

https://dev.mysql.com/doc/refman/8.0/en/user-resources.html

The following statement changes the query limit for francis to 100: mysql> ALTER USER 'francis'@'localhost' WITH MAX_QUERIES_PER_HOUR 100; The statement modifies only the limit value specified and leaves the account otherwise unchanged. Similarly, ... One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero ...

14.11 XML Functions

https://dev.mysql.com/doc/refman/8.0/en/xml-functions.html

Table 14.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in MySQL. Note It is possible to obtain ...

15.1.9.3 ALTER TABLE Examples

https://dev.mysql.com/doc/refman/8.0/en/alter-table-examples.html

For NDB tables, it is also possible to change the storage type used for a table or column. row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ...

15.7.1.1 ALTER USER Statement

https://dev.mysql.com/doc/refman/8.0/en/alter-user.html

ALTER USER permits these resource_option values: MAX_QUERIES_PER_HOUR count, MAX_UPDATES_PER_HOUR count, MAX_CONNECTIONS_PER_HOUR count For all accounts named by the statement, these options restrict how many queries, updates, and connections to the ... ALTER USER [IF EXISTS] user [auth_option] [, user [auth_option]] ...

8.4.5.7 Audit Log Filtering

https://dev.mysql.com/doc/refman/8.0/en/audit-log-filtering.html

From MySQL 8.0.28, the AUDIT_ABORT_EXEMPT privilege is available to permit a user account’s queries to always be executed even if an “abort” item would block them. Note For audit log filtering to work as described here, the audit log plugin ...

7.6.7.10 Monitoring Cloning Operations

https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-monitoring.html

You can monitor the status and progress of a cloning operation on the recipient MySQL server instance using the clone_status and clone_progress Performance Schema tables. Note The clone_status and clone_progress Performance Schema tables can be used ...

14.4.2 Comparison Functions and Operators

https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html

For additional examples of row comparisons in the context of row subqueries, see Section 15.2.15.5, “Row Subqueries”. IN() syntax can also be used to write certain types of subqueries. Table 14.4 Comparison Operators Name Description > Greater ...

Displaying 241 to 250 of 769 total results