Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-backups-mysqldump.html
Because the format of the information is SQL statements, the file can easily be distributed and applied to running servers in the event that you need access to the data in an emergency. Using mysqldump to create a copy of a database enables you to ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-backups-rawdata.html
If your replica is replicating LOAD DATA statements, you should also back up any SQL_LOAD-* files that exist in the directory that the replica uses for this purpose. To guarantee the integrity of the files that are copied, backing up the raw data ...
https://dev.mysql.com/doc/refman/8.4/en/replication-threads.html
When a START REPLICA statement is issued on a replica server, the replica creates an I/O (receiver) thread, which connects to the source and asks it to send the updates recorded in its binary logs. MySQL replication capabilities are implemented ...
https://dev.mysql.com/doc/refman/8.4/en/replication-upgrade.html
This can happen if the source uses statements or relies on behavior that is no longer supported in the later release installed on the replica. When you upgrade servers that participate in a replication topology, you need to take into account each ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-installation.html
To verify that, connect to the server and execute this statement: mysql> SHOW GLOBAL VARIABLES LIKE 'rewriter_enabled'; +------------------+-------+ | Variable_name | Value | +------------------+-------+ | rewriter_enabled | ON | ... Note If ...
https://dev.mysql.com/doc/refman/8.4/en/row-subqueries.html
Scalar or column subqueries return a single value or a column of values. A row subquery is a subquery variant that returns a single row and can thus return more than one column value. If this row has col3 and col4 values equal to the col1 and col2 ...
https://dev.mysql.com/doc/refman/8.4/en/scalar-subqueries.html
If a statement permits only a literal value, you cannot use a subquery. In its simplest form, a subquery is a scalar subquery that returns a single value. A scalar subquery is a simple operand, and you can use it almost anywhere a single column ...
https://dev.mysql.com/doc/refman/8.4/en/select-benchmarking.html
The return value is always zero, but mysql prints a line displaying approximately how long the statement took to execute. To measure the speed of a specific MySQL expression or function, invoke the BENCHMARK() function using the mysql client ...
https://dev.mysql.com/doc/refman/8.4/en/selecting-all.html
Fix only the erroneous record with an UPDATE statement: mysql> UPDATE pet SET birth = '1989-08-31' WHERE name = 'Bowser'; The UPDATE changes only the record in question and does not require you to reload the table. For example, you may happen to ...
https://dev.mysql.com/doc/refman/8.4/en/selecting-rows.html
As shown in the preceding section, it is easy to retrieve an entire table. But typically you don't want to see the entire table, particularly when it becomes large. Instead, you're usually more interested in answering a particular question, in ...