Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-resource-group.html
CREATE RESOURCE GROUP group_name TYPE = {SYSTEM|USER} [VCPU [=] vcpu_spec [, vcpu_spec] ...] [THREAD_PRIORITY [=] N] [ENABLE|DISABLE] vcpu_spec: {N | M - N} CREATE RESOURCE GROUP is used for resource group management (see Section 7.1.16, ...This ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-operations.html
Adding a primary key using ALGORITHM=INPLACE is only permitted when the SQL_MODE setting includes the strict_trans_tables or strict_all_tables flags; when the SQL_MODE setting is strict, ALGORITHM=INPLACE is permitted, but the statement can still ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-instrument-filtering.html
Disable all instruments: UPDATE performance_schema.setup_instruments SET ENABLED = 'NO'; Now no events are collected. The setup_instruments table lists the available instruments: mysql> SELECT NAME, ENABLED, TIMED FROM ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-tables.html
Use these instruments to enable or disable collection of individual statement event classes. However, an application that enables or disables statement instruments selectively must take into account that disabling abstract instruments also disables ...Statement events occur at a high level of the event ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication-system-variables.html
The plugin uses authentication_ldap_sasl_init_pool_size and authentication_ldap_sasl_max_pool_size together for connection-pool management: When the authentication plugin initializes, it creates authentication_ldap_sasl_init_pool_size connections, ...The file name should be given as an absolute path ...
https://dev.mysql.com/doc/refman/8.4/en/switchable-optimizations.html
Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or disabled. Command Syntax Meaning default Reset every optimization to its default value opt_name=default Set ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-restore-cluster.html
Additional options that can be employed with this command include: --disable-indexes and --disable-metadata. To cause indexes to be ignored when restoring the table data, use the --disable-indexes option. Similarly, you can cause metadata to be ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-backup-restore-fewer-data-nodes.html
Sometimes, you want to transfer data from your cluster to another one that has fewer data nodes—for example, when you want to scale down your cluster or prepare a smaller replica cluster for a replication setup. While the methods described in ...
https://dev.mysql.com/doc/refman/8.4/en/create-user.html
To require an encrypted connection, a client need specify only the --ssl-mode=REQUIRED option; the connection attempt fails if a secure connection cannot be established. For each, it disables password expiration so that the password never expires.
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbscanoperation.html
Disabling fetchAllowed by setting it to false forces NDB to process any records it already has in its caches. Disabling fetchAllowed can be useful when you want to update or delete all of the records obtained in a given transaction, as doing so ...