Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-asyncio.html
The optimal number of jobs is problem-dependent, and is a value determined with experience. Is it worth the effort? It depends on the goal as asynchronous code better optimizes performance, such as CPU usage, whereas writing standard synchronous ...
https://dev.mysql.com/doc/connector-python/en/connector-python-coding.html
Because MySQL often deals with data sets that are many times larger than available memory, techniques that optimize storage space and disk I/O are especially important. The following guidelines cover aspects of developing MySQL applications that ...
https://dev.mysql.com/doc/internals/en/files-in-innodb-sources.html
The InnoDB source files are the best place to look for information about internals of the file structure that MySQLers can optionally use for transaction support. But when you first look at all the subdirectories and file names you'll wonder: Where ...
https://dev.mysql.com/doc/internals/en/full-text-search.html
MySQL uses Ranking with Vector Spaces for ordinary full-text queries. Rank, also known as relevance rank, also known as relevance measure, is a number that tells us how good a match is. Vector Space, which MySQL sometimes calls "natural language", ...
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 ...