Search Results
https://dev.mysql.com/doc/refman/8.4/en/repair-table-optimization.html
For example, add these lines to the server my.cnf file: [mysqld] myisam_sort_buffer_size=256M key_buffer_size=1G myisam_max_sort_file_size=100G These settings do not include read_buffer_size. REPAIR TABLE for MyISAM tables is similar to using ...
https://dev.mysql.com/doc/refman/8.4/en/replication-encrypted-connections.html
To use an encrypted connection for the transfer of the binary log required during replication, both the source and the replica servers must support encrypted network connections. If either server does not support encrypted connections (because it ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-masterbaseconfig.html
Note The following options also have an impact on the source: For the greatest possible durability and consistency in a replication setup using InnoDB with transactions, you should use innodb_flush_log_at_trx_commit=1 and sync_binlog=1 in the ... To ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-disable-gtids.html
On each server, execute the following statement: SET @@global.gtid_mode = OFF; On each server, set gtid_mode=OFF in my.cnf. This section describes how to disable GTID transactions on servers that are already online. This procedure does not require ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-enable-gtids.html
On each server, execute this statement: SET @@GLOBAL.GTID_MODE = ON; On each server, add gtid-mode=ON and enforce-gtid-consistency=ON to my.cnf. This section describes how to enable GTID transactions, and optionally auto-positioning, on servers ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
In addition, setting --binlog-transaction-compression=ON on the command line or in a my.cnf file causes ndb_log_transaction_compression to be enabled on server startup. Startup Options Used with Binary Logging System Variables Used with Binary ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync-installation.html
For example, you can set the variables in my.cnf files on the source and replica servers as follows. Semisynchronous replication is implemented using plugins, which must be installed on the source and on the replicas to make semisynchronous ...
https://dev.mysql.com/doc/refman/8.4/en/replication-setup-replicas.html
Note The contents of the replica's connection metadata repository override some of the server options specified on the command line or in my.cnf. Before you proceed, ensure that you have: Configured the source with the necessary configuration ...
https://dev.mysql.com/doc/refman/8.4/en/roles.html
To specify mandatory roles at server startup, define mandatory_roles in your server my.cnf file: [mysqld] mandatory_roles='role1,role2@localhost,r3@%.example.com' To set and persist mandatory_roles at runtime, use a statement like this: SET PERSIST ...Like user accounts, roles can have privileges granted to and revoked from ...
https://dev.mysql.com/doc/refman/8.4/en/security-against-attack.html
To start mysqld as a different Unix user, add a user option that specifies the user name in the [mysqld] group of the my.cnf option file where you specify server options. When you connect to a MySQL server, you should use a password. All other ...