Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-options-variables.html
This option is useful only when running mysqld on host machines having multiple CPUs, multiple cores, or both. When this option is enabled, and both --ndb-log-updated-only and --ndb-log-update-minimal are disabled, operations of different types are ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html
The --dns-srv-name option takes precedence over the --host option if both are given. The --dns-srv-name option takes precedence over the --host option if both are given. For example, to explicitly disable local data loading except for files located ... mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-nutshell.html
Setting gtid_next to AUTOMATIC:TAG or UUID:TAG:NUMBER requires a new TRANSACTION_GTID_TAG privilege which is added in this release; this is true both on the originating server as well as for the PRIVILEGE_CHECKS_APPLIER for the replica applier ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-howto.html
The key steps in this startup process for the simplest possible GTID replication topology, consisting of one source and one replica, are as follows: If replication is already running, synchronize both servers by making them read-only. Restart both ... This section describes a process for configuring and starting GTID-based replication in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/select.html
SELECT supports explicit partition selection using the PARTITION clause with a list of partitions or subpartitions (or both) following the name of the table in a table_reference (see Section 15.2.13.2, “JOIN Clause”). Because MySQL also permits ... SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr] ...
https://dev.mysql.com/doc/workbench/en/wb-data-modeling-menus.html
The following submenu items apply to the active model tab, EER diagram tab, or both: New Model: Opens a new MySQL Model tab and closes the tabs of a previously opened model and diagram. Close Tab: If selected when the MySQL Model tab is shown, the ... Some menu items are not available in the MySQL Workbench Community Edition of this application, and are available only in the MySQL Workbench Commercial ...
https://dev.mysql.com/doc/workbench/en/wb-database-synchronization.html
These three types can be the target (destination), source, or both. Synchronize both the model and live database, or only update one or the other (unidirectional or bidirectional). Figure 9.57 Model and Database Differences In the preceding example, ...You can also select or deselect individual objects and modify their direction during the ...
https://dev.mysql.com/doc/relnotes/connector-python/en/news-8-0-12.html
Deprecation and Removal Notes Installation Notes Functionality Added or Changed Bugs Fixed Deprecation and Removal Notes Deprecated the Row.get_string() method in favor of __getitem__. (Bug #26834200, Bug #87777) To increase compliance with the X ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/glossary.html
circular replication In a replication configuration, a topology where every server is both a source and a replica, connected to two other servers, forming a ring structure. In complex topologies, a server can be both a master and a slave, known as a ... These terms are commonly used in information about MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
For both InnoDB and MyISAM, if the value is less than or equal to the maximum value currently in the AUTO_INCREMENT column, the value is reset to the current maximum AUTO_INCREMENT column value plus one. They have these comparative characteristics: ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...