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/change-master-to.html
] CHANGE MASTER TO changes the parameters that the replica server uses for connecting to the source and for reading data from the source. It also updates the contents of the replication metadata repositories (see Section 19.2.4, “Relay Log and ...
https://dev.mysql.com/doc/refman/8.0/en/data-directory-initialization.html
After MySQL is installed, the data directory must be initialized, including the tables in the mysql system schema: For some MySQL installation methods, data directory initialization is automatic, as described in Section 2.9, “Postinstallation ...
https://dev.mysql.com/doc/refman/8.0/en/derived-table-optimization.html
The optimizer handles derived tables, view references, and common table expressions the same way: It avoids unnecessary materialization whenever possible, which enables pushing down conditions from the outer query to derived tables and produces more ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-rejoin.html
The group_replication_autorejoin_tries system variable, which is available from MySQL 8.0.16, makes a member that has been expelled or reached its unreachable majority timeout try to rejoin the group automatically. Up to MySQL 8.0.20, the value of ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-understanding-consistency-guarantees.html
In terms of distributed consistency guarantees, either in normal or failure repair operations, Group Replication has always been an eventual consistency system. This means that as soon as the incoming traffic slows down or stops, all group members ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-pool-stats-table.html
The INNODB_BUFFER_POOL_STATS table provides much of the same buffer pool information provided in SHOW ENGINE INNODB STATUS output. Much of the same information may also be obtained using InnoDB buffer pool server status variables. The idea of ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-internals.html
This section describes some internal implementation details about compression for InnoDB tables. The information presented here may be helpful in tuning for performance, but is not necessary to know for basic use of compression. Compression ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-persistent-stats.html
The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given query.
https://dev.mysql.com/doc/refman/8.0/en/internal-locking.html
This section discusses internal locking; that is, locking performed within the MySQL server itself to manage contention for table contents by multiple sessions. This type of locking is internal because it is performed entirely by the server and ...
https://dev.mysql.com/doc/refman/8.0/en/json.html
The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON columns. JSON documents stored in JSON columns are converted to an internal format that permits ...