PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-binary-log-transaction-compression-stats-table.html
FIRST_TRANSACTION_TIMESTAMP The timestamp when the first transaction was written to the log. LAST_TRANSACTION_TIMESTAMP The timestamp when the most recent transaction was written to the log. This table shows statistical information for transaction ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-clone-progress-table.html
BEGIN_TIME A timestamp in 'YYYY-MM-DD hh:mm:ss[.fraction]' format that shows when the cloning stage started. END_TIME A timestamp in 'YYYY-MM-DD hh:mm:ss[.fraction]' format that shows when the cloning stage finished. The clone_progress table shows ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-clone-status-table.html
BEGIN_TIME A timestamp in 'YYYY-MM-DD hh:mm:ss[.fraction]' format that shows when the cloning operation started. END_TIME A timestamp in 'YYYY-MM-DD hh:mm:ss[.fraction]' format that shows when the cloning operation finished. The clone_status table ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-persisted-variables-table.html
The persisted_variables table provides an SQL interface to the mysqld-auto.cnf file that stores persisted global system variable settings, enabling the file contents to be inspected at runtime using SELECT statements. Variables are persisted using ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-statement-summary-tables.html
The events_statements_summary_by_digest table has these additional summary columns: FIRST_SEEN, LAST_SEEN Timestamps indicating when statements with the given digest value were first seen and most recently seen. QUERY_SAMPLE_SEEN A timestamp ... The ...
https://dev.mysql.com/doc/refman/9.7/en/processlist-access.html
The thread's notion of the current time may be altered in some cases: The thread can change the time with SET TIMESTAMP = value. For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the ... The following discussion enumerates the sources of process information, the privileges required to see process information, and describes the content of process list ...
https://dev.mysql.com/doc/refman/9.7/en/replace.html
REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ... | VALUES row_constructor_list } REPLACE [LOW_PRIORITY | DELAYED] ...
https://dev.mysql.com/doc/refman/9.7/en/show-library-status.html
SHOW LIBRARY STATUS [LIKE 'pattern' | WHERE expr] This statement provides information about one or more JavaScript libraries. Like SHOW FUNCTION STATUS and SHOW PROCEDURE STATUS, it supports LIKE and WHERE clauses for filtering the output. See ...
https://dev.mysql.com/doc/refman/9.7/en/sql-mode.html
It does not apply to TIMESTAMP columns, which always require a valid date. TIME_TRUNCATE_FRACTIONAL Control whether rounding or truncation occurs when inserting a TIME, DATE, or TIMESTAMP value with a fractional seconds part into a column having the ... The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-data-arguments.html
Temporal types: DATE, DATETIME, and TIMESTAMP are supported, and are converted to JavaScript Date values. Table 27.3 Type Conversion: JavaScript Dates to MySQL JavaScript TypeMySQL DATEMySQL DATETIME, TIMESTAMPMySQL YEARnull or undefined NULL NULL ... Most MySQL data types are supported for MLE stored program input and output arguments, as well as for return data ...