No cache version.
Caching disabled. Default setting for this page:enabled (code DEF204)
If the display is too slow, you can disable the user mode to view the cached version.
Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/replication-delayed.html
MySQL supports delayed replication such that a slave server deliberately executes transactions later than the master by at least a specified amount of time. In MySQL 8.0, the method of delaying replication depends on two timestamps, ...This section ...
https://dev.mysql.com/replication-options-gtids.html
A SET @@GLOBAL.gtid_purged statement was issued on MySQL 5.7.7 or earlier, and the binary log that was active at the time of the SET @@GLOBAL.gtid_purged statement has not yet been purged. If the server's most recent binary log files do not have ...
https://dev.mysql.com/show-processlist.html
row *************************** Id: 1 User: system user Host: db: NULL Command: Connect Time: 1030455 State: Waiting for master to send event Info: NULL *************************** 2. row *************************** Id: 2 User: system user Host: db: ... SHOW [FULL] PROCESSLIST SHOW PROCESSLIST shows which threads are ...
https://dev.mysql.com/source-configuration-options.html
Many options configure compile-time defaults that can be overridden at server startup. -DBUNDLE_RUNTIME_LIBRARIES=bool Whether to bundle runtime libraries with server MSI and Zip packages for Windows. Clients that make no explicit arrangements ...
https://dev.mysql.com/sys-schema-index-statistics.html
select_latency The total wait time of timed reads using the index. insert_latency The total wait time of timed inserts into the index. update_latency The total wait time of timed updates in the index. delete_latency The total wait time of timed ...
https://dev.mysql.com/sys-wait-classes-global-by-avg-latency.html
total_latency The total wait time of timed occurrences of events in the class. min_latency The minimum single wait time of timed occurrences of events in the class. avg_latency The average wait time per timed occurrence of events in the class.
https://dev.mysql.com/sys-wait-classes-global-by-latency.html
total_latency The total wait time of timed occurrences of events in the class. min_latency The minimum single wait time of timed occurrences of events in the class. avg_latency The average wait time per timed occurrence of events in the class.
https://dev.mysql.com/tables-table.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. To update cached values at any time for a given table, use ANALYZE TABLE. For example, InnoDB stores multiple tables in its system ...If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table statistics ...
https://dev.mysql.com/upgrade-binary-package.html
For example: mysqladmin -u root -p shutdown mysqld_safe --user=mysql --datadir=/path/to/existing-datadir & The first time you start the MySQL 8.0 server (in an earlier step), you may notice messages in the error log regarding nonupgraded tables. If ... This section describes how to upgrade MySQL binary and package-based installations on ...
https://dev.mysql.com/data-directory-initialization.html
To arrange for MySQL to start without manual intervention at system boot time, see Section 2.10.5, “Starting and Stopping MySQL Automatically”. Data directory initialization creates time zone tables in the mysql schema but does not populate them. To do so, use the instructions in Section 5.1.13, “MySQL Server Time Zone ... After MySQL is installed, the data directory must be initialized, including the tables in the mysql system schema: For some MySQL installation methods, data directory initialization is ...
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-12.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.
