Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/error-log-json.html
It is permitted to name log_sink_json multiple times in the log_error_services value. If log_json_writer is named multiple times in the log_error_services value, they all write to the console, which is likely not useful. This section describes how ...
https://dev.mysql.com/events-configuration.html
row *************************** Id: 1 User: root Host: localhost db: NULL Command: Query Time: 0 State: NULL Info: show processlist *************************** 2. row *************************** Id: 2 User: event_scheduler Host: localhost db: NULL ... Events are executed by a special event scheduler thread; when we refer to the Event Scheduler, we actually refer to this ...
https://dev.mysql.com/faqs-cjk.html
Sometimes people try to insert gbk characters into gb2312, and it works most of the time because gbk is a superset of gb2312. Sometimes adding or changing a <meta> tag suffices to correct the problem: for example, to insure that the user agent ...
https://dev.mysql.com/flush.html
If the --skip-grant-tables option was specified at server startup to disable the MySQL privilege system, FLUSH PRIVILEGES provides a way to enable the privilege system at runtime. This is a very convenient way to get backups if you have a file ...| ...
https://dev.mysql.com/grant-tables.html
At startup, and at runtime when FLUSH PRIVILEGES is executed, the server checks user table rows. password_last_changed is a TIMESTAMP column indicating when the password was last changed. If the password is past its lifetime (assessed using the ...
https://dev.mysql.com/grant.html
This behavior is by design, and is intended to enable the database administrator to prepare user accounts and privileges for databases or tables that are to be created at a later time. [WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ...
https://dev.mysql.com/group-replication-adding-instances.html
It is now time to expand the group by adding the other two servers configured previously. In other words, the transactions applied on s1 up to the point in time that s2 joined the group have been replicated to s2. At this point, the group has one ...
https://dev.mysql.com/group-replication-background.html
The group can operate in a single-primary mode with automatic primary election, where only one server accepts updates at a time. There is a built-in group membership service that keeps the view of the group consistent and available for all servers ...The most common way to create a fault-tolerant system is to resort to making components redundant, in other words the component can be removed and the system should continue to operate as ...
https://dev.mysql.com/group-replication-cloning.html
To avoid this situation, ensure that you set the threshold to a number higher than the number of transactions that you would expect to occur in the group during the time taken for the remote cloning operation. A remote cloning operation might take ...If you want to use remote cloning operations for distributed recovery in a group, you must set up existing members and joining members beforehand to support this ...
https://dev.mysql.com/group-replication-communication-protocol.html
For example: SELECT group_replication_set_communication_protocol("8.0.16"); The group_replication_set_communication_protocol() UDF is implemented as a group action, so it is executed at the same time on all members of the group. If a member attempts ... From MySQL 8.0.16, Group Replication has the concept of a communication protocol for the ...
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-39.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.
