Search Results
https://dev.mysql.com/doc/refman/8.4/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/ndbapi/en/ndb-ndboperation.html
Enumeration values Possible values are shown, along with descriptions, in the following table: Table 2.51 NdbOperation::AbortOption type values and descriptions Name Description AbortOnError A failed operation causes the transaction to abort. When ...Beginning with NDB 8.0.30, NdbOperation supports an interpreted code API similar to that implemented by ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-background.html
An InnoDB table created with ROW_FORMAT=COMPRESSED can use a smaller page size on disk than the configured innodb_page_size value. The compressed page size is specified through the CREATE TABLE or ALTER TABLE KEY_BLOCK_SIZE parameter. Specify a ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/en/partitioning-key.html
PARTITION BY KEY are similar to those for creating a table that is partitioned by hash. In both of these cases, the partitioning key is the id column, even though it is not shown in the output of SHOW CREATE TABLE or in the PARTITION_EXPRESSION ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-server-locks.html
The server_locks table is similar in structure to the cluster_locks table, and provides a subset of the information found in the latter table, but which is specific to the SQL node (MySQL server) where it resides. (The cluster_locks table provides ...This may be useful for correlating locking patterns with specific MySQL user sessions, queries, or use ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-transporters.html
Notes For each running data node in the cluster, the transporters table displays a row showing the status of each of that node's connections with all nodes in the cluster, including itself. This information is shown in the table's status column, ...
https://dev.mysql.com/doc/refman/8.4/en/reproducible-test-case.html
For information about steps to take when encountering InnoDB table corruption, see Section 1.6, “How to Report Bugs or Problems”. If you encounter corrupted MyISAM tables or if mysqld always fails after some update statements, you can test ...
https://dev.mysql.com/doc/refman/8.4/en/sys-innodb-buffer-stats-by-table.html
These views summarize the information in the INFORMATION_SCHEMA INNODB_BUFFER_PAGE table, grouped by schema and table. Warning Querying views that access the INNODB_BUFFER_PAGE table can affect performance. Do not query these views on a production ...To avoid impacting performance on a production system, reproduce the issue you want to investigate and query buffer pool statistics on a test ...