Search Results
https://dev.mysql.com/doc/internals/en/select-select-engine.html
subselect_single_select_engine: constructor allocate JOIN and store pointers on SELECT_LEX and JOIN. fix_length_and_dec() prepare cache and receive type and parameters of returning items (called only by Item_singlerow_subselect). If this is the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-auto-increment-handling.html
InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT columns. To use the AUTO_INCREMENT mechanism with an InnoDB table, an ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-main-window.html
Any number of tables may be edited in the MySQL Table Editor at any one time. Adding another table creates a new secondary tab at the top of the editor. By default, the MySQL Table Editor appears docked at the top of the table editor tab, within ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-fieldtype.html
This class provides all supported MySQL field or data types. They can be useful when dealing with raw data or defining your own converters. The field type is stored with every cursor in the description for each column. The following example shows ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-fieldtype.html
This class provides all supported MySQL field or data types. They can be useful when dealing with raw data or defining your own converters. The field type is stored with every cursor in the description for each column. The following example shows ...
https://dev.mysql.com/doc/internals/en/compressed-payload.html
If the length of payload before compression is more than 0 the Compressed Packet header is followed by the compressed payload. It uses the deflate algorithm as defined in RFC 1951 and implemented in zlib. The header of the compressed packet has the ...
https://dev.mysql.com/doc/internals/en/dbug-directory.html
Rather, it's a set of public-domain routines which are useful for debugging MySQL programs. The MySQL Server and all .c and .cc programs support the use of this package. How it works: One inserts a function call that begins with DBUG_* in one of the ...
https://dev.mysql.com/doc/internals/en/error-masking.html
Example: --error ER_BAD_DB_ERROR USE <not existing database>; You can find the error names in the include/mysqld_error.h file of a MySQL source distribution, or in the Server Error Message Reference section of the MySQL Reference Manual]. Use of the ...
https://dev.mysql.com/doc/internals/en/layout-record-storage-frame.html
MI_MIN_BLOCK_LENGTH 20 /* 20 bytes are required for the biggest frame type: Deleted block. */ MI_MAX_BLOCK_LENGTH 16777212 /* 16MB - 4, max 3 bytes for length available, 4-byte aligned. data_len is the number of bytes within this block that are ...
https://dev.mysql.com/doc/internals/en/optimizer-not-relations.html
It is a logical rule that column1 <> 5 is the same as column1 < 5 OR column1 > 5 However, MySQL does not transform in this circumstance. If you think that a range search would be better, then you should do your own transforming in such cases. It is ...