Search Results
https://dev.mysql.com/doc/refman/8.4/en/point-in-time-recovery.html
(The full backup can be made in several ways, such as those listed in Section 9.2, “Database Backup Methods”.) Point-in-time recovery then brings the server up to date incrementally from the time of the full backup to a more recent time.
https://dev.mysql.com/doc/refman/8.4/en/problems-with-null.html
When reading data with LOAD DATA, empty or missing columns are updated with ''. Under certain conditions, if you insert NULL into a TIMESTAMP column, the current date and time is inserted; this behavior depends in part on the server SQL mode (see ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-source.html
An unexpected exit of the source server and failover to the replica is lossless because the replica is up to date. This section describes the server options and system variables that you can use on replication source servers. You can specify the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync-interface.html
An unexpected exit of the source and failover to the replica is lossless because the replica is up to date. When you install the source and replica plugins for semisynchronous replication (see Section 19.4.10.1, “Installing Semisynchronous ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync.html
If your goal is to implement a fault-tolerant replication topology where all the servers receive the same transactions in the same order, and a server that crashes can rejoin the group and be brought up to date automatically, you can use Group ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-switch.html
If you are not using GTIDs for replication, then the replicas should also be run with --log-replica-updates=OFF (logging replica updates is the default). Each MySQL replica (Replica 1, Replica 2, and Replica 3) is a replica running with binary ...
https://dev.mysql.com/doc/refman/8.4/en/select-optimization.html
Keep table statistics up to date by using the ANALYZE TABLE statement periodically, so the optimizer has the information needed to construct an efficient execution plan. Queries, in the form of SELECT statements, perform all the lookup operations ...
https://dev.mysql.com/doc/refman/8.4/en/selecting-all.html
For example, you may happen to think that the birth date for Bowser doesn't seem quite right. 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 ...
https://dev.mysql.com/doc/refman/8.4/en/selecting-columns.html
If you do not want to see entire rows from your table, just name the columns in which you are interested, separated by commas.
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 ...