Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/date-and-time-functions.html
Fractional seconds for TIME, DATETIME, and TIMESTAMP values are supported, with up to microsecond precision. mysql> SELECT EXTRACT(YEAR FROM '2019-07-02'); -> 2019 mysql> SELECT EXTRACT(YEAR_MONTH FROM '2019-07-02 01:02:03'); -> 201907 mysql> SELECT ... This section describes the functions that can be used to manipulate temporal ...
https://dev.mysql.com/expressions.html
This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in expressions. Expression Syntax Expression Term Notes Temporal Intervals The following grammar ...
https://dev.mysql.com/innodb-parameters.html
Prior to MySQL 8.0.14, the delay calculation is (purge_lag/innodb_max_purge_lag - 0.5) * 10000, which results in a minimum delay of 5000 microseconds. As of MySQL 8.0.14, the delay calculation is (purge_lag/innodb_max_purge_lag - 0.9995) * 10000, ...
https://dev.mysql.com/performance-schema-timing.html
The idle, stage, statement, and transaction timers use NANOSECOND on platforms where the NANOSECOND timer is available, MICROSECOND otherwise. The choice of picoseconds in events rather than a value such as microseconds has a performance basis. In ... Events are collected by means of instrumentation added to the server source ...
https://dev.mysql.com/replication-options-binary-log.html
binlog_group_commit_sync_delay Property Value Command-Line Format --binlog-group-commit-sync-delay=# System Variable binlog_group_commit_sync_delay Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 0 Minimum Value 0 Maximum ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/server-status-variables.html
Rpl_semi_sync_master_net_avg_wait_time The average time in microseconds the master waited for a slave reply. Rpl_semi_sync_master_net_wait_time The total time in microseconds the master waited for slave replies. Rpl_semi_sync_master_tx_avg_wait_time ... The MySQL server maintains many status variables that provide information about its ...
https://dev.mysql.com/mysql-cluster-ndbd-definition.html
spintime determines the wait time in microseconds the thread spins before going to sleep. The [ndbd] and [ndbd default] sections are used to configure the behavior of the cluster's data nodes. [ndbd] and [ndbd default] are always used as the ...
https://dev.mysql.com/replication-delayed.html
original_commit_timestamp: the number of microseconds since epoch when the transaction was written (committed) to the binary log of the original master. immediate_commit_timestamp: the number of microseconds since epoch when the transaction was ...
https://dev.mysql.com/func-op-summary-ref.html
GTID_SUBTRACT() Return all GTIDs in set that are not in subset. JSON_CONTAINS() Whether JSON document contains specific object at path JSON_CONTAINS_PATH() Whether JSON document contains any data at path JSON_DEPTH() Maximum depth of JSON document ...
https://dev.mysql.com/mysql-cluster-params-ndbd.html
The listings in this section provide information about parameters used in the [ndbd] or [ndbd default] sections of a config.ini file for configuring NDB Cluster data nodes. For detailed descriptions and other additional information about each of ...
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-microsecond-p-1.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.
