PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.8Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/en/replication-solutions-switch.html
If you are not using GTIDs for replication, then the replicas should also be run with --log-slave-updates=OFF (logging replica updates is the default). Each MySQL replica (Replica 1, Replica 2, and Replica 3) is a replica running with binary logging ... You can tell a replica to change to a new source using the CHANGE REPLICATION SOURCE TO statement (prior to MySQL 8.0.23: CHANGE MASTER ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/server-loadable-functions.html
See Section 7.6.4, “The Rewriter Query Rewrite Plugin” Version Tokens enables creation of and synchronization around server tokens that applications can use to prevent accessing incorrect or out-of-date data. MySQL supports loadable functions, ...
https://dev.mysql.com/doc/refman/8.0/en/server-plugins.html
Version Tokens enables creation of and synchronization around server tokens that applications can use to prevent accessing incorrect or out-of-date data. MySQL supports an plugin API that enables creation of server plugins. Plugins can be loaded at ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-trigger.html
row *************************** Trigger: ins_sum sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION SQL Original Statement: CREATE DEFINER=`me`@`localhost` TRIGGER ...