Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-executemany.html
An optimization is applied for inserts: The data values given by the parameter sequences are batched using multiple-row syntax. Syntax: cursor.executemany(operation, seq_of_params) This method prepares a database operation (query or command) and ...
https://dev.mysql.com/doc/connector-python/en/connector-python-introduction.html
You can turn automatic conversion on for convenience, or off for optimal performance. MySQL Connector/Python enables Python programs to access MySQL databases, using an API that is compliant with the Python Database API Specification v2.0 (PEP 249). For notes detailing the changes in each release of Connector/Python, see MySQL Connector/Python Release ...
https://dev.mysql.com/doc/internals/en/bulk-insert.html
Instead of writing each key value to B-tree (that is, to the key cache, although the bulk insert code doesn't know about the key cache), we store keys in a balanced binary (red-black) tree, in memory. When this tree reaches its memory limit, we ...
https://dev.mysql.com/doc/internals/en/filesort.html
This algorithm is described in the MySQL Reference manual; see ORDER BY Optimization.
https://dev.mysql.com/doc/internals/en/flush-tables.html
This will also ensure that all table changes are flushed to disk (but of course not as optimally as simply calling a sync for all tables)! When you do a FLUSH TABLES, the variable refresh_version is incremented. The idea of FLUSH TABLES is to force ...
https://dev.mysql.com/doc/internals/en/guided-tour-skeleton.html
Remember, by the way, that MySQL stores frequently-used select statements and result sets in memory as an optimization, but once the insert succeeds the stored sets are invalid. And now we're going to walk through something harder, namely the ...
https://dev.mysql.com/doc/internals/en/heap-directory.html
All the MySQL table handlers (that is, the handlers that MySQL itself produces) have files with similar names and functions. Thus, this (heap) directory contains a lot of duplication of the myisam directory (for the MyISAM table handler). Such ...
https://dev.mysql.com/doc/internals/en/implementing-index-read-last-method.html
The [custom-engine.html#custom-engine-api-reference-index_read_last index_read_last()] method works like [custom-engine.html#custom-engine-index-read index_read()] but finds the last row with the current key value or prefix: int ...
https://dev.mysql.com/doc/internals/en/implementing-records-in-range-method.html
The [custom-engine.html#custom-engine-api-reference-records_in_range records_in_range()] method is called by the optimizer to assist in choosing which index on a table to use for a query or join. It is defined as follows: ha_rows ...
https://dev.mysql.com/doc/internals/en/implementing-rnd-next-method.html
(The table definition is stored in the .frm file, and the optimizer and the handler are both able to access table metadata from the same source, its TABLE structure). After the table is initialized, the MySQL server will call the handler's ...