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-rules-channel-based-filters.html
This happens so that a replica’s GTID set stays consistent with the source’s, meaning GTID auto-positioning can be used without re-acquiring filtered out transactions each time. This section explains how to work with replication filters when ...
https://dev.mysql.com/doc/refman/9.7/en/replication-semisync-installation.html
To enable the plugins, set the appropriate system variable either at runtime using SET GLOBAL, or at server startup on the command line or in an option file. A setting listed in an option file takes effect each time the server starts.
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-mysqldump.html
If you use this approach, make sure you monitor the replication process to ensure that the time taken to run the backup does not affect the replica's ability to keep up with events from the source. Using mysqldump to create a copy of a database ...
https://dev.mysql.com/doc/refman/9.7/en/replication.html
MySQL 9.7 also supports delayed replication such that a replica deliberately lags behind the source by at least a specified amount of time; see Section 19.4.11, “Delayed Replication”. Replication enables data from one MySQL database server ...
https://dev.mysql.com/doc/refman/9.7/en/request-access.html
A '%' or blank Host value means “any host.” A '%' or blank Db value means “any database.” The server reads the db table into memory and sorts it at the same time that it reads the user table. After the server accepts a connection, it enters ...
https://dev.mysql.com/doc/refman/9.7/en/reusing-ssl-sessions.html
MySQL client programs may elect to resume a prior SSL session, provided that the server has the session in its runtime cache. Server-Side Runtime Configuration and Monitoring for SSL Session Reuse Client-Side Configuration for SSL Session Reuse ...
https://dev.mysql.com/doc/refman/9.7/en/rewriter-query-rewrite-plugin-usage.html
Rewriting Prepared Statements Prepared statements are rewritten at parse time (that is, when they are prepared), not when they are executed later. To enable or disable the plugin, enable or disable the rewriter_enabled system variable. By default, ...
https://dev.mysql.com/doc/refman/9.7/en/savepoint.html
In this case, the row lock is released in the undo.) Savepoints that were set at a later time than the named savepoint are deleted. SAVEPOINT identifier ROLLBACK [WORK] TO [SAVEPOINT] identifier RELEASE SAVEPOINT identifier InnoDB supports the SQL ...
https://dev.mysql.com/doc/refman/9.7/en/scalar-subqueries.html
In its simplest form, a subquery is a scalar subquery that returns a single value. A scalar subquery is a simple operand, and you can use it almost anywhere a single column value or literal is legal, and you can expect it to have those ...