Search Results
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-regression-explanations.html
mysql> SELECT JSON_PRETTY(model_explanation) FROM ML_SCHEMA_user1.MODEL_CATALOG WHERE model_handle='regression_use_case'; +------------------------------------------------------------------------------------------------------------------------+ | ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-limitations.html
Limiting operations to batches of 10 to 100 rows by splitting large tables into smaller tables is recommended. Memory Limitations The table used to train a model cannot exceed 10 GB, 100 million rows, or 1017 columns. For imported models, we ...Text ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-load-model.html
MySQL 9.0.0 introduces support for large models that changes how MySQL HeatWave AutoML stores models. You must load a machine learning model from the model catalog into MySQL HeatWave before running MySQL HeatWave AutoML routines other than ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-buffer-page-lru-table.html
Querying this table can require MySQL to allocate a large block of contiguous memory, more than 64 bytes times the number of active pages in the buffer pool. When tables, table rows, partitions, or indexes are deleted, associated pages remain in the ... The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, how they are ordered in the LRU list that determines which pages to evict from the buffer pool when it becomes ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-redo-log.html
If innodb_redo_log_capacity is not defined, and if neither innodb_log_file_size or innodb_log_files_in_group are defined, then the default innodb_redo_log_capacity value is used. If innodb_redo_log_capacity is not defined, and if ... The redo log is ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/dynxml-auto-changelog-difflist-mysqld-8.4.1-ndb-8.4.1.html
It was removed due to a critical issue that could stop the server from restarting following the creation of a very large number of tables (8001 or more). (Bug #36426461) NDB Cluster's pushdown join functionality expects pushed conditions to filter ...Functionality Added or Changed Bugs Fixed Functionality Added or Changed Important Change: Now, when the removal of a data node file or directory fails with a file does not exist (ENOENT) error, this is treated as a successful ...
https://dev.mysql.com/doc/ndbapi/en/ndb-start-mysql-data-types.html
This means that each of these types requires the same amount of storage as a CHAR of the same size. Each row in an NDB Cluster BLOB or TEXT column is made up of two separate parts. One of these is of fixed size (256 bytes), and is actually stored in ... This section provides information about the way in which MySQL data types are represented in NDBCLUSTER table columns and how these values can be accessed in NDB API ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-data-placement.html
row *************************** query_id: 14 LEFT(query_text,160): SELECT country from airport_geo *************************** 2. row *************************** query_id: 15 LEFT(query_text,160): CREATE TABLE flight_from_US SELECT * FROM flight ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-trx-table.html
TRX_WEIGHT The weight of a transaction, reflecting (but not necessarily the exact count of) the number of rows altered and the number of rows locked by the transaction. Transactions that have changed nontransactional tables are considered heavier ...
https://dev.mysql.com/doc/refman/8.4/en/show-profile.html
The size of the list is controlled by the profiling_history_size session variable, which has a default value of 15. The LIMIT row_count clause may be given to limit the output to row_count rows. If LIMIT is given, OFFSET offset may be added to begin ...Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL ...