Search Results
https://dev.mysql.com/doc/refman/8.4/en/faqs-mysql-cluster.html
What is the difference between using NDB Cluster versus using MySQL Replication? In traditional MySQL replication, a source MySQL server updates one or more replicas. If a transaction-safe engine such as InnoDB is being used, a transaction is either ... In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-apt-repo.html
Although this is not required for each update, it does update MySQL repository information to include the current information, which includes adding a new LTS series. Update package information from the MySQL APT repository with the following ...
https://dev.mysql.com/doc/refman/8.4/en/server-options.html
mysqld_safe reads options from the [mysqld], [server], [mysqld_safe], and [safe_mysqld] groups. For more precise control over the server SQL mode, use the --sql-mode option instead. See Section 1.7, “MySQL Standards Compliance”, and Section ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-reference.html
enforce_gtid_consistency: Prevents execution of statements that cannot be logged in transactionally safe manner. gtid_mode: Controls whether GTID based logging is enabled and what type of transactions logs can contain. relay_log_recovery: Whether ...
https://dev.mysql.com/doc/ndbapi/en/mgm-functions-error-handling.html
Prior to NDB 7.4.8, this function was not safe for use with NULL. In later versions, ndb_mgm_get_latest_error() is null-safe but returns an arbitrary value. Prior to NDB 7.4.8, this function was not safe for use with NULL. In later versions, ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
For a unique index, an error occurs regardless of SQL mode because reducing the index length might enable insertion of nonunique entries that do not meet the specified uniqueness requirement. If the NO_ZERO_DATE or NO_ZERO_IN_DATE SQL mode is ...| ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-nutshell.html
For more information, see the descriptions of the gtid_next system variable and the TRANSACTION_GTID_TAG privilege, as well as Section 19.1.4, “Changing GTID Mode on Online Servers”. (Previously, when MTA was enabled and the user attempted to ...
https://dev.mysql.com/doc/mysql-installer/en/MySQLInstallerConsole.html
For example, to show the console's help: MySQLInstallerConsole.exe --help =================== Start Initialization =================== MySQL Installer is running in Community mode Attempting to update manifest. Possible actions are: [--]configure, ... MySQLInstallerConsole.exe provides command-line functionality that is similar to MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-repair-options.html
--safe-recover, -o Command-Line Format --safe-recover Do a repair using an old recovery method that reads through all rows in order and updates all index trees based on the rows found. --keys-used=val, -k val Command-Line Format --keys-used=val Type ...--correct-checksum Command-Line Format --correct-checksum Correct the checksum information for the ...
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
To make sure that you can take advantage of any new capabilities, update your grant tables to the current structure whenever you upgrade MySQL. The creating session can perform any operation on the table, such as DROP TABLE, INSERT, UPDATE, or ...