Search Results
https://dev.mysql.com/doc/internals/en/binary-log-versions.html
create_timestamp The creation timestamp, if nonzero, is the time in seconds when this event was created; it indicates the moment when the binary log was created. This field is actually of no value: If nonzero, it is redundant because it has the same ... There are several versions of the binary log file format: v1: Used in MySQL 3.23 v3: Used in MySQL 4.0.2 though 4.1 v4: Used in MySQL 5.0 and up A v2 format was used briefly (in early MySQL 4.0.x versions), but it is obsolete and no longer ...
https://dev.mysql.com/doc/ndbapi/en/mccj-using-clusterj-operations.html
In addition, queries are optimized to detect whether columns of the primary key are specified as part of the query criteria, and if so, a primary key lookup or scan is executed as a strategy to implement the query. For some operations—find, ...To ...
https://dev.mysql.com/doc/internals/en/transformation-scalar-in.html
Item_ref is used to point to <left_expression cache>, because at the time of transformation we know only the address of the variable where the cache pointer will be stored. To rewrite a scalar IN subquery, the ...
https://dev.mysql.com/doc/internals/en/backup-breakpoint.html
open_tables(...) BACKUP_BREAKPOINT("bp_after_open_tables"); lock_tables(...) The BACKUP_BREAKPOINT macro consists basically of: DBUG_EXECUTE_IF("backup_debug", DBUG_SYNC_POINT((S), 300)) Opportunities and downsides of the DBUG_SYNC_POINT method ...
https://dev.mysql.com/doc/refman/8.4/en/timestamp-lookups.html
This phenomenon can lead to different results for a given TIMESTAMP column query, depending on whether the optimizer uses an index to execute the query. Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and ...
https://dev.mysql.com/doc/internals/en/autotools-plugin-macros.html
If a file named configure is detected in the directory, it will be executed as part of the configure build otherwise it is assumed that there is a Makefile to be built in that directory. If the plugin has been marked as MANDATORY, it will result in ... The following macros enable plugin support in the autotools configuration ...
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
Strict mode produces an error for attempts to create a key that exceeds the maximum key length. TIME_TRUNCATE_FRACTIONAL Control whether rounding or truncation occurs when inserting a TIME, DATE, or TIMESTAMP value with a fractional seconds part ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-formats.html
Example: "query": "DELETE FROM t1" query_time The query execution time in microseconds (if the longlong data type is selected) or seconds (if the double data type is selected). For example, the event corresponding to execution of an SQL statement ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-apptips-microsoft.html
If you still get the error Another user has changed your data after adding a TIMESTAMP column, the following trick may help you: Do not use a table data sheet view. Include a TIMESTAMP column in all tables that you want to be able to update. For ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
CREATE TABLE t1 (c1 INT ENGINE_ATTRIBUTE='{"key":"value"}'); ENGINE_ATTRIBUTE and SECONDARY_ENGINE_ATTRIBUTE values can be repeated without error. CREATE TABLE t1 (c1 INT) ENGINE_ATTRIBUTE='{"key":"value"}'; ENGINE_ATTRIBUTE and ...An error occurs ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...