Search Results
https://dev.mysql.com/doc/refman/8.4/en/connection-control-plugin.html
MySQL Server includes a plugin library that enables administrators to introduce an increasing delay in server response to connection attempts after a configurable number of consecutive failed attempts. To collect information, it subscribes to the ...This capability provides a deterrent that slows down brute force attacks against MySQL user ...This plugin also exposes system variables that enable its ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin-installation.html
To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). This section describes how to install or uninstall MySQL Enterprise Data Masking and ...For ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-bootstrap.html
The bootstrap should only be done by a single server, the one that starts the group and only once. If it is saved in the option file, upon restart the server automatically bootstraps a second group with the same name. For the purpose of ... The ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-replication-group-members.html
The information is shared between all the server instances that are members of the replication group, so information on all the group members can be queried from any member. The performance_schema.replication_group_members table is used for ...The ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-upgrade.html
Note Before MySQL 8.4, a server would not join a group if it was running a lower MySQL Server version than the lowest group member's version. While you are in the process of upgrading an online group, in order to maximize availability, you might ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool-in-core-file.html
mysql> SET GLOBAL innodb_buffer_pool_in_core_file=OFF; If the innodb_buffer_pool_in_core_file variable is disabled but MADV_DONTDUMP is not supported by the operating system, or an madvise() failure occurs, a warning is written to the MySQL server ...Because the buffer pool resides in main memory, and the memory image of a running process is dumped to the core file, systems with large buffer pools can produce large core files when the mysqld process ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-create-table-external.html
mysql> SELECT @@innodb_file_per_table; +-------------------------+ | @@innodb_file_per_table | +-------------------------+ | 1 | +-------------------------+ For more information about file-per-table tablespaces, see Section 17.6.3.2, ... There are ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-performance.html
Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in progress. Reduced locking and waiting for MySQL ...Online operations read less data into the buffer pool than table-copy operations, which reduces purging of frequently accessed data from ...
https://dev.mysql.com/doc/refman/8.4/en/key-cache-restructuring.html
For example: mysql> SET GLOBAL cold_cache.key_buffer_size=4*1024*1024; If you assign to either the key_buffer_size or key_cache_block_size key cache component a value that differs from the component's current value, the server destroys the cache's ...If the cache contains any dirty blocks, the server saves them to disk before destroying and re-creating the ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-key-cache.html
It employs a cache mechanism to keep the most frequently accessed table blocks in memory: For index blocks, a special structure called the key cache (or key buffer) is maintained. When data from any table index block must be accessed, the server ...