PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/tuning-trace-purging.html
Thus, if a statement contains substatements (such as invoking stored procedures, stored functions, or triggers), the topmost statement and substatements each generate one trace, but at the end of execution, the trace for only the last substatement ...Such a SET statement has the following effects: All traces previously stored are cleared from ...A user who wants to see the trace of a different substatement can enable or disable tracing for the ...
https://dev.mysql.com/doc/refman/8.0/en/xml-functions.html
XPath expressions used with these functions support user variables and local stored program variables. User variables are weakly checked; variables local to stored programs are strongly checked (see also Bug #26518): User variables (weak checking).
https://dev.mysql.com/doc/refman/8.0/en/alter-table.html
As of MySQL 8.0.14, changing a generated column, when these conditions apply: For InnoDB tables, statements that modify generated stored columns but do not change their type, expression, or nullability. For non-InnoDB tables, statements that modify ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.0/en/analyze-table.html
ANALYZE TABLE generates table statistics: ANALYZE TABLE without any HISTOGRAM clause performs a key distribution analysis and stores the distribution for the named table or tables. ANALYZE TABLE with the UPDATE HISTOGRAM clause generates histogram ...ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-reference.html
As of MySQL 8.0.19, the password is stored as a utf8mb4 string. Prior to MySQL 8.0.19, the password is stored in binary form. audit_log_password_history_keep_days Command-Line Format --audit-log-password-history-keep-days=# System Variable ...Unless ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-ndb-comment-options.html
NDB_COLUMN comments do not support TINYBLOB or TINYTEXT columns, since these have an inline part (only) of fixed size, and no separate parts to store elsewhere. (Prior to NDB 8.0.30, only MAX_BLOB_PART_SIZE is supported.) Syntax for this option is ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-data-encryption.html
When a tablespace is encrypted, a tablespace key is encrypted and stored in the tablespace header. All MySQL editions provide a component_keyring_file component and keyring_file plugin, each of which stores keyring data in a file local to the server ... InnoDB supports data-at-rest encryption for file-per-table tablespaces, general tablespaces, the mysql system tablespace, redo logs, and undo ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-space.html
To avoid the issues that come with storing all tables and indexes inside the system tablespace, you can enable the innodb_file_per_table configuration option (the default), which stores each newly created table in a separate tablespace file (with ...
https://dev.mysql.com/doc/refman/8.0/en/json.html
The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON columns. JSON documents stored in JSON columns are converted to an internal format that permits ...The binary format is structured to enable the server to look up subobjects or nested values directly by key or array index without reading all values before or after them in the ...
https://dev.mysql.com/doc/refman/8.0/en/myisampack.html
For example, a BIGINT column (eight bytes) can be stored as a TINYINT column (one byte) if all its values are in the range from -128 to 127. pre-space The number of decimal columns that are stored with leading spaces. no endspace, not_always Do not ...When the table is used later, the server reads into memory the information needed to decompress ...