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/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/merge-table-problems.html
If there is a difference between the tables, an error is returned and the statement fails. If you encounter an error message similar to ERROR 1017 (HY000): Can't find file: 'tbl_name.MRG' (errno: 2), it generally indicates that some of the ... The ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-geojson-functions.html
If not specified, this argument defaults to its maximum value of 232 − 1. Option Value Meaning 1 Reject the document and produce an error. If an object has a CRS that is not understood, an error occurs, with the exception that if the optional srid ... This section describes functions for converting between GeoJSON documents and spatial ...
https://dev.mysql.com/doc/refman/5.7/en/plugin-loading.html
However, if a plugin is designed such that it must be loaded and initialized during server startup, attempts to load it at runtime using INSTALL PLUGIN produce an error: mysql> INSTALL PLUGIN myplugin SONAME 'somepluglib.so'; ERROR 1721 (HY000): ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-system-variables.html
If an attempted runtime assignment to keyring_encrypted_file_data results in an error, the variable value remains unchanged. If an attempted runtime assignment to keyring_file_data results in an error, the variable value remains unchanged. If an ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-aws-plugin.html
This is a one-time operation, performed by executing the following statements, adjusting the .so suffix for your platform as necessary: CREATE FUNCTION keyring_aws_rotate_cmk RETURNS INTEGER SONAME 'keyring_aws.so'; CREATE FUNCTION ...(Its value can ... Note The keyring_aws plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/5.7/en/starting-server-troubleshooting.html
If you have problems starting the server, here are some things to try: Check the error log to see why the server does not start. If mysqld is currently running, you can find out what path settings it is using by executing this command: $> mysqladmin ... This section provides troubleshooting suggestions for problems starting the ...
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 ...