Search Results
https://dev.mysql.com/doc/internals/en/optimizer-eliminating-dead-code.html
The optimizer will not detect all Impossible WHERE situations — there are too many possibilities in this regard. A transformation takes place for conditions that are always true, for example: WHERE 0=0 AND column1='y' In this case, the first ...
https://dev.mysql.com/doc/internals/en/optimizer-range-join-type.html
The optimizer may change a Range to an ALL join type if a condition would examine too many index keys. Some conditions can work with indexes, but over a (possibly wide) range of keys. The optimizer will use an index (range search) for column1 LIKE ...
https://dev.mysql.com/doc/internals/en/required-server-code-patches.html
The build system is not too clever about creating these symlinks for files added after the first compile ... Currently procedures can only be compiled into the server staticly. There is no dynamic procedure for loading them dynamicly yet like we ...
https://dev.mysql.com/doc/internals/en/risky-handling-around-additional-sessions.html
(2) The wait routine (3) prevents that our look on the process list (4) happens too early = before the server has started the processing of (2). This is most probably good for the throughput of usual application but has some annoying consequences ...
https://dev.mysql.com/doc/internals/en/select-structure.html
The first and uppermost SELECT_LEX (#1 in example) is stored in LEX, too. There are two structures that describe selects: st_select_lex (SELECT_LEX) for representing SELECT itself st_select_lex_unit (SELECT_LEX_UNIT) for grouping several selects in ...
https://dev.mysql.com/doc/internals/en/sleep.html
In some cases race conditions can be repeated when all but one thread are blocked (for example waiting for an SQL lock). Then the remaining thread has plenty of time to go through the critical piece of code. The problem here is to assure that the ...
https://dev.mysql.com/doc/internals/en/transactions-historical-note.html
First, observe that in BerkeleyDB the "auto-commit" mode causes automatic commit of operations that are atomic from the storage engine's perspective, such as a write of a record, but are too fine-grained to be atomic from the application's (MySQL's) ... "Statement transaction" is a non-standard term that comes from the days when MySQL supported the BerkeleyDB storage ...
https://dev.mysql.com/doc/mysql-installer/en/server-type-network.html
With the Manual type selected, MySQL Installer uses the default value of 16M for the tmp_table_size variable assignment. If the minimum-access option is too restrictive for the client software, use this option to reduce the number of users who have ... Server Configuration Type Choose the MySQL server configuration type that describes your ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-configuration-or-application-error.html
The following list enumerates all NDB errors of type CE (Configuration or application error).
https://dev.mysql.com/doc/ndbapi/en/ndb-ndberror.html
SchemaError An error took place when trying to create or use a table. TemporaryResourceError This type of error is typically encountered when there are too many active transactions. This section provides information about the NdbError data ...