Search Results
https://dev.mysql.com/doc/ndbapi/en/overview-ndb-api.html
This means that such applications are not bound by the MySQL privilege system; any NDB API application has read and write access to any NDB table stored in the same NDB Cluster at any time without restriction. It is also possible to perform ... The ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-replicationsource-category.html
Gtid Executed Compression Period Compress the mysql.gtid_executed table each time this many transactions have been processed. Table 7.28 Replication Source Configuration Metrics NameDescriptionAuto Increment Increment Controls the interval between ... Lists the Replication Source configuration metrics and provides a brief description of ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/schema-advisor-ref.html
MySQL's mechanism for doing this is the AUTO_INCREMENT column attribute, which enables you to generate sequential numbers automatically. The primary purpose of AUTO_INCREMENT in MySQL is to generate a sequence of positive integers. Default frequency ...However, the range of numbers that can be generated is limited by the underlying data ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-automl.html
Scalable design: The Oracle AutoML pipeline is able to exploit both MySQL HeatWave internode and intranode parallelism, which improves scalability and reduces runtime. The MySQL HeatWave AutoML ML_TRAIN routine leverages Oracle AutoML technology to ...Selecting only predictive features to speed up the pipeline and reduce ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-catalog-table.html
MySQL HeatWave AutoML routines update this value to the current timestamp when accessing the model. model_object A string in JSON format containing the serialized MySQL HeatWave AutoML model. As of MySQL 9.0.0, models are stored in the ... The ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-heatwave-cluster-unload-advisor.html
Unload Advisor 9.1.1 Unload Advisor Unloading tables from the MySQL HeatWave Cluster that have not been queried recently can free up memory for other tables and allow for a better use of available resources. To help identify unused tables in the ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-performance-extensions.html
Default Value com.mysql.cj.PerConnectionLRUFactory Since Version 5.1.1 serverConfigCacheFactory Name of a class implementing 'com.mysql.cj.CacheAdapterFactory', which will be used to create caches for MySQL server configuration values. Default Value ... callableStmtCacheSize If 'cacheCallableStmts' is enabled, how many callable statements should be cached? Default Value 100 Since Version 3.1.2 metadataCacheSize The number of queries to cache 'ResultSetMetadata' for if 'cacheResultSetMetaData' is set to ...
https://dev.mysql.com/doc/refman/8.4/en/cost-model.html
These estimates are stored in the server_cost and engine_cost tables in the mysql system database and are configurable at any time. Cost Model General Operation The Cost Model Database Making Changes to the Cost Model Database Cost Model General ...
https://dev.mysql.com/doc/refman/8.4/en/index-condition-pushdown-optimization.html
ICP can reduce the number of times the storage engine must access the base table and the number of times the MySQL server must access the storage engine. Index Condition Pushdown (ICP) is an optimization for the case where MySQL retrieves rows from ...The storage engine then evaluates the pushed index condition by using the index entry and only if this is satisfied is the row read from the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-system-tablespace.html
For example, this tablespace has one auto-extending data file: innodb_data_home_dir = innodb_data_file_path = /ibdata/ibdata1:10M:autoextend Suppose that the data file has grown to 988MB over time. The only option to achieve a smaller system ... The ...