Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-ui-settings-data-purge-ref.html
Notes for setting purge behavior: Purging can be carried out manually by enabling innodb_file_per_table for the repository database and using an OPTIMIZE TABLE operation to reclaim space from deleted rows in the table. If you change the purge value ... Data Purge Behavior enables you to automatically remove old data from the repository according to a ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-data-sets.html
Data items can be read from the database using Collection.find(), Table.select() and Session.sql(). Collection.find() returns a data set with documents and Table.select() respectively Session.sql() return a data set with rows. execute(); var doc; ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-data-sets.html
Data items can be read from the database using Collection.find(), Table.select() and Session.sql(). Collection.find() returns a data set with documents and Table.select() respectively Session.sql() return a data set with rows. myColl = ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-column-limits.html
Any table with multiple columns wherein the aggregate data size is greater than 4 MB cannot be loaded to MySQL HeatWave. The maximum column limit for base relations, tables as loaded into MySQL HeatWave, is 1017. The column limit for intermediate ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-scanned.html
Base relation data depends on the table schema, number of rows in each table, and DML operations on a MySQL table. Features like Auto Zonemap and MySQL table partitions also impact the base relation data scanned by a query. MySQL HeatWave tracks ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-change-propagation.html
As of MySQL 9.2.1, TRANSACTIONAL indicates that change propagation is enabled for the table. In previous versions of MySQL, RAPID_LOAD_POOL_TRANSACTIONAL indicates that change propagation is enabled for the table.
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-query-history.html
The rpd_query_stats table stores query compilation and execution statistics (the query history) for the last 1000 successfully executed queries. To view the MySQL HeatWave query history including query start time, end time, and wait time in the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-string-functions-operators.html
With the exception of the FORMAT() function, string functions and operators described in the following table are supported with variable-length encoded columns. FIELD() Index (position) of first argument in subsequent arguments FIND_IN_SET() Index ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-anomaly-detection-logs.html
The input table can only have the following columns: The column containing the logs. As of MySQL 9.4.1, at least one column must act as the primary key to establish the temporal order of logs. If the input table has additional columns to the ones ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-explanations.html
Prediction explanations are generated by running ML_EXPLAIN_ROW or ML_EXPLAIN_TABLE on unlabeled data. You can train the following prediction explainers: The Permutation Importance prediction explainer, specified as permutation_importance, is the ...The data must have the same feature columns as the data used to train the ...