Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-member-actions.html
The member action mysql_disable_super_read_only_if_primary can be set so that a group in single-primary mode stay in super read-only mode when a new primary is elected; this means that the group accepts replicated transactions only, and does not ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-read-only-instance.html
To enable read-only mode for an entire MySQL instance, specify the following configuration options at server startup: --innodb-read-only=1 If the instance is on read-only media such as a DVD or CD, or the /var directory is not writeable by all: ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-enable-gtids.html
Before you start, ensure that gtid_mode is OFF on all servers. The following procedure can be paused at any time and later resumed where it was, or reversed by jumping to the corresponding step of Section 19.1.4.3, “Disabling GTID Transactions ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/schema-advisor-ref.html
Default frequency 00:10:00 Default auto-close enabled no Server-Enforced Data Integrity Checking Disabled SQL Modes define what SQL syntax MySQL should support and what kind of data validation checks it should perform. If no SQL modes are enabled ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-syntax.html
Produces summarized output and sends it to stdout and to the heatwave_autopilot_report table. The silent output type is useful if human-readable output is not required; when the output is consumed by a script, for example. If a target schema is not ...
https://dev.mysql.com/doc/refman/8.4/en/update.html
UPDATE IGNORE statements, including those having an ORDER BY clause, are flagged as unsafe for statement-based replication. (This is because the order in which the rows are updated determines which rows are ignored.) Such statements produce a ...
https://dev.mysql.com/doc/connectors/en/connector-cpp-installation-binary.html
To install Connector/C++ from the command line in batch mode, use a command similar to: msiexec.exe /i packages\mysql-connector-cpp-commercial-8.X.X-winx64.msi /qn /lvx* msi_install.log ALLUSERS=1 INSTALLDIR=C:\tmp\c-cpp-unpacked INSTALLLEVEL=4 To ... To obtain a Connector/C++ binary distribution, visit the Connector/C++ downloads ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-types.html
By setting the SQL mode to the appropriate value, you can specify more exactly what kind of dates you want MySQL to support. (See Section 7.1.11, “Server SQL Modes”.) You can get MySQL to accept certain dates, such as '2009-11-31', by enabling ... The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and ...
https://dev.mysql.com/doc/refman/8.4/en/environment-variables.html
The UMASK and UMASK_DIR variables, despite their names, are used as modes, not masks: If UMASK is set, mysqld uses ($UMASK | 0600) as the mode for file creation, so that newly created files have a mode in the range from 0600 to 0666 (all values ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-boolean.html
MySQL can perform boolean full-text searches using the IN BOOLEAN MODE modifier. Thus, a boolean-mode search that contains only terms preceded by - returns an empty result. This mimics the behavior of MATCH() AGAINST() without the IN BOOLEAN MODE ...With this modifier, certain characters have special meaning at the beginning or end of words in the search ...