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/precision-math-rounding.html
This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and integer). The ROUND() function rounds differently depending on whether its argument is exact or approximate: ...
https://dev.mysql.com/doc/refman/8.0/en/primary-key-optimization.html
If your table is big and important, but does not have an obvious column or set of columns to use as a primary key, you might create a separate column with auto-increment values to use as the primary key. The primary key for a table represents the ...
https://dev.mysql.com/doc/refman/8.0/en/problems-with-mysql-sock.html
Another approach is to change the place where the server creates the Unix socket file. The default location for the Unix socket file that the server uses for communication with local clients is /tmp/mysql.sock. (For some distribution formats, the ...
https://dev.mysql.com/doc/refman/8.0/en/repeat.html
[begin_label:] REPEAT statement_list UNTIL search_condition END REPEAT [end_label] The statement list within a REPEAT statement is repeated until the search_condition expression is true. statement_list consists of one or more statements, each ...
https://dev.mysql.com/doc/refman/8.0/en/replica-connection-thread-states.html
Opening master dump table This state occurs after Creating table from master dump. These thread states occur on a replica server but are associated with connection threads, not with the I/O or SQL threads. In MySQL 8.0.26, incompatible changes were ...
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption.html
Relay log files are encrypted for all channels, including new channels that are created after encryption is activated. From MySQL 8.0.14, binary log files and relay log files can be encrypted, helping to protect these files and the potentially ...
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-features-errors.html
For example, you might need to create a nonexistent table before you can start the replica again. If a statement produces the same error (identical error code) on both the source and the replica, the error is logged, but replication continues. If a ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-memory.html
A change in max_heap_table_size takes effect for MEMORY tables that are created or updated using ALTER TABLE ... When a replication source server shuts down and restarts, its MEMORY tables become empty. To replicate this effect to replicas, the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-partitioning.html
To avoid stopping replication or creating inconsistencies between the source and replica, always ensure that a table on the source and the corresponding replicated table on the replica are partitioned in the same way. Replication is supported ...