Search Results
https://dev.mysql.com/doc/refman/8.4/en/option-modifiers.html
For example, --maximum-max_heap_table_size=32M prevents any client from making the heap table size limit larger than 32M. For example, the mysql client supports a --column-names option that determines whether or not to display a row of column names ... Some options are “boolean” and control behavior that can be turned on or ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-range-list.html
To drop the partition named p2, execute the following command: mysql> ALTER TABLE tr DROP PARTITION p2; Query OK, 0 rows affected (0.03 sec) Note The NDBCLUSTER storage engine does not support ALTER TABLE ... However, there is one important ...
https://dev.mysql.com/doc/internals/en/support-for-savepoints.html
This should be a fixed size, preferably not large as the MySQL server will allocate space to store the savepoint for all storage engines with each named savepoint. First, the implementor should know how many bytes are required to store savepoint ...
https://dev.mysql.com/doc/relnotes/connector-python/en/news-8-0-33.html
(Bug #96347, Bug #30103652) Increased the data chunk size from 8 KB to 128 KB to improve performance for large inputs. Functionality Added or Changed Bugs Fixed Functionality Added or Changed Adopted function annotation enforcement by mypy, which ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/agenthealth-advisor-ref.html
Although it is possible to use very small values for a moving average window, large values, larger than seconds, are recommended. Memory Usage Thresholds (% of max allowed): enables you to define thresholds for RAM usage as a percentage of the ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-access-control-best-practice-ref.html
In large organizations, the Group Administrator role may also be responsible for managing Event Handlers, Event Blackouts, and Notification Groups. The scope of the Group Administrator role's permissions can vary, depending on the size of the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-silos.html
The number of nodes required depends on the size of the data and the amount of compression achieved when loading data into MySQL HeatWave Cluster. MySQL HeatWave GenAI MySQL HeatWave GenAI offers integrated and automated generative AI featuring ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-generate-table.html
It can include the following parameters: task: specifies the task expected from the large language model (LLM). The ML_GENERATE_TABLE routine runs multiple text generation or summarization queries in a batch, in parallel. The output generated for ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-27-u2.html
For MySQL HeatWave queries that join large and small relations, bloom filters reduce the amount of data processed by early filtering and the amount of memory used during query processing. The following columns were added to the ... Functionality ...
https://dev.mysql.com/doc/refman/8.4/en/encryption-functions.html
The size penalty for storing the hex string in a CHAR column is at least two times, up to eight times if the value is stored in a column that uses the utf8mb4 character set (where each character uses 4 bytes). Storing the string also results in ...