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 ...
