https://dev.mysql.com/data-types.html
fsp applies to the TIME, DATETIME, and TIMESTAMP types and represents fractional seconds precision; that is, the number of digits following the decimal point for fractional parts of seconds. MySQL supports a number of SQL data types in several ...
https://dev.mysql.com/dynamic-system-variables.html
Many server system variables are dynamic and can be set at runtime. For a description of the privilege requirements for setting system variables, see Section 5.1.9.1, “System Variable Privileges” The following table lists all dynamic system ...
https://dev.mysql.com/error-log-rule-based-filtering.html
The log_filter_dragnet log filter component enables log filtering based on user-defined rules. To enable the log_filter_dragnet filter, first load the filter component, then modify the log_error_services value. The following example enables ...
https://dev.mysql.com/error-summary-tables.html
FIRST_SEEN, LAST_SEEN Timestamp indicating when the error was first seen and most recently seen. The Performance Schema maintains summary tables for aggregating statistical information about server errors (and warnings). For a list of server ...
https://dev.mysql.com/faqs-triggers.html
MySQL does have specific special behavior for some TIMESTAMP columns, as well as for columns which are defined using AUTO_INCREMENT. Where can I find the documentation for MySQL 8.0 triggers? A.5.2. Is there a way to view all triggers in a given ...
https://dev.mysql.com/features.html
Data Types Many data types: signed/unsigned integers 1, 2, 3, 4, and 8 bytes long, FLOAT, DOUBLE, CHAR, VARCHAR, BINARY, VARBINARY, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, ENUM, and OpenGIS spatial types. This section describes some ...
https://dev.mysql.com/federated-usagenotes.html
The insert_id and timestamp options are not propagated to the data provider. The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL server. The remote table that a ...
https://dev.mysql.com/group-replication-enterprise-backup.html
MySQL Enterprise Backup is a commercially-licensed backup utility for MySQL Server, available with MySQL Enterprise Edition. This section explains how to back up and subsequently restore a Group Replication member using MySQL Enterprise Backup. The ...
https://dev.mysql.com/innodb-enabling-monitors.html
InnoDB monitor output begins with a header containing a timestamp and the monitor name. When InnoDB monitors are enabled for periodic output, InnoDB writes the output to mysqld server standard error output (stderr) every 15 seconds, approximately.
https://dev.mysql.com/innodb-online-ddl-limitations.html
Tables created before MySQL 5.6 that include temporal columns (DATE, DATETIME or TIMESTAMP) and have not been rebuilt using ALGORITHM=COPY do not support ALGORITHM=INPLACE. The following limitations apply to online DDL operations: The table is ...
