PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/group-replication-bootstrap.html
The process of starting a group for the first time is called bootstrapping. If it is saved in the option file, upon restart the server automatically bootstraps a second group with the same name. The importance of the binary log entries is ...The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-migration.html
In conjunction with the MySQL binary log, you can perform point-in-time recovery. Start a second mysqld server on the backup and let it clean up the .ibd files in the backup. Restoring from a Logical Backup You can use a utility such as mysqldump to ... This section describes techniques for moving or copying some or all InnoDB tables to a different server or ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-management.html
The second method involves studying the contents of the cluster log ndb_node_id_cluster.log; this is usually found in the management server's DataDir directory, but this location can be overridden using the LogDestination option. More detailed ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-multi-source.html
This does not automatically create binary logs on the second NDB Cluster's SQL node acting as the replica; in order to cause the binary logs to be created, you must issue a SHOW TABLES statement on that SQL node; this should be done prior to running ... It is possible to use NDB Cluster for bidirectional replication between two clusters, as well as for circular replication between any number of ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-operations-per-fragment.html
The table_id column value is unique at any given time, but can be reused if the corresponding object has been deleted. Generally, such a refusal is due to duplicate keys (inserts), Key not found errors (updates, deletes, and reads), or the operation ... The operations_per_fragment table provides information about the operations performed on individual fragments and fragment replicas, as well as about some of the results from these ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-restrictions.html
In MySQL, it can produce nondeterministic results because f() might be executed a different number of times for different executions of a given query depending on how the optimizer chooses to handle it. FROM t...) AS dt ...); Here the result from ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-foreign-keys.html
A duplicate symbol results in an error similar to: ERROR 1005 (HY000): Can't create table 'test.fk1' (errno: 121). Hidden columns that InnoDB adds to an index are also considered (see Section 14.6.2.1, “Clustered and Secondary Indexes”). Prior ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/5.7/en/event-scheduler-thread-states.html
These states occur for the Event Scheduler thread, threads that are created to execute scheduled events, or threads that terminate the scheduler. Clearing The scheduler thread or a thread that was executing an event is terminating and is about to ...Waiting for next activation The scheduler has a nonempty event queue but the next activation is in the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-system-tablespace.html
For example, this tablespace has one auto-extending data file: innodb_data_home_dir = innodb_data_file_path = /ibdata/ibdata1:10M:autoextend Suppose that the data file has grown to 988MB over time. If you encounter this error, restore the previous ... The system tablespace is the storage area for the InnoDB data dictionary, the doublewrite buffer, the change buffer, and undo ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-auto-positioning.html
This GTID set is equal to the union of the set of GTIDs in the gtid_executed system variable (@@GLOBAL.gtid_executed), and the set of GTIDs recorded in the Performance Schema replication_connection_status table as received transactions (the result ... GTIDs replace the file-offset pairs previously required to determine points for starting, stopping, or resuming the flow of data between source and ...