Search Results
https://dev.mysql.com/doc/refman/8.4/en/commit.html
To disable autocommit mode for each new connection, see the description of the autocommit system variable at Section 7.1.8, “Server System Variables”. If the read_only system variable is enabled, explicitly starting a transaction with START ...
https://dev.mysql.com/doc/internals/en/x-protocol-notices-notices.html
Global Notices Global Notices are sent by the server in case of events happen that are unrelated to the currently active message sequence: server is shutting down node disconnected from group schema or table dropped binlog events Server Shutting ...
https://dev.mysql.com/doc/refman/8.4/en/blob.html
You can change the message buffer size by changing the value of the max_allowed_packet variable, but you must do so for both the server and your client program. A BLOB is a binary large object that can hold a variable amount of data. You can make ...These differ only in the maximum length of the values they can ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-progress-report-options.html
Warning The system variable backup_progress is not yet defined for the MySQL Server. There are two options for controlling the progress reporting function of mysqlbackup: --show-progress and --progress-interval: ...The argument of the option ...
https://dev.mysql.com/doc/refman/8.4/en/analyze-table.html
If the innodb_read_only system variable is enabled, ANALYZE TABLE may fail because it cannot update statistics tables in the data dictionary, which use InnoDB. If innodb_stats_persistent is enabled, you can change the number of random dives by ...By ...ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ...
https://dev.mysql.com/doc/internals/en/differences-master-slave.html
The following is the main rule: (P-rpl-correct) If a replication master and slave reside on identical environments (D-identical-environments) and the server states are identical (D-identical-server-states), and @@client.binlog_format!=STATEMENT, ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-optimization.html
Note If the innodb_read_only system variable is enabled, ANALYZE TABLE may fail because it cannot update statistics tables in the data dictionary, which use InnoDB. A server restart or the first opening of the mysql.index_stats and ... Applications ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-concepts.html
To change the replication mode online, it is necessary to set the gtid_mode and enforce_gtid_consistency variables using an account that has privileges sufficient to set global system variables; see Section 7.1.9.1, “System Variable Privileges”.
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-type-codes.html
For input, buffer_type indicates the type of the variable containing the value to be sent to the server. For output, it indicates the type of the variable into which a value received from the server should be stored. The value is assumed to be in ...
https://dev.mysql.com/doc/refman/8.4/en/string-functions.html
Permissible locale values are the same as the legal values for the lc_time_names system variable (see Section 12.16, “MySQL Server Locale Support”). If the secure_file_priv system variable is set to a nonempty directory name, the file to be ...