Search Results
https://dev.mysql.com/doc/refman/8.4/en/connection-compression-control.html
To configure that setting explicitly at startup, use these lines in the server my.cnf file: [mysqld] protocol_compression_algorithms=zlib,zstd,uncompressed To set and persist the protocol_compression_algorithms system variable to that value at ...
https://dev.mysql.com/doc/refman/8.4/en/create-logfile-group.html
You may optionally follow either or both of these with a one-letter abbreviation for an order of magnitude, similar to those used in my.cnf. CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] ...
https://dev.mysql.com/doc/refman/8.4/en/create-tablespace.html
When setting EXTENT_SIZE or INITIAL_SIZE, you may optionally follow the number with a one-letter abbreviation for an order of magnitude, similar to those used in my.cnf. The precise syntax and semantics depend on the storage engine used. MySQL NDB ...
https://dev.mysql.com/doc/refman/8.4/en/engine-condition-pushdown-optimization.html
For example, in a my.cnf file, use these lines: [mysqld] optimizer_switch=engine_condition_pushdown=off At runtime, disable condition pushdown like this: SET optimizer_switch='engine_condition_pushdown=off'; Limitations. This optimization improves ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-secure-socket-layer-support-ssl.html
Secure sockets can be used for group communication connections between members of a group. The Group Replication system variable group_replication_ssl_mode is used to activate the use of SSL for group communication connections and specify the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-backup.html
Copy your my.cnf configuration file or files to a safe place. The key to safe database management is making regular backups. Hot and cold backups are physical backups that copy actual data files, which can be used directly by the mysqld server for ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html
InnoDB Startup Options InnoDB System Variables System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- prefix. For example, to enable or disable the InnoDB adaptive hash index, you can ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-system-tablespace.html
The system tablespace is the storage area for the change buffer. It may also contain table and index data if tables are created in the system tablespace rather than file-per-table or general tablespaces. By default, a single system tablespace data ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-hashicorp-plugin.html
Note The keyring_hashicorp plugin is an extension included in MySQL Enterprise Edition, a commercial product. The keyring_hashicorp keyring plugin communicates with HashiCorp Vault for back end storage. No key information is permanently stored in ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-okv-plugin.html
For example, use these lines in the server my.cnf file, adjusting the .so suffix and directory location for your platform as necessary: [mysqld] early-plugin-load=keyring_okv.so keyring_okv_conf_dir=/usr/local/mysql/mysql-keyring-okv For additional ... Note The keyring_okv plugin is an extension included in MySQL Enterprise Edition, a commercial ...