PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-snapshot-method.html
Employing this method with a table using a storage engine that has complex caching or logging algorithms requires extra steps to produce a perfect “point in time” snapshot: the initial copy command could leave out cache information and logging ... If the source database contains existing data it is necessary to copy this data to each ...
https://dev.mysql.com/doc/refman/9.7/en/replication-solutions-backups-rawdata.html
Then you can use CHANGE REPLICATION SOURCE TO with the SOURCE_LOG_FILE and SOURCE_LOG_POS options to tell the replica to re-read the binary logs from that point. To guarantee the integrity of the files that are copied, backing up the raw data files ...
https://dev.mysql.com/doc/refman/9.7/en/replication-solutions-unexpected-replica-halt.html
Based on that position, the replication I/O thread (receiver) retrieves from the source's binary log all of the transactions that should be applied on the replica from that point on. In order for replication to be resilient to unexpected halts of ...
https://dev.mysql.com/doc/refman/9.7/en/return.html
There may be more than one if the function has multiple exit points. RETURN expr The RETURN statement terminates execution of a stored function and returns the value expr to the function caller. There must be at least one RETURN statement in a ...
https://dev.mysql.com/doc/refman/9.7/en/server-shutdown.html
If the SQL thread is in the middle of a transaction at this point, the server waits until the current replication event group (if any) has finished executing, or until the user issues a KILL QUERY or KILL CONNECTION statement. The server shutdown ...
https://dev.mysql.com/doc/refman/9.7/en/server-status-variables.html
Handler_savepoint The number of requests for a storage engine to place a savepoint. Handler_savepoint_rollback The number of requests for a storage engine to roll back to a savepoint. Innodb_buffer_pool_load_status The progress of an operation to ...
https://dev.mysql.com/doc/refman/9.7/en/set-sql-log-bin.html
If you are using GTIDs for replication, this means that even when binary logging is later enabled again, the GTIDs written into the log from this point do not account for any transactions that occurred in the meantime, so in effect those ... SET ...
https://dev.mysql.com/doc/refman/9.7/en/show-replica-status.html
You can use this value with the CHANGE REPLICATION SOURCE TO statement's SOURCE_LOG_POS option when starting a new replica from an existing replica, so that the new replica reads from this point. SHOW REPLICA STATUS [FOR CHANNEL channel] This ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-reference-systems.html
The result is georeferenced: Each point maps to a place on the globe. A spatial reference system (SRS) for spatial data is a coordinate-based system for geographic locations. There are different types of spatial reference systems: A projected SRS ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-api-prepared-statements.html
The question mark or interrogation point (?) is used as a parameter marker; parameters are updated (bound to values) beforehand, each time the statement is executed, using PreparedStatement.bind(). The prepared statement API allows supported SQL ...