PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-partitioning.html
If you have data that must be synchronized to the replicas before replication starts, you have a number of choices: Synchronize all the data to each replica, and delete the databases, tables, or both that you do not want to keep. Use mysqldump to ...
https://dev.mysql.com/doc/refman/8.0/en/insert.html
Data conversions that would trigger errors abort the statement if IGNORE is not specified. If any of the rows to be inserted by a given INSERT statement do not match one of the partitions listed, the INSERT statement fails with the error Found a row ...SET forms of the statement insert rows based on explicitly specified ... INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-operation.html
Thus, given a mix of statements for InnoDB and MyISAM tables, the thread pool prioritizes those for InnoDB over those for MyISAM unless autocommit is enabled. To establish a privileged connection, the user initiating the connection must have the ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-tuning.html
Recommended values for this option depend on whether the primary storage engine in use is InnoDB or MyISAM: If the primary storage engine is InnoDB, the recommended value for the thread pool size is the number of physical cores available on the host ... This section provides guidelines on determining the best configuration for thread pool performance, as measured using a metric such as transactions per ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-generated-columns.html
CREATE TABLE t1 (c1 INT); ALTER TABLE t1 ADD COLUMN c2 INT GENERATED ALWAYS AS (c1 + 1) STORED; The data type and expression of generated columns can be modified. CREATE TABLE t1 (c1 INT, c2 INT GENERATED ALWAYS AS (c1 + 1) STORED); ALTER TABLE t1 ...CREATE TABLE t1 (c1 INT, c2 INT GENERATED ALWAYS AS (c1 + 1) STORED); ALTER TABLE t1 MODIFY COLUMN c2 TINYINT GENERATED ALWAYS AS (c1 + 5) STORED; Generated columns can be renamed or dropped, if no other column refers to ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-security-networking-issues.html
Applications using the cluster and user of those applications must not be permitted to have direct access to the management and data node hosts. It is extremely important to remember that NDB Cluster “out of the box” is not secure; you or your ... In this section, we discuss basic network security issues as they relate to NDB ...Also see Section 25.4.1, “Quick ...
https://dev.mysql.com/doc/refman/8.0/en/macos-installation-launchd.html
The md5 checksum of a file containing the above snippet is d925f05f6d1b6ee5ce5451b596d6baed. Figure 2.18 MySQL Preference Pane: Location The Instances page includes an option to start or stop MySQL, and Initialize Database recreates the data/ ...To ... macOS uses launch daemons to automatically start, stop, and manage processes and applications such as ...
https://dev.mysql.com/doc/refman/8.0/en/server-option-variable-reference.html
The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables (System Var), and status variables (Status var) in one unified list, with an indication of where each option or variable is ... The following table lists all command-line options, system variables, and status variables applicable within ...For a version of this ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-online-upgrade-methods.html
For groups operating in single-primary mode, the asynchronous replication connection to the old group must send data to the primary in the new group, for a multi-primary group the asynchronous replication channel can connect to any primary. For ...
https://dev.mysql.com/doc/refman/8.0/en/lock-instance-for-backup.html
Operations that modify InnoDB files that are not recorded in the InnoDB redo log are also blocked. PURGE BINARY LOGS should not be issued while a LOCK INSTANCE FOR BACKUP statement is in effect for the instance, because it contravenes the rules of ...Executing the LOCK INSTANCE FOR BACKUP statement requires the BACKUP_ADMIN ... LOCK INSTANCE FOR BACKUP UNLOCK INSTANCE LOCK INSTANCE FOR BACKUP acquires an instance-level backup lock that permits DML during an online ...