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/replication-features-transaction-inconsistencies.html
The global setting for the system variable rpl_stop_replica_timeout (from MySQL 8.0.26) or rpl_stop_slave_timeout (before MySQL 8.0.26) is unrelated to the process of stopping the replication threads. To avoid gaps occurring on a multithreaded ...
https://dev.mysql.com/doc/refman/8.0/en/start-replica.html
From MySQL 8.0.22, use START REPLICA in place of START SLAVE, which is deprecated from that release. Important The password that you set using START REPLICA is masked when it is written to MySQL Server’s logs, Performance Schema tables, and SHOW ... START REPLICA [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ...
https://dev.mysql.com/doc/refman/8.0/en/starting-server.html
(For Windows, see Section 2.3.4.5, “Starting the Server for the First Time”.) For some suggested commands that you can use to test whether the server is accessible and working properly, see Section 2.9.3, “Testing the Server”. Start the ...
https://dev.mysql.com/doc/refman/8.0/en/blob.html
MySQL Connector/ODBC defines BLOB values as LONGVARBINARY and TEXT values as LONGVARCHAR. You can make more bytes significant in sorting or grouping by increasing the value of max_sort_length at server startup or runtime. For example, both mysql and ... A BLOB is a binary large object that can hold a variable amount of ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode.html
MySQL supports these Unicode character sets: utf8mb4: A UTF-8 encoding of the Unicode character set using one to four bytes per character. This character set is deprecated in MySQL 8.0, and you should use utf8mb4 instead. Deprecated in MySQL 8.0.28; ... The Unicode Standard includes characters from the Basic Multilingual Plane (BMP) and supplementary characters that lie outside the ...
https://dev.mysql.com/doc/refman/8.0/en/checking-gpg-signature-windows.html
The Section 2.1.4.2, “Signature Checking Using GnuPG” section describes how to verify MySQL downloads using GPG. The dialog should look similar to: Figure 2.1 Kleopatra: Initial Screen Next, add the MySQL Release Engineering certificate. Type ...That guide also applies to Microsoft Windows, but another option is to use a GUI tool like ...
https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html
Column Count Limits Row Size Limits Column Count Limits MySQL has hard limit of 4096 columns per table, but the effective maximum may be less for a given table. Row Size Limits The maximum row size for a given table is determined by several factors: ... This section describes limits on the number of columns in tables and the size of individual ...
https://dev.mysql.com/doc/refman/8.0/en/error-message-elements.html
This section discusses how error messages originate within MySQL and the elements they contain. The MySQL server writes some error messages to its error log. The MySQL client library takes errors received from the server and makes them available to ...These indicate issues of interest to database administrators or that require DBA ...
https://dev.mysql.com/doc/refman/8.0/en/example-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...
https://dev.mysql.com/doc/refman/8.0/en/gis-data-formats.html
Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary (WKB) format Internally, MySQL stores geometry values in a format that is not identical to either WKT or WKB format.