Search Results
https://dev.mysql.com/doc/refman/8.4/en/populating-spatial-columns.html
Values should be stored in internal geometry format, but you can convert them to that format from either Well-Known Text (WKT) or Well-Known Binary (WKB) format. After you have created spatial columns, you can populate them with spatial data. For ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-decimal-characteristics.html
(There is also a limit on how long the text of DECIMAL literals can be; see Section 14.24.3, “Expression Handling”.) Values for DECIMAL columns are stored using a binary format that packs nine decimal digits into 4 bytes. This section discusses ...
https://dev.mysql.com/doc/refman/8.4/en/purge-binary-logs.html
(Bug #18199, Bug #18453) To handle such errors, edit the .index file (which is a simple text file) manually to ensure that it lists only the binary log files that are actually present, then run again the PURGE BINARY LOGS statement that failed.
https://dev.mysql.com/doc/refman/8.4/en/query-attributes.html
The most visible part of an SQL statement is the text of the statement. Clients can also define query attributes that apply to the next statement sent to the server for execution: Attributes are defined prior to sending the statement. Attributes ...
https://dev.mysql.com/doc/refman/8.4/en/replace.html
REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ... | VALUES row_constructor_list } REPLACE [LOW_PRIORITY | DELAYED] ...
https://dev.mysql.com/doc/refman/8.4/en/replica-sql-thread-states.html
The Info column for the SQL thread may also show the text of a statement. The following list shows the most common states you may see in the State column for a replication SQL thread on a replica server. Monitoring tools that work with these ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-functions.html
The GET_LOCK(), RELEASE_LOCK(), IS_FREE_LOCK(), and IS_USED_LOCK() functions that handle user-level locks are replicated without the replica knowing the concurrency context on the source. INTO, and then store the variable in the table, like this: ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-max-allowed-packet.html
If you are replicating large column values (such as might be found in TEXT or BLOB columns) and max_allowed_packet is too small on the source, the source fails with an error, and the replica shuts down the replication I/O (receiver) thread.
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-repuser.html
Although you do not have to create an account specifically for replication, you should be aware that the replication user name and password are stored in plain text in the replica's connection metadata repository mysql.slave_master_info (see Section ... Each replica connects to the source using a MySQL user name and password, so there must be a user account on the source that the replica can use to ...
https://dev.mysql.com/doc/refman/8.4/en/replication-snapshot-method.html
This method also does not work reliably if the source and replica have different values for ft_stopword_file, ft_min_word_len, or ft_max_word_len and you are copying tables having full-text indexes. If the source database contains existing data it ...