PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-bootstrap.html
The process of starting a group for the first time is called bootstrapping. The bootstrap should only be done by a single server, the one that starts the group and only once. The same reasoning applies to stopping and restarting the plugin with ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-online-upgrade-combining-versions.html
For optimal compatibility and performance, all members of a group should run the same version of MySQL Server and therefore of Group Replication. However, while you are in the process of upgrading an online group, in order to maximize availability, ... Group Replication is versioned according to the MySQL Server version that the Group Replication plugin was bundled ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-optimizer-statistics.html
Persistent optimizer statistics also provide control and flexibility with these additional benefits: You can use the innodb_stats_auto_recalc configuration option to control whether statistics are updated automatically after substantial changes to a ... This section describes how to configure persistent and non-persistent optimizer statistics for InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-purge-configuration.html
When the purge lag exceeds the innodb_max_purge_lag threshold, a delay is imposed on INSERT, UPDATE, and DELETE operations to allow time for purge operations to catch up. A row and its index records are only physically removed when InnoDB discards ... InnoDB does not physically remove a row from the database immediately when you delete it with an SQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-counters.html
The counters table provides running totals of events such as reads and writes for specific kernel blocks and data nodes. block_instance Block instance counter_id The counter's internal ID number; normally an integer between 1 and 10, inclusive. See ...Counts are kept from the most recent node start or restart; a node start or restart resets all counters on that ...
https://dev.mysql.com/doc/refman/8.0/en/mysqld-server.html
You can specify these options on the command line, through configuration files, or both. These variables reflect the current state and values of the startup options, some of which can be modified while the server is running. This setting modifies ...
https://dev.mysql.com/doc/refman/8.0/en/replication-problems.html
If the preceding step does not work or does not apply, try to understand whether it would be safe to make the update manually (if needed) and then ignore the next statement from the source. If you are sure that the replica started out perfectly ...
https://dev.mysql.com/doc/refman/8.0/en/test-pluggable-authentication.html
MySQL includes a test plugin that checks account credentials and logs success or failure to the server error log. This is a loadable plugin (not built in) and must be installed prior to use. Note This plugin is intended for testing and development ...The test plugin source code is separate from the server source, unlike the built-in native plugin, so it can be examined as a relatively simple example demonstrating how to write a loadable authentication ...
https://dev.mysql.com/doc/refman/8.0/en/windows-upgrading.html
Deselect all but the MySQL server product, unless you intend to upgrade other products at this time, and click Next. Prior to MySQL 8.0.16, run mysql_upgrade as Administrator to check your tables, attempt to repair them if necessary, and update your ...Significant development changes take place in non-GA releases and you may encounter compatibility issues or problems starting the ... There are two approaches for upgrading MySQL on Windows: Using ...
https://dev.mysql.com/doc/refman/8.0/en/communication-errors.html
See Section 7.1.12.3, “DNS Lookups and the Host Cache”, and Section 29.12.21.3, “The host_cache Table”. It takes more than connect_timeout seconds to obtain a connect packet. If a client successfully connects but later disconnects improperly ... If connection problems occur such as communication errors or aborted connections, use these sources of information to diagnose problems: The error ...