Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/performance-schema-filtering.html
The setup_instruments table lists the instruments for which events can be collected, whether they are enabled, and (for enabled instruments) whether to collect timing information: mysql> SELECT NAME, ENABLED, TIMED FROM ... Events are processed in a ...
https://dev.mysql.com/performance-schema-statement-tables.html
For additional information about configuring event collection, see Section 26.3, “Performance Schema Startup Configuration”, and Section 26.4, “Performance Schema Runtime Configuration”. Typically, this means from the time the server gets ...
https://dev.mysql.com/performance-schema-wait-tables.html
The Performance Schema instruments waits, which are events that take time. For additional information about configuring event collection, see Section 26.3, “Performance Schema Startup Configuration”, and Section 26.4, “Performance Schema ...
https://dev.mysql.com/replication-features-functions.html
To avoid unexpected results when replicating between MySQL servers in different time zones, set the time zone on both master and slave. See also Section 17.5.1.32, “Replication and Time Zones” To explain the potential problems when replicating ... Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the slave unless row-based replication is ...
https://dev.mysql.com/replication-features-triggers.html
It is sufficient to switch to statement-based replication only for those statements where you want this effect, and to use row-based replication the rest of the time. (Bug #45677) A trigger can have triggers for different combinations of trigger ...
https://dev.mysql.com/replication-implementation-details.html
If the slave stops before the SQL thread has executed all the fetched statements, the I/O thread has at least fetched everything so that a safe copy of the statements is stored locally in the slave's relay logs, ready for execution the next time ...
https://dev.mysql.com/sys-processlist.html
By default, rows are sorted by descending process time and descending wait time. time The time in seconds that the thread has been in its current state. lock_latency The time spent waiting for locks by the current statement. last_wait_latency The ...
https://dev.mysql.com/thread-pool-operation.html
By default, the thread pool tries to ensure a maximum of one thread executing in each group at any time, but sometimes permits more threads to execute temporarily for best performance. The default time before threads are considered stalled is 60ms ... The thread pool consists of a number of thread groups, each of which manages a set of client ...
https://dev.mysql.com/audit-log-logging-configuration.html
pwd_id format is pwd_timestamp-seq, where: pwd_timestamp is a UTC value in YYYYMMDDThhmmss format indicating when the password was created. Sequence numbers start at 1 and increase for passwords that have the same pwd_timestamp value. For the ...
https://dev.mysql.com/group-replication-configuring-instances.html
Warning When joining multiple servers at the same time, make sure that they point to seed members that are already in the group. Creating a group and joining multiple members at the same time is not supported. It might work, but chances are that the ... This section explains the configuration settings required for MySQL Server instances that you want to use for Group ...
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-14.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.
