Search Results
https://dev.mysql.com/doc/mysqld-version-reference/en/optvar-changes-8-0.html
The following list details the changes to specific options and variables within MySQL 8.0.
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-replicationsource-category.html
Enforce Gtid Consistency Enabled Allows execution of only those statements that can be logged in a transactionally safe manner. Lists the Replication Source configuration metrics and provides a brief description of each. Table 7.28 Replication ...
https://dev.mysql.com/doc/refman/8.4/en/charset-restrictions.html
However, you can perform IN BOOLEAN MODE searches on the column without an index. The REGEXP and RLIKE operators work in byte-wise fashion, so they are not multibyte safe and may produce unexpected results with multibyte character sets. Identifiers ...
https://dev.mysql.com/doc/refman/8.4/en/data-directory-initialization.html
(For upgrades to an existing installation, perform the upgrade procedure instead; see Chapter 3, Upgrading MySQL.) However, the command that initializes the data directory does not overwrite any existing mysql schema tables, so it is safe to run in ... After MySQL is installed, the data directory must be initialized, including the tables in the mysql system schema: For some MySQL installation methods, data directory initialization is automatic, as described in Section 2.9, “Postinstallation Setup and ...
https://dev.mysql.com/doc/refman/8.4/en/load-data-local-security.html
To avoid connecting to untrusted servers, clients can establish a secure connection and verify the server identity by connecting using the --ssl-mode=VERIFY_IDENTITY option and the appropriate CA certificate. The utilities handle the file transfer ... The LOAD DATA statement loads a data file into a ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-tables.html
The replication_applier_status_by_worker table is nonempty only when the replica is operating in multithreaded mode. It refers to the master.info file used for the replica's source metadata repository, which has been superseded by the use of ...This ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-install-agent-windows-service.html
The installation also configures the agent to start automatically whenever Windows starts, and to shut down safely whenever Windows shuts down. Important Installation of the MySQL Cluster Manager agent as a service is recommended. However, you ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-session-track-get-first.html
(For isolation level and access mode, these defaults are given by the session values of the transaction_isolation and transaction_read_only system variables.) If a transaction was explicitly started, the string contains the statement or statements ... int mysql_session_track_get_first(MYSQL *mysql, enum enum_session_state_type type, const char **data, size_t *length) Description MySQL implements a session tracker mechanism whereby the server returns information about session state changes to ...
https://dev.mysql.com/doc/refman/8.4/en/analyze-table.html
ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ... [WITH N BUCKETS] [{MANUAL | AUTO} UPDATE] ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [USING DATA 'json_data'] ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-isolation-levels.html
For locking reads (SELECT with FOR UPDATE or FOR SHARE), UPDATE, and DELETE statements, locking depends on whether the statement uses a unique index with a unique search condition, or a range-type search condition. It is not recommended to mix ...