PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/partitioning-maintenance.html
A number of table and partition maintenance tasks can be carried out on partitioned tables using SQL statements intended for such purposes. Table maintenance of partitioned tables can be accomplished using the statements CHECK TABLE, OPTIMIZE ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-asynchronous-connection-failover-managed-table.html
When you add a group member to the source list and define it as part of a managed group, the asynchronous connection failover mechanism updates the source list to keep it in line with membership changes, adding and removing group members ... This ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-asynchronous-connection-failover-table.html
When asynchronous connection failover is enabled for a group of replicas managed by Group Replication, the source lists are broadcast to all group members when they join, and also when the lists change. You set and manage source lists using the ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-numbers.html
The scope of precision math for exact-value operations includes the exact-value data types (integer and DECIMAL types) and exact-value numeric literals. Approximate-value data types and numeric literals are handled as floating-point numbers.
https://dev.mysql.com/doc/refman/8.0/en/problems-with-float.html
Floating-point numbers sometimes cause confusion because they are approximate and not stored as exact values. The FLOAT and DOUBLE data types are subject to these issues. If columns d1 and d2 had been defined as DECIMAL rather than DOUBLE, the ...A ...
https://dev.mysql.com/doc/refman/8.0/en/rebuilding-tables.html
This section describes how to rebuild or repair tables or indexes, which may be necessitated by: Changes to how MySQL handles data types or character sets. For example, an error in a collation might have been corrected, necessitating a table ...
https://dev.mysql.com/doc/refman/8.0/en/replication-administration-pausing.html
You can stop and start replication on the replica using the STOP REPLICA and START REPLICA statements. From MySQL 8.0.22, STOP SLAVE and START SLAVE are deprecated, and STOP REPLICA and START REPLICA are available to use instead. This can be useful ...The I/O (receiver) thread continues to read events from the source but they are not ...
https://dev.mysql.com/doc/refman/8.0/en/replication-channels.html
Each replication channel has its own receiver (I/O) thread, one or more applier (SQL) threads, and relay log. When transactions from a source are received by a channel's receiver thread, they are added to the channel's relay log file and passed ...
https://dev.mysql.com/doc/refman/8.0/en/replication-configuration.html
This section describes how to configure the different types of replication available in MySQL and includes the setup and configuration required for a replication environment, including step-by-step instructions for creating a new replication ...For ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-slavebaseconfig.html
With replica updates enabled, the replica writes updates that are received from a source and performed by the replica's SQL thread to the replica's own binary log. If you need to disable binary logging or replica update logging on a replica, you can ...If you are setting up multiple replicas, each one must have a unique server_id value that differs from that of the source and from any of the other ...