Search Results
https://dev.mysql.com/doc/internals/en/mysys-directory.html
There are 125 *.c programs in this directory: array.c --- Dynamic array handling charset.c --- Using dynamic character sets, set default character set, ... For example, the main functions in my_getwd.c are described thus: "int my_getwd _A((string ...
https://dev.mysql.com/doc/internals/en/prepared-stored-statement-execution.html
The execution plan created at prepare stage is not saved (see Section 17.2, “Preparation of a Prepared Statement”), and at execute we simply create a new set of JOINs and then prepare and optimize it. Some optimizations damage the parsed tree, ... In order to call mysql_execute_command (the function that executes a statement) for a prepared statement and not damage its parse tree, we backup and restore the active Query_arena of ...
https://dev.mysql.com/doc/internals/en/select-steps.html
Every select is performed in these base steps: JOIN::prepare Initialization and linking JOIN structure to st_select_lex. fix_fields() for all items (after fix_fields(), we know everything about item).
https://dev.mysql.com/doc/internals/en/transformations-all-any.html
ALL uses an inverted function, and all subqueries passed as arguments to Item_func_not_all (Item_func_not_all is a special NOT function used in optimization, see following). But before above transformation ability of independent ALL/ANY/SOME ...
https://dev.mysql.com/doc/mysqld-version-reference/en/options-variables.html
The following table shows all the options and variables available in MySQL Server. Intr: The version or versions in which the item was introduced. Depr: The version or versions in which the item was deprecated. Removed: The version or versions in ...
https://dev.mysql.com/doc/heatwave/en/heatwave-system-variables.html
By injecting actual statistics from previous query executions into subsequent optimizations, MySQL HeatWave can produce more accurate and efficient plans, leading to significant performance improvements. Most MySQL HeatWave variable settings are ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load-syntax.html
Optimizes load parallelism based on machine-learning models by optimizing the innodb_parallel_read_threads variable setting before loading each table. MySQL 9.0.0 adds support for Lakehouse Incremental Load with the refresh_external_tables option, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-load-prerequisites.html
Tip The Auto Parallel Load utility automatically optimizes the number of parallel read threads for each table. For users of MySQL HeatWave on AWS, the number of parallel read threads is also optimized when loading data from the MySQL HeatWave ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-chat-details.html
This topic describes how to view a chat session details. It contains the following sections: Before You Begin View Details What's Next Before You Begin Complete the steps to run MySQL HeatWave Chat. View Details To view the chat session details, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-quickstart.html
It analyzes the characteristics of the data and creates an optimized machine learning model that can be used to generate predictions and explanations. MySQL HeatWave AutoML is optimized for MySQL HeatWave shapes and scaling, and all processing is ...