Search Results
https://dev.mysql.com/doc/refman/8.4/en/populating-spatial-columns.html
After you have created spatial columns, you can populate them with spatial data. 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. For ...
https://dev.mysql.com/doc/refman/8.4/en/query-attributes.html
Because installing and uninstalling the query_attributes component installs and uninstalls the mysql_query_attribute_string() function that the component implements, it is not necessary to use CREATE FUNCTION or DROP FUNCTION to do so. The most ...
https://dev.mysql.com/doc/refman/8.4/en/query-log.html
The server creates the file in the data directory unless an absolute path name is given to specify a different directory. To rename the file and create a new one, use the following commands: $> mv host_name.log host_name-old.log $> mysqladmin ...
https://dev.mysql.com/doc/refman/8.4/en/range-optimization.html
The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value intervals. The following sections describe conditions under which the optimizer uses range access. Additionally, for ...
https://dev.mysql.com/doc/refman/8.4/en/reloading-delimited-text-dumps.html
For backups produced with mysqldump --tab, each table is represented in the output directory by an .sql file containing the CREATE TABLE statement for the table, and a .txt file containing the table data. To reload a table, first change location ...
https://dev.mysql.com/doc/refman/8.4/en/replica-logs-relaylog.html
Successive relay log files are created using successive sequence numbers, beginning with 000001. On a Unix system, this can be done as shown here: $> cat new_relay_log_name.index >> old_relay_log_name.index $> mv old_relay_log_name.index ... The ...
https://dev.mysql.com/doc/refman/8.4/en/replica-logs.html
A replica server creates several repositories of information to use for the replication process: The replica's relay log, which is written by the replication I/O (receiver) thread, contains the transactions read from the replication source server's ...The transactions in the relay log are applied on the replica by the replication SQL (applier) ...
https://dev.mysql.com/doc/refman/8.4/en/replica-sql-thread-states.html
Making temporary file (create) before replaying LOAD DATA INFILE The thread is executing a LOAD DATA statement and is creating a temporary file containing the data from which the replica reads rows. The following list shows the most common states ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption-key-rotation.html
If the server UUID changes, for example because a backup created using MySQL Enterprise Backup is used to set up a new replica, issuing ALTER INSTANCE ROTATE BINLOG MASTER KEY on the new server does not delete any earlier binary log encryption keys ... When binary log encryption is enabled, you can rotate the binary log master key at any time while the server is running by issuing ALTER INSTANCE ROTATE BINLOG MASTER ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption-scope.html
Note If you use LOAD DATA when binlog_format=STATEMENT is set, which is not recommended as the statement is considered unsafe for statement-based replication, a temporary file containing the data is created on the replica where the changes are ...