Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursorbuffereddict.html
A MySQLCursorBufferedDict cursor is like a MySQLCursorDict cursor, but is buffered: After executing a query, it fetches the entire result set from the server and buffers the rows. For information about the implications of buffering, see Section ...
https://dev.mysql.com/doc/connector-python/en/connector-python-cext-module.html
To use the C Extension directly, import the _mysql_connector module rather than mysql.connector, then use the _mysql_connector.MySQL() class to obtain a MySQL instance. For example: import _mysql_connector ccnx = _mysql_connector.MySQL() ...
https://dev.mysql.com/doc/connector-python/en/connector-python-cext.html
For queries that return large result sets, using the C Extension can improve performance compared to a “pure Python” implementation of the MySQL client/server protocol. Connector/Python supports a C extension that interfaces with the MySQL C ...
https://dev.mysql.com/doc/connector-python/en/connector-python-example-cursor-transaction.html
Inserting or updating data is also done using the handler structure known as a cursor. When you use a transactional storage engine such as InnoDB (the default in MySQL 5.5 and higher), you must commit the data after a sequence of INSERT, DELETE, ...
https://dev.mysql.com/doc/internals/en/additional-accessors-for-plugins.html
Starting with MySQL 5.1.21 the following additional accessors are made available to all plug-ins: Full definition of MYSQL_LEX_STRING (identical to LEX_STRING from m_string.h) Full definition of MYSQL_XID (binary compatible with XID from handler.h) ...
https://dev.mysql.com/doc/internals/en/binlog-event.html
START_EVENT_V3 FORMAT_DESCRIPTION_EVENT STOP_EVENT ROTATE_EVENT SLAVE_EVENT INCIDENT_EVENT HEARTBEAT_EVENT Statement Based Replication Events Statement Based Replication or SBR sends the SQL queries a client sent to the master AS IS to the slave.
https://dev.mysql.com/doc/internals/en/caching.html
(Note that the some of the filenames contain an incorrect spelling of the word “cache.”) Key Cache A shared cache for all B-tree index blocks in the different NISAM files. Uses hashing and reverse linked lists for quick caching of the most ...
https://dev.mysql.com/doc/internals/en/character-set.html
MySQL has a very flexible character set support as documented in Character Sets, Collations, Unicode. Number Hex Character Set Name 8 0x08 latin1_swedish_ci 33 0x21 utf8_general_ci 63 0x3f binary Protocol::CharacterSet A character set is defined in ...
https://dev.mysql.com/doc/internals/en/charsets.html
Character sets are used by MySQL when storing information, both to ensure that the information is stored (and returned) in the correct format, but also for the purposes of collation and sorting. Each character set supports one or more collations, ...
https://dev.mysql.com/doc/internals/en/class-procedure-add.html
Prototype: virtual void add(void); This member function is called once for every source row for a GROUP BY query.