Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/replication-features-differing-tables.html
A column's default value is determined by a number of factors, including its type, whether it is defined with a DEFAULT option, whether it is declared as NULL, and the server SQL mode in effect at the time of its creation; for more information, see ... Source and target tables for replication do not have to be ...
https://dev.mysql.com/replication-features-memory.html
To replicate this effect to slaves, the first time that the master uses a given MEMORY table after startup, it logs an event that notifies slaves that the table must be emptied by writing a DELETE statement for that table to the binary log. When a ...
https://dev.mysql.com/replication-features-transaction-inconsistencies.html
When using a multithreaded slave, workers which have not received an error complete their queues, so it may take time to stop all threads. After this timeout, the coordinator gives up and aborts the transaction. After this timeout, it aborts the ...
https://dev.mysql.com/replication-group-member-stats-table.html
The replication_group_member_stats table has the following columns: CHANNEL_NAME Name of the Group Replication channel VIEW_ID Current view identifier for this group. This has a different value for each member in the group. This also serves as a key ...
https://dev.mysql.com/replication-group-members-table.html
UNREACHABLE: The failure detection process suspects that this member cannot be contacted, because the group messages have timed out. This table shows network and status information for replication group members. The network addresses shown are the ...
https://dev.mysql.com/replication-gtids-functions.html
WAIT_FOR_EXECUTED_GTID_SET(gtid_set[, timeout]) Wait until the server has applied all of the transactions whose global transaction identifiers are contained in gtid_set. The optional timeout stops the function from waiting after the specified number ... MySQL includes some built-in (native) functions for use with GTID-based ...
https://dev.mysql.com/replication-mode-change-online-concepts.html
The valid values for gtid_mode are as follows and in this order: OFF OFF_PERMISSIVE ON_PERMISSIVE ON It is important to note that the state of gtid_mode can only be changed by one step at a time based on the above order. To be able to safely ...
https://dev.mysql.com/replication-mode-change-online-disable-gtids.html
If you use binary logs for anything else than replication, for example to do point in time backup or restore: wait until you do not need the old binary logs having GTID transactions. This section describes how to disable GTID transactions on ...
https://dev.mysql.com/replication-problems.html
Many users have lost time by not doing this soon enough after encountering problems. If you have followed the instructions but your replication setup is not working, the first thing to do is check the error log for messages. If you cannot tell from ...
https://dev.mysql.com/replication-rbr-usage.html
You can switch from statement-based to row-based binary logging format at runtime even when temporary tables have been created. However, in MySQL 8.0, you cannot switch from row-based or mixed format for binary logging to statement-based format at ... MySQL uses statement-based logging (SBL), row-based logging (RBL) or mixed-format ...
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-fct-time-p-79.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
