Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns.html
All of these columns are taken into account both for the purpose of placing rows in partitions and for the determination of which partitions are to be checked for matching rows in partition pruning. The next two sections discuss COLUMNS ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management.html
There are a number of ways using SQL statements to modify partitioned tables; it is possible to add, drop, redefine, merge, or split existing partitions using the partitioning extensions to the ALTER TABLE statement. There are also ways to obtain ...
https://dev.mysql.com/doc/refman/8.4/en/password-management.html
Defer to the global password verification-required policy for all accounts named by the statement: CREATE USER 'jeffrey'@'localhost' PASSWORD REQUIRE CURRENT DEFAULT; ALTER USER 'jeffrey'@'localhost' PASSWORD REQUIRE CURRENT DEFAULT; Verification of ... MySQL supports these password-management capabilities: Password expiration, to require passwords to be changed ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-build-configuration.html
Because the Performance Schema is configured into the server at build time, a row for PERFORMANCE_SCHEMA appears in the output from SHOW ENGINES. It is possible to exclude certain parts of the Performance Schema instrumentation. For example, to ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-firewall-group-allowlist-table.html
The firewall_group_allowlist table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It is used in conjunction with the mysql.firewall_group_allowlist system table that provides persistent storage of firewall data; see ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-firewall-groups-table.html
The firewall_groups table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It lists names and operational modes of registered firewall group profiles. It is used in conjunction with the mysql.firewall_groups system table ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-firewall-membership-table.html
The firewall_membership table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It is used in conjunction with the mysql.firewall_membership system table that provides persistent storage of firewall data; see MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-host-cache-table.html
The MySQL server maintains an in-memory host cache that contains client host name and IP address information and is used to avoid Domain Name System (DNS) lookups. The host_cache_size system variable controls the size of the host cache, as well as ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-miscellaneous-tables.html
The following sections describe tables that do not fall into the table categories discussed in the preceding sections: component_scheduler_tasks: The current status of each scheduled task. user_defined_functions: Loadable functions registered by a ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-applier-configuration-table.html
This is escaped so that it can be copied into an SQL statement to execute individual transactions. This table shows the configuration parameters that affect transactions applied by the replica. Parameters stored in the table can be changed at ...