Search Results
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbblob.html
NdbBlob Class Overview NdbBlob::ActiveHook NdbBlob::blobsFirstBlob() NdbBlob::blobsNextBlob() NdbBlob::close() NdbBlob::getBlobEventName() NdbBlob::getBlobTableName() NdbBlob::getColumn() NdbBlob::getLength() NdbBlob::getNull() ... This section ...
https://dev.mysql.com/doc/refman/8.4/en/index-condition-pushdown-optimization.html
Index Condition Pushdown (ICP) is an optimization for the case where MySQL retrieves rows from a table using an index. Without ICP, the storage engine traverses the index to locate rows in the base table and returns them to the MySQL server which ...With ICP enabled, and if parts of the WHERE condition can be evaluated by using only columns from the index, the MySQL server pushes this part of the WHERE condition down to the storage ...
https://dev.mysql.com/doc/refman/8.4/en/stored-programs-logging.html
If a stored program that modifies data is nondeterministic, it is not repeatable. Triggers can update tables, so error messages similar to those for stored functions occur with CREATE TRIGGER if you do not have the required privileges. If a function ... The binary log contains information about SQL statements that modify database ...
https://dev.mysql.com/doc/refman/8.4/en/function-resolution.html
When the parser encounters a word that is the name of a built-in function, it must determine whether the name signifies a function call or is instead a nonexpression reference to an identifier such as a table or column name. This occurs even when ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog.html
Note that mysqlbinlog returns a suitable error if you attempt to read an encrypted binary log file directly, but older versions of mysqlbinlog do not recognise the file as a binary log file at all. The other option values are intended only for ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-materialized-views.html
mysql> CREATE MATERIALIZED VIEW airport_US AS SELECT airport.* FROM airport JOIN airport_geo ON airport.airport_id = airport_geo.airport_id WHERE airport_geo.country = 'UNITED STATES'; The materialized view retrieves information on U.S.-based ...
https://dev.mysql.com/doc/workbench/en/dbdoc-templates-markers.html
Using the table The table shows which variables are defined in which sections. If a variable type is a variable, then the table describes its data dictionary, and a parent dictionary if type is a section. These markers can be used in any template, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-generate-embeddings.html
You can pass the text string in the routine manually or use data from tables in your database. To embed multiple rows of text stored in a table in a single run, you can even run a batch query. Using this method, you can create vector embedding ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-sharing.html
ML_MODEL_EXPORT exports the model to share to a user-defined table that both users need the required privileges to access. Export the Model to Share The admin user needs to export the model to share to a user-defined table that both users can access. mysql> CALL sys.ML_MODEL_EXPORT (model_handle, output_table_name); Replace model_handle and output_table_name with your own ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-bulk-ingest-limitations.html
Bulk Ingest Limitations 7.2.2.3 Bulk Ingest Limitations The following are some limitations to the Bulk Ingest Feature of MySQL HeatWave on AWS when using the LOAD DATA FROM S3 statement with ALGORITHM=BULK: The target table must be empty. The state ...If needed, set the secondary engine after running LOAD DATA FROM S3 with ...