Search Results
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() ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-limitations-syntax.html
Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: Temporary tables. Trying either to create a temporary table that uses the NDB storage engine or to alter an ...In ...
https://dev.mysql.com/doc/refman/9.7/en/view-updatability.html
Some views are updatable and references to them can be used to specify tables to be updated in data change statements. That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying table. Derived ...For dependent subqueries in the select list, no data change statements are ...
https://dev.mysql.com/doc/refman/9.7/en/create-view.html
CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] [MATERIALIZED] ... (Selecting from the view selects, in effect, using the SELECT statement.) The select_statement can select from base tables or from other views. The SELECT ...If ...
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-3-0.html
You can view these status variables using SHOW GLOBAL STATUS LIKE 'option_tracker_usage%' or by selecting from the Performance Schema global_status table. (Bug #37459238) Deprecation and Removal Notes NDB Cluster: The --restore-privilege-tables ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-learn-with-genai.html
To generate AutoML queries, NL2ML leverages the databases, tables, and table columns in the DB System. This includes detailed instructions to do the following: Join your dataset's various tables into a single table. If table and column names are ...
https://dev.mysql.com/doc/refman/9.7/en/invisible-columns.html
As an illustration of when invisible columns may be useful, suppose that an application uses SELECT * queries to access a table, and must continue to work without modification even if the table is altered to add a new column that the application ...
https://dev.mysql.com/doc/refman/9.7/en/telemetry-metrics-meter-metrics.html
open_streams Open_streams ASYNC COUNTER The number of streams that are open, used mainly for logging open_table_definitions Open_table_definitions ASYNC GAUGE COUNTER The number of cached table definitions open_tables Open_tables ASYNC GAUGE COUNTER ... The following server metrics are registered by default: mysql.stats Metrics mysql.stats.com Metrics mysql.stats.connection Metrics mysql.perf_schema Metrics mysql.stats.handler Metrics mysql.stats.myisam Metrics mysql.stats.ssl Metrics mysql.inno Metrics mysql.inno.buffer_pool Metrics mysql.inno.data Metrics mysql.x Metrics mysql.x.stmt Metrics mysql.mle Metrics The maximum number of metric instruments which can be created is set by ...
https://dev.mysql.com/doc/refman/9.7/en/server-options.html
The server executable determines its own full path name at startup and uses the parent of the directory in which it is located as the default basedir value. --check-table-functions=value Command-Line Format --check-table-functions=value Type ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-unload.html
This topic contains the following sections: Before You Begin Overview for Unloading Data Automatically Unload Specific Tables Unload All Data Auto Unload Examples What's Next Before You Begin Load structured data using Lakehouse Auto Parallel Load ... You can use MySQL HeatWave Auto Unload to unload data ...