PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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/8.0/en/type-conversion.html
If one of the arguments is a TIMESTAMP or DATETIME column and the other argument is a constant, the constant is converted to a timestamp before the comparison is performed. When an operator is used with operands of different types, type conversion ...
https://dev.mysql.com/doc/refman/8.0/en/alter-database.html
Events: CREATE EVENT ALTER EVENT DROP EVENT Event execution: Executing an event in the database fails because that would change the last-execution timestamp, which is event metadata stored in the data dictionary. alter_option: { [DEFAULT] CHARACTER ...
https://dev.mysql.com/doc/refman/8.0/en/alter-event.html
ALTER EVENT myevent ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 DAY DO TRUNCATE TABLE myschema.mytable; Specify the options in an ALTER EVENT statement only for those characteristics that you want to change; omitted options keep their existing ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-mixed.html
The following system variables, when used with session scope (only), do not cause the logging format to switch: auto_increment_increment auto_increment_offset character_set_client character_set_connection character_set_database character_set_server ... When running in MIXED logging format, the server automatically switches from statement-based to row-based logging under the following conditions: When a function contains ...
https://dev.mysql.com/doc/refman/8.0/en/check-table.html
A table is reported as needing a rebuild 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.