Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursorbuffered.html
After executing a query, a MySQLCursorBuffered cursor fetches the entire result set from the server and buffers the rows. For queries executed using a buffered cursor, row-fetching methods such as fetchone() return rows from the set of buffered rows. For nonbuffered cursors, rows are not fetched from the server until a row-fetching method is ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-block-encryption-mode.html
If you use the AES_ENCRYPT() encryption function, a block encryption mode with a CBC mode value and key length of 256 is recommended. Set this option to aes-256-cbc, for example, under the [mysqld] option group in the MySQL configuration file ...
https://dev.mysql.com/doc/internals/en/select-structure.html
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 a bunch The latter item represents UNION operation (the absence of UNION ...
https://dev.mysql.com/doc/workbench/en/wb-linux-uninstalling.html
The procedure for uninstalling MySQL Workbench on Linux depends on the package you are using. Note When using apt, the official package name at dev.mysql.com is mysql-workbench-community, whereas most Linux distributions use the name ...
https://dev.mysql.com/doc/internals/en/rows-event.html
repeat rows until event-end Fields table_id (6) -- If the table id is 0x00ffffff it is a dummy event that should have the end of statement flag set that declares that all table maps can be freed. Note if the post_header_length in the ...
https://dev.mysql.com/doc/workbench/en/wb-migration-overview.html
The Migration Wizard performs the following steps when migrating a database to MySQL: Connects to the source RDBMS and retrieves a list of available databases/schemas. Reverse engineers selected database/schemas into a internal representation ...
https://dev.mysql.com/doc/internals/en/getting-index-information.html
It is preferable for storage engines that support indexing to read the index information provided during a CREATE TABLE operation and store it for future use. The reasoning behind this is that the index information is most readily available during ...
https://dev.mysql.com/doc/internals/en/source-files-related-to-the-binary-log.html
This section describes the files in a MySQL source tree that are most relevent to binary log processing. sql directory: log.h /log.cc: The high-level binary logging mechanism for organizing events into a sequence so that it becomes a binary log.
https://dev.mysql.com/doc/internals/en/select-subquery.html
In expressions, subqueries (that is, subselects) are represented by Item inherited from Item_subselect. To hide difference in performing single SELECTs and UNIONs, Item_subselect uses two different engines, which provide uniform interface for ...
https://dev.mysql.com/doc/internals/en/implementing-the-info-method.html
The optimizer requests an update of table information by calling the [custom-engine.html#custom-engine-api-reference-info handler::info()] method. The info() method does not have a return value, instead it is expected that the storage engine will ...