Search Results
https://dev.mysql.com/doc/refman/8.4/en/binary-log-setting.html
Where possible, rows stored in the binary log are grouped into events with a size not exceeding the value of this setting. You can select the binary logging format explicitly by starting the MySQL server with --binlog-format=type. The supported ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log.html
To prevent this, enable the sync_binlog system variable to synchronize the binary log to disk after every N commit groups. The binary log contains “events” that describe database changes such as table creation operations or changes to table ...
https://dev.mysql.com/doc/refman/8.4/en/blob.html
You can make more bytes significant in sorting or grouping by increasing the value of max_sort_length at server startup or runtime. A BLOB is a binary large object that can hold a variable amount of data. These differ only in the maximum length of ...
https://dev.mysql.com/doc/refman/8.4/en/caching-sha2-pluggable-authentication.html
For Group Replication, the group_replication_recovery_public_key_path and group_replication_recovery_get_public_key system variables serve the same purpose. MySQL provides two authentication plugins that implement SHA-256 hashing for user account ...
https://dev.mysql.com/doc/refman/8.4/en/case-sensitivity.html
Simple comparison operations (>=, >, =, <, <=, sorting, and grouping) are based on each character's “sort value.” Characters with the same sort value are treated as the same character. For nonbinary strings (CHAR, VARCHAR, TEXT), string ...
https://dev.mysql.com/doc/refman/8.4/en/changing-mysql-user.html
To start the server as the given user automatically at system startup time, specify the user name by adding a user option to the [mysqld] group of the /etc/my.cnf option file or the my.cnf option file in the server's data directory. On Windows, you ...
https://dev.mysql.com/doc/refman/8.4/en/channels-commands-single-channel.html
START REPLICA and STOP REPLICAare disallowed for the group_replication_recovery and group_replication_applier channels. SHOW REPLICA STATUS is also not allowed with the group_replication_applier channel. FLUSH RELAY LOGS is allowed for the ... To ...
https://dev.mysql.com/doc/refman/8.4/en/channels-with-prev-replication.html
For example, the following statements behave as expected for all except certain Group Replication channels: START REPLICA starts replication threads for all channels, except the group_replication_recovery and group_replication_applier channels. STOP ... When a replica has multiple channels and a FOR CHANNEL channel option is not specified, a valid statement generally acts on all available channels, with some specific ...
https://dev.mysql.com/doc/refman/8.4/en/charset-charsets.html
There is one subsection for each group of related character sets. To list the available character sets and their default collations, use the SHOW CHARACTER SET statement or query the INFORMATION_SCHEMA CHARACTER_SETS table. To avoid choosing the ...
https://dev.mysql.com/doc/refman/8.4/en/charset-configuration.html
For example, to specify a directory to be used by MySQL client programs, list it in the [client] group of your option file. The MySQL server has a compiled-in default character set and collation. To change these defaults, use the ...