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/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 ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-backups-read-only.html
This server is still running, and might be processing the binary log or update requests coming from client C2. You should not attempt to use these instructions to make a binary backup by copying files directly because the server may still have ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-partitioning.html
There may be situations where you have a single source server and want to replicate different databases to different replicas. Figure 19.2 Replicating Databases to Separate Replicas You can achieve this separation by configuring the source and ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-scaleout.html
Because replication works from the distribution of one source to one or more replicas, using replication for scale-out works best in an environment where you have a high number of reads and low number of writes/updates. Updates only occur during ...