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/mysql-cluster-ndbinfo-blobs.html
The part and (NDB 8.0.30 and later) inline sizes of NDB blob columns can be set using CREATE TABLE and ALTER TABLE statements containing NDB table column comments (see NDB_COLUMN Options); this can also be done in NDB API applications (see ...Parts ...For more information about how NDB Cluster stores columns of such types, see String Type Storage ...
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/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 ...
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/mysql-cluster-replication-issues.html
Note Every NDB table is implicitly partitioned by key when it is created. In the event of a node failure, errors in replication of NDB tables without primary keys can still occur, due to the possibility of duplicate rows being inserted in such cases. For this reason, it is highly recommended that all NDB tables being replicated have explicit primary ...
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/innodb-best-practices.html
Run the server with the --sql_mode=NO_ENGINE_SUBSTITUTION option to prevent tables from being created with storage engines that you do not want to use. Specify a primary key for every table using the most frequently queried column or columns, or an ...Adding foreign keys ensures that referenced columns are indexed, which can improve ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-storage-layout.html
Once your data reaches a stable size, or a growing table has increased by tens or some hundreds of megabytes, consider using the OPTIMIZE TABLE statement to reorganize the table and compact any wasted space. The reorganized tables require less disk ...This is a straightforward technique that can improve performance when other techniques such as improving index usage or tuning application code are not ...
https://dev.mysql.com/doc/refman/8.0/en/switchable-optimizations.html
For more information, see Section 10.2.2.5, “Derived Condition Pushdown Optimization” Derived Table Merging Flags derived_merge (default on) Controls merging of derived tables and views into outer query block. The derived_merge flag controls ...
https://dev.mysql.com/doc/refman/8.0/en/dynamic-format.html
Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table was created with the ROW_FORMAT=DYNAMIC table option. You can use OPTIMIZE TABLE or myisamchk -r to ...