Search Results
https://dev.mysql.com/doc/refman/8.4/en/preface.html
This is the Reference Manual for the MySQL Database System, for the 8.4.6 LTS release. This manual is not intended for use with older versions of the MySQL software due to the many functional and other differences between MySQL 8.4 and previous ...
https://dev.mysql.com/doc/refman/8.4/en/processlist-access.html
The following sections list the possible Command values, and State values grouped by category. The following discussion enumerates the sources of process information, the privileges required to see process information, and describes the content of ...
https://dev.mysql.com/doc/refman/8.4/en/program-variables.html
Many MySQL programs have internal variables that can be set at runtime using the SET statement. See Section 15.7.6.1, “SET Syntax for Variable Assignment”, and Section 7.1.9, “Using System Variables”. Most of these program variables also ...
https://dev.mysql.com/doc/refman/8.4/en/programs-overview.html
my_print_defaults A utility that shows which options are present in option groups of option files. Later sections provide a more detailed description of each one, with the exception of NDB Cluster programs. Each program's description indicates its ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-differing-tables.html
Source and target tables for replication do not have to be identical. A table on the source can have more or fewer columns than the replica's copy of the table. In addition, corresponding table columns on the source and the replica can use ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-gtids.html
To replace the value of gtid_purged with a specified GTID set, use the following statement: SET @@GLOBAL.gtid_purged = 'gtid_set'; Group Replication must be stopped before changing the value of gtid_purged. The MySQL Server system variables ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-account.html
Instead, ensure that the default encryption setting on a replica matches the encryption status of the tablespaces that it replicates, and that replication group members have the same default encryption setting, so that the privilege is not needed.
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-recover.html
If a privilege check against the PRIVILEGE_CHECKS_USER account fails, the transaction is not executed and replication stops for the channel. Details of the error and the last applied transaction are recorded in the Performance Schema ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-switch.html
In a failover situation, all the servers in the group are typically executing the same events from the same binary log file, so changing the source of the events should not affect the structure or integrity of the database, provided that you ... You ...
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 ...