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/table-maintenance-statements.html
...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-formats.html
The MySQL server calls the audit log plugin to write an audit record to its log file whenever an auditable event occurs. <AUDIT_RECORD> <TIMESTAMP>2019-10-03T14:09:38 UTC</TIMESTAMP> <RECORD_ID>6_2019-10-03T14:06:33</RECORD_ID> <NAME>Query</NAME> ...Typically the first audit record written after plugin startup contains the server description and startup ...
https://dev.mysql.com/doc/refman/8.0/en/example-foreign-keys.html
To demonstrate ON DELETE and ON UPDATE referential actions, drop the child table and recreate it to include ON UPDATE and ON DELETE subclauses with the CASCADE option. MySQL supports foreign keys, which permit cross-referencing related data across ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-quick-start.html
To see the structure of individual tables, use SHOW CREATE TABLE: mysql> SHOW CREATE TABLE performance_schema.setup_consumers\G *************************** 1. row *************************** Table: setup_consumers Create Table: CREATE TABLE ...The ... This section briefly introduces the Performance Schema with examples that show how to use ...
https://dev.mysql.com/doc/refman/8.0/en/implicit-commit.html
CREATE TABLE and DROP TABLE statements do not commit a transaction if the TEMPORARY keyword is used. (This does not apply to other operations on temporary tables such as ALTER TABLE and CREATE INDEX, which do cause a commit.) However, although no ...
https://dev.mysql.com/doc/refman/8.0/en/index-page-merge-threshold.html
Setting MERGE_THRESHOLD for a Table You can set the MERGE_THRESHOLD value for a table using the table_option COMMENT clause of the CREATE TABLE statement. row *************************** INDEX_ID: 91 NAME: id_index TABLE_ID: 68 TYPE: 0 N_FIELDS: 1 ...The MERGE_THRESHOLD for index pages can be defined for a table or for individual ...If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an ...
https://dev.mysql.com/doc/refman/8.0/en/view-updatability.html
For information about generated columns, see Section 15.1.20.8, “CREATE TABLE and Generated Columns”. Consider this view: CREATE VIEW v AS SELECT col1, 1 AS col2 FROM t; This view is not insertable because col2 is an expression. Some views are ...For dependent subqueries in the select list, no data change statements are ...
https://dev.mysql.com/doc/refman/8.0/en/semijoins.html
A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and materialization. For an inner join between two tables, the join returns a row from one ...The optimizer uses semijoin strategies to improve subquery execution, as described in this ...
https://dev.mysql.com/doc/refman/8.0/en/alter-database.html
Encryption Option The ENCRYPTION option, introduced in MySQL 8.0.16, defines the default database encryption, which is inherited by tables created in the database. It is not possible to create any other tables in it. TEMPORARY tables; it is possible ...A stored routine that uses the database defaults when the routine is created includes those defaults as part of its ...alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' ...
https://dev.mysql.com/doc/refman/8.0/en/insert-select.html
When selecting from and inserting into the same table, MySQL creates an internal temporary table to hold the rows from the SELECT and then inserts those rows into the target table. To ensure that the binary log can be used to re-create the original ...| TABLE table_name | VALUES row_constructor_list } [ON DUPLICATE KEY UPDATE assignment_list] value: {expr | DEFAULT} value_list: value [, value] ... INSERT ...