Search Results
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-usage-differences.html
Use of a data dictionary-enabled MySQL server entails some operational differences compared to a server that does not have a data dictionary: Previously, enabling the innodb_read_only system variable prevented creating and dropping tables only for ...As of MySQL 8.4, enabling innodb_read_only prevents these operations for all storage ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-incremental-load.html
Available as of MySQL 9.0.0, Lakehouse Incremental Load allows you to refresh the data in an external table. To run Lakehouse Incremental Load, load the data using Lakehouse Auto Parallel Load and set the Auto Parallel Load refresh_external_tables ...This topic contains the following sections: Before You Begin Refresh Data Overview Perform Initial Load Refresh Data What's Next Before You Begin Load structured data using Lakehouse Auto Parallel Load or ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node-example.html
You can verify that all existing data nodes were restarted using the updated configuration by checking the ndbinfo.nodes table in the mysql client. ALGORITHM=INPLACE, REORGANIZE PARTITION does not work on tables that were created with the MAX_ROWS ... In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes online, starting with an NDB Cluster having 2 data nodes in a single node group and concluding with a cluster having 4 data nodes in 2 node ...
https://dev.mysql.com/doc/refman/8.4/en/update.html
UPDATE is a DML statement that modifies rows in a table. An UPDATE statement can start with a WITH clause to define common table expressions accessible within the UPDATE. Single-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_reference SET ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
(WL #16221) Microsoft Windows: Third party DLL files on which MySQL plugins depend are located, when installed, in the same directory as the MySQL executables. The default Windows behavior is to look for dependences in the same directory as the ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filter-definitions.html
The preceding definition can be written like this: { "filter": { "class": [ { "name": [ "connection", "general", "table_access" ] } ] } } Logging Specific Event Subclasses To select specific event subclasses, use an event item containing a name item ...For information about using JSON data in MySQL, see Section 13.5, “The JSON Data ...
https://dev.mysql.com/doc/refman/8.4/en/explain.html
In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a query). By default, DESCRIBE displays ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-optimization.html
Applications that monitor databases may make frequent use of INFORMATION_SCHEMA tables. To write queries for these tables most efficiently, use the following general guidelines: Try to query only INFORMATION_SCHEMA tables that are views on data ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locks-set.html
If you have no indexes suitable for your statement and MySQL must scan the entire table to process the statement, every row of the table becomes locked, which in turn blocks all inserts by other users to the table. For example, in a UNION, scanned ... A locking read, an UPDATE, or a DELETE generally set record locks on every index record that is scanned in the processing of an SQL ...
https://dev.mysql.com/doc/ndbapi/en/ndb-foreignkey.html
This section provides information about the ForeignKey class, which models a foreign key on an NDB table. ForeignKey Class Overview ForeignKey() ForeignKey::FkAction ForeignKey::getName() ForeignKey::getParentTable() ForeignKey::getChildTable() ...