Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-disable-gtids.html
The file and channel names are strings; both of these must be quoted when used in the STOP REPLICA, CHANGE REPLICATION SOURCE TO, and START REPLICA statements. On each server, execute the following statement: SET @@global.gtid_mode = ON_PERMISSIVE; ... This section describes how to disable GTID transactions on servers that are already ...
https://dev.mysql.com/doc/refman/8.4/en/reset-binary-logs-and-gtids.html
The value of the gtid_purged system variable is set to an empty string (''), the global value (but not the session value) of the gtid_executed system variable is set to an empty string, and the mysql.gtid_executed table is cleared (see ... Note This ...
https://dev.mysql.com/doc/refman/8.4/en/reusing-ssl-sessions.html
For example: mysql> ssl_session_data_print ~/private-dir/session.txt Session data are obtained in the form of a null-terminated, PEM encoded ANSI string. If you omit the path and file name, the string prints to standard output. MySQL client ...
https://dev.mysql.com/doc/refman/8.4/en/show-collation.html
Sortlen This is related to the amount of memory required to sort strings expressed in the character set. This attribute affects whether trailing spaces are significant in string comparisons; for more information, see Trailing Space Handling in ...
https://dev.mysql.com/doc/refman/8.4/en/show-replica-status.html
An error number of 0 and message of the empty string mean “no error.” If the Last_IO_Error value is not empty, the error values also appear in the replica's error log. An error number of 0 and message of the empty string mean “no error.” If ... SHOW REPLICA STATUS [FOR CHANNEL channel] This statement provides status information on essential parameters of the replica ...
https://dev.mysql.com/doc/refman/8.4/en/sys-execute-prepared-stmt.html
Given an SQL statement as a string, executes it as a prepared statement. Parameters in_query LONGTEXT CHARACTER SET utf8mb3: The statement string to execute. The prepared statement is deallocated after execution, so it is not subject to reuse.
https://dev.mysql.com/doc/refman/8.4/en/working-with-null.html
A common error when working with NULL is to assume that it is not possible to insert a zero or an empty string into a column defined as NOT NULL, but this is not the case. The NULL value can be surprising until you get used to it. Conceptually, ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-commands-single-file.html
The --src-entry=string option can be used for selective extraction of files or directories whose path names in the image contain the string specified with the option. Besides the commands for creating and restoring single-file backups (namely, ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-partial-options.html
--include-tables=REGEXP Command-Line Format --include-tables=REGEXP Type String Include for backup or restoration only those tables (both Innodb and non-Innodb) whose fully qualified names (in the form of db_name.table_name) match the regular ... To ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/partial.html
For each table with a per-table data file a string of the form db_name.table_name is checked against the regular expression specified with the --include option. If the regular expression matches the complete string db_name.table_name, the table is ... By default, all the files under the database subdirectories in the data directory are included in the backup, so that the backup includes data from all MySQL storage engines, any third-party storage engines, and even any non-database files in that ...