Search Results
https://dev.mysql.com/doc/refman/8.4/en/binary-log-transaction-compression.html
Compressed transaction payloads remain in a compressed state while they are sent in the replication stream to replicas, other Group Replication group members, or clients such as mysqlbinlog. The system variables relating to binary log transaction ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-functions.html
Nine digits grouped in pattern: xxx-xxx-xxx ('-' is any separator character). Character grouped by four, except the last group, and separated by space or any other separator character (for example: xxxx-xxxx-xxxx-xx). Nine digits grouped in pattern: ...mask_canada_sin(str [, mask_char]) Masks a Canada Social Insurance Number (SIN) and returns the number with all meaningful digits replaced by 'X' ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search.html
MySQL does not permit the use of a rollup column with MATCH(); more specifically, any query matching all of the criteria listed here is rejected with ER_FULLTEXT_WITH_ROLLUP: MATCH() appears in the SELECT list, GROUP BY clause, HAVING clause, or ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html
innodb_log_file_size and innodb_log_files_in_group have since been deprecated, and superseded by innodb_redo_log_capacity. innodb_flush_log_at_timeout allows the timeout period between flushes to be increased in order to reduce flushing and avoid ...
https://dev.mysql.com/doc/refman/8.4/en/using-systemd.html
For a command such as this: systemctl start mysqld@replica01 systemd starts the server using a command such as this: mysqld --defaults-group-suffix=@%I ... The result is that the [server], [mysqld], and [mysqld@replica01] option groups are read and ...If you install MySQL from a source distribution on a platform that uses systemd, obtain systemd support for MySQL by configuring the distribution using the -DWITH_SYSTEMD=1 CMake ...
https://dev.mysql.com/doc/refman/8.4/en/window-function-descriptions.html
CUME_DIST() over_clause Returns the cumulative distribution of a value within a group of values; that is, the percentage of partition values less than or equal to the value in the current row. This function assigns consecutive ranks to peer groups; ... This section describes nonaggregate window functions that, for each row from a query, perform a calculation using rows related to that ...
https://dev.mysql.com/doc/refman/8.4/en/windows-start-service.html
It reads options from the [mysqld] group and the group that has the same name as the service in the standard option files. This enables you to use the [mysqld] group for options that should be used by all MySQL services, and an option group with the ... On Windows, the recommended way to run MySQL is to install it as a Windows service, so that MySQL starts and stops automatically when Windows starts and ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/create-cluster.html
Attempting to manually change the configuration of Group Replication on an instance once it has been added to a cluster is not supported. Pass the expelTimeout option to the dba.createCluster() operation, which configures the ... Once you have ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-limitations.html
InnoDB ClusterSet uses InnoDB Cluster technology, which in turn uses Group Replication technology. It is possible to use server instances that are part of a Group Replication group as a replica cluster, but you must completely end the Group ...The ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/reboot-outage.html
A complete outage means that group replication has stopped on all member instances. If a cluster member is in RECOVERING or ERROR, and all other members are OFFLINE or ERROR, dba.rebootClusterFromCompleteOutage() attempts to stop Group Replication ... If your cluster experiences a complete outage you can reconfigure it using ...