PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-options-gtids.html
If you are restoring a backup that is disjoint from the transactions that are already on the server, for example provisioning a multi-source replica using dumps from two different servers, use the second method of adding to the value of gtid_purged.
https://dev.mysql.com/doc/refman/9.7/en/replication-options-source.html
rpl_semi_sync_master_timeout Command-Line Format --rpl-semi-sync-master-timeout=# Deprecated Yes System Variable rpl_semi_sync_master_timeout Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 10000 Minimum Value 0 Maximum ... This section describes the server options and system variables that you can use on replication source ...
https://dev.mysql.com/doc/refman/9.7/en/replication-rules-channel-based-filters.html
The second channel to attempt it skips the transaction using GTID auto-skip, because the transaction’s GTID was added to the gtid_executed set by the first channel. This section explains how to work with replication filters when multiple ...
https://dev.mysql.com/doc/refman/9.7/en/replication-semisync-interface.html
rpl_semi_sync_source_timeout A value in milliseconds that controls how long the source waits on a commit for acknowledgment from a replica before timing out and reverting to asynchronous replication. When you install the source and replica plugins ...
https://dev.mysql.com/doc/refman/9.7/en/reproducible-test-case.html
For information about steps to take when encountering InnoDB table corruption, see Section 1.6, “How to Report Bugs or Problems”. If you encounter corrupted MyISAM tables or if mysqld always fails after some update statements, you can test ...
https://dev.mysql.com/doc/refman/9.7/en/resignal.html
ERROR 1051 (42S02): Unknown table 'xx' At this point, the contents of the first (current) and second (stacked) diagnostics areas are the same. RESIGNAL may change some or all information before passing it on. RESIGNAL is related to SIGNAL, but ...
https://dev.mysql.com/doc/refman/9.7/en/roles.html
Like user accounts, roles can have privileges granted to and revoked from them. A user account can be granted roles, which grants to the account the privileges associated with each role. This enables assignment of sets of privileges to accounts and ...
https://dev.mysql.com/doc/refman/9.7/en/scheduler-component.html
The scheduler component provides an implementation of the mysql_scheduler service that enables applications, components, or plugins to configure, run, and unconfigure tasks every N seconds. Note The scheduler component is included in MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/select-benchmarking.html
It shows that MySQL can execute 1,000,000 simple addition expressions in 0.32 seconds on that system. To measure the speed of a specific MySQL expression or function, invoke the BENCHMARK() function using the mysql client program. The return value ...
https://dev.mysql.com/doc/refman/9.7/en/server-logs.html
MySQL Server has several logs that can help you find out what activity is taking place. The following log-specific sections provide information about the server options that enable logging. By default, the server writes files for all enabled logs ...