Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-indexing.html
To make large collections of documents more efficient to navigate you can create an index based on one or more fields found in the documents in the collection. Creating an Index Collection indexes are ordinary MySQL indexes on virtual columns that ...Because MySQL cannot index JSON values directly, to enable indexing of a collection, you provide a JSON document that specifies the document's fields to be used by the ...
https://dev.mysql.com/doc/internals/en/implementing-info-method.html
Prior to commencing a table scan, the [custom-engine.html#custom-engine-api-reference-info info()] method is called to provide extra table information to the optimizer. The stats member is an instance of the ha_statistics class which is also ...The ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-_query.html
Table 4.37 deletePersistentAll() Parameter Description return the number of instances deleted 4.3.1.19.9 execute(Map<String, ?>) public abstract Results<E> execute(Map<String, ?> parameters); Execute the query with one or more named parameters. A ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-dmlstatementactivity-category.html
Table 6.6 DML Statement Activity Metrics NameDescriptionCall Procedure (Delta) The total number of CALL statements executed. Delete Multi (Delta) The total number of multi-table DELETE statements executed. Lock Tables (Delta) The total number of ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/ui-security-advisor-ref.html
Strong MySQL Privilege User Exclusion Regex: This advisor enables you to define a regular expression describing the users allowed to have global privileges on the mysql.user table (CREATE_USER, FILE, GRANT, PROCESS, LOCK_TABLES, SHUTDOWN, SUPER or ...A MySQL account is identified by both a username and a host name, which are found in the User and Host columns of the mysql.user ... This section describes the following Security advisors: MySQL Enterprise Audit Plugin MySQL Enterprise Firewall MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-bulk-load.html
The state of the table should be as though it has been freshly created. For versions earlier than MySQL 9.4.0, tables must have a primary key, and the primary key must not have a prefix index. LOAD DATA with ALGORITHM=BULK has the following ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-loading-data-manually.html
You can manually load data from InnoDB tables in your DB System into MySQL HeatWave Cluster by using SQL data definition language (DDL) such as CREATE TABLE and ALTER TABLE statements. Perform the following steps sequentially for each table that ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-classification-generate-prediction.html
The following example runs ML_PREDICT_TABLE on the testing dataset previously created. Even though the table has labels for the Approved target column, the column is not considered when generating predictions. Before You Begin Complete the following ...To generate predictions, use the sample data from the testing_data ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-regression-predictions.html
The following example runs ML_PREDICT_TABLE on the testing dataset previously created. Even though the table has labels for the price target column, the column is not considered when generating predictions. Before You Begin Complete the following ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-topic-modeling-prediction.html
When the output table generates, you can review the generated word groups and expressions for the trained text. Train a Model with Topic Modeling Run Topic Modeling for a Table If not already done, load the model. mysql> CALL ... After training the ...