PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-adding-instances.html
It is now time to expand the group by adding the other two servers configured previously. If you did not have binary logging enabled when you configured the user credentials on s1, and a remote cloning operation is not used for state transfer, you ... At this point, the group has one member in it, server s1, which has some data in ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-background.html
The group can operate in a single-primary mode with automatic primary election, where only one server accepts updates at a time. There is a built-in group membership service that keeps the view of the group consistent and available for all servers ...The most common way to create a fault-tolerant system is to resort to making components redundant, in other words the component can be removed and the system should continue to operate as ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-statistics-table.html
To update cached values at any time for a given table, use ANALYZE TABLE. The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. Note If the innodb_read_only system variable is enabled, ...If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table statistics ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-temporary-tablespace.html
Because the pool of session temporary tablespaces is recreated each time the server is started, space IDs for session temporary tablespaces are not persisted when the server is shut down, and may be reused. The global temporary tablespace is removed ... InnoDB uses session temporary tablespaces and a global temporary ...Beginning with MySQL 8.0.16, ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-data-locks-table.html
Lock ID formats are internal and subject to change at any time. Use the data_locks table to help diagnose performance problems that occur during times of heavy concurrent load. For InnoDB, see the discussion of this topic at Section 17.15.2, ...For ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks-recover.html
You can use mysqlbinlog to retrieve and display the events that were logged around the time of the error. If a privilege check against the PRIVILEGE_CHECKS_USER account fails, the transaction is not executed and replication stops for the channel.
https://dev.mysql.com/doc/refman/8.0/en/show-profile.html
Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL release. All statements are profiled except SHOW PROFILE and SHOW PROFILES, so neither of those statements appears in the profile list.
https://dev.mysql.com/doc/refman/8.0/en/stored-routines-syntax.html
In MySQL 8.0.22 and later, a user variable referenced by a statement in a stored procedure has its type determined the first time the procedure is invoked, and retains this type each time the procedure is invoked thereafter. Stored routines are ...
https://dev.mysql.com/doc/refman/8.0/en/user-variables.html
Beginning with MySQL 8.0.22, a reference to a user variable in a prepared statement has its type determined when the statement is first prepared, and retains this type each time the statement is executed thereafter. Similarly, the type of a user ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-security-mysql-security-procedures.html
In this section, we discuss MySQL standard security procedures as they apply to running NDB Cluster. In general, any standard procedure for running MySQL securely also applies to running a MySQL Server as part of an NDB Cluster. First and foremost, ...Fortunately, this is the default behavior for a new MySQL ...