Search Results
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.
https://dev.mysql.com/doc/internals/en/class-procedure-change-columns.html
Prototype: virtual bool change_columns(List<Item> &field_list); Here you can change the structure of the result field list, for example, you can add fields to the field_list or replace the queries result fields by something completely different ...
https://dev.mysql.com/doc/internals/en/cowork-with-dbug-facility.html
When running the MySQL test suite with a "debug" server (the DBUG facility is configured in) and the --debug command line option, the Debug Sync Facility writes trace messages to the DBUG trace. The following shell commands proved very useful in ...