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/problems-with-null.html
If you insert NULL into a TIMESTAMP column, the current date and time is inserted. The concept of the NULL value is a common source of confusion for newcomers to SQL, who often think that NULL is the same thing as an empty string ''. For example, ...
https://dev.mysql.com/processlist-table.html
For a slave SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the slave machine. The PROCESSLIST table provides information about which threads are running. This is the same type ...
https://dev.mysql.com/query-log.html
The log_timestamps system variable controls the time zone of timestamps in messages written to the general query log file (as well as to the slow query log file and the error log). The general query log is a general record of what mysqld is doing.
https://dev.mysql.com/repair-table.html
REPAIR TABLE upgrades a table if it contains old temporal columns in pre-5.6.4 format (TIME, DATETIME, and TIMESTAMP columns without support for fractional seconds precision) and the avoid_temporal_upgrade system variable is disabled. [QUICK] ...
https://dev.mysql.com/replication-administration-status.html
This is especially likely when the events have old timestamps; in such cases, if you execute SHOW SLAVE STATUS several times in a relatively short period, you may see this value change back and forth repeatedly between 0 and a relatively large value. The most common task when managing a replication process is to ensure that replication is taking place and that there have been no errors between the slave and the ...
https://dev.mysql.com/replication-applier-filters-table.html
This table shows the replication channel specific filters configured on this slave. Each row provides information on a replication channel's configured type of filter. The replication_applier_filters table has the following columns: CHANNEL_NAME ...
https://dev.mysql.com/replication-applier-global-filters-table.html
This table shows the global replication filters configured on this slave. The replication_applier_global_filters table has the following columns: FILTER_NAME The type of replication filter that has been configured. FILTER_RULE The rules configured ...
https://dev.mysql.com/replication-features-auto-increment.html
Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is carried out subject to the following exceptions: A statement invoking a trigger or function that causes an update to an AUTO_INCREMENT column is not replicated ...(Bug #45677) An INSERT into a table that has a composite primary key that includes an AUTO_INCREMENT column that is not the first column of this composite key is not safe for statement-based logging or ...
https://dev.mysql.com/replication-features-fractional-seconds.html
MySQL 8.0 permits fractional seconds for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision.
https://dev.mysql.com/replication-features-timeout.html
This data includes timestamps showing how long it took the applier thread to apply the last transaction from start to finish (and when the transaction currently in progress was started), and how long this was after the commit on the original master ... The global system variable slave_transaction_retries sets the maximum number of times for applier threads on a single-threaded or multithreaded replication slave to automatically retry failed transactions before ...
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-timestamp-p-11.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.
