Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-cmd-refresh.html
This method flushes tables or caches, or resets replication server information. The options argument should be a bitmask value constructed using constants from the constants.RefreshOption class. Example: >>> from mysql.connector import RefreshOption ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-cmd-statistics.html
Returns a dictionary containing information about the MySQL server including uptime in seconds and the number of running threads, questions, reloads, and open tables.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-commit.html
Since by default Connector/Python does not autocommit, it is important to call this method after every transaction that modifies data for tables that use transactional storage engines. This method sends a COMMIT statement to the MySQL server, ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-lastrowid.html
For example, if you perform an INSERT into a table that contains an AUTO_INCREMENT column, lastrowid returns the AUTO_INCREMENT value for the new row. Syntax: id = cursor.lastrowid This read-only property returns the value generated for an ...
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/authentication-method.html
For earlier servers it is always Secure Password Authentication or Old Password Authentication depending on the CLIENT_SECURE_CONNECTION flag. Client and server negotiate what types of authentication they support as part of the connection phase.
https://dev.mysql.com/doc/internals/en/autotools-plugin-macros.html
This macro is roughly equivalent to: MYSQL_PLUGIN(name, 'long-name, description) MYSQL_PLUGIN_DEFINE(name, WITH_NAME_STORAGE_ENGINE) Example: MYSQL_STORAGE_ENGINE(berkeley, berkeley-db, [BerkeleyDB Storage Engine], [Transactional Tables using ...
https://dev.mysql.com/doc/internals/en/binlog-event-flag.html
Hex Flag 0x0001 LOG_EVENT_BINLOG_IN_USE_F 0x0002 LOG_EVENT_FORCED_ROTATE_F 0x0004 LOG_EVENT_THREAD_SPECIFIC_F 0x0008 LOG_EVENT_SUPPRESS_USE_F 0x0010 LOG_EVENT_UPDATE_TABLE_MAP_VERSION_F 0x0020 LOG_EVENT_ARTIFICIAL_F 0x0040 LOG_EVENT_RELAY_LOG_F ...
https://dev.mysql.com/doc/internals/en/binlog-row-image.html
Status of this subsection: finished, not reviewed, not fully implemented 2009-10-21 The sets of columns recorded in the BI and AI are determined by the value of binlog_row_image. To specify the sets of columns, we define the PKE (for Primary Key ...
https://dev.mysql.com/doc/internals/en/binlog-version.html
Depending on the MySQL Version that created the binlog the format is slightly different.