Search Results
https://dev.mysql.com/doc/refman/8.4/en/connection-control-plugin-installation.html
This section describes how to install the connection control plugins, CONNECTION_CONTROL and CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS. For general information about installing plugins, see Section 7.6.1, “Installing and Uninstalling Plugins”.
https://dev.mysql.com/doc/refman/8.4/en/connection-control-plugin-variables.html
This section describes the system and status variables that the CONNECTION_CONTROL plugin provides to enable its operation to be configured and monitored. If an account has reached the point where connection responses are delayed, a delay also ...
https://dev.mysql.com/doc/refman/8.4/en/connection-interfaces.html
In this connection thread model, there are as many threads as there are clients currently connected, which has some disadvantages when server workload must scale to handle large numbers of connections. MySQL Enterprise Edition includes a thread pool ... This section describes aspects of how the MySQL server manages client ...
https://dev.mysql.com/doc/refman/8.4/en/create-database.html
The permitted values are 'Y' (encryption enabled) and 'N' (encryption disabled). CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_option] ... create_option: [DEFAULT] { CHARACTER SET [=] charset_name | COLLATE [=] collation_name | ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-gipks.html
By default, the value of sql_generate_invisible_primary_key is OFF, meaning that the automatic addition of GIPKs is disabled. MySQL 8.4 supports generated invisible primary keys for any InnoDB table that is created without an explicit primary key.
https://dev.mysql.com/doc/refman/8.4/en/create-table-ndb-comment-options.html
1 is the default for READ_BACKUP, and the default for ndb_read_backup is ON (previously, read from any replica was disabled by default). NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the ...
https://dev.mysql.com/doc/refman/8.4/en/create-tablespace.html
The ENCRYPTION clause enables or disables page-level data encryption for an InnoDB general tablespace. If CREATE TABLESPACE parameters are incorrect or incompatible, the operation fails regardless of the innodb_strict_mode setting. TABLESPACE, ...
https://dev.mysql.com/doc/refman/8.4/en/create-temporary-table.html
If innodb_strict_mode is disabled, warnings are issued and the temporary table is created using a non-compressed row format. When innodb_strict_mode is enabled (the default), CREATE TEMPORARY TABLE returns an error if ROW_FORMAT=COMPRESSED or ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-type-syntax.html
If explicit_defaults_for_timestamp is disabled, the server handles TIMESTAMP as follows: Unless specified otherwise, the first TIMESTAMP column in a table is defined to be automatically set to the date and time of the most recent modification if not ... The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and ...
https://dev.mysql.com/doc/refman/8.4/en/ddl-rewriter-installation.html
Note If installed, the ddl_rewriter plugin involves some minimal overhead even when disabled. This section describes how to install or uninstall the ddl_rewriter plugin. For general information about installing plugins, see Section 7.6.1, ...