Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-connectargs.html
A connection with the MySQL server can be established using either the mysql.connector.connect() function or the mysql.connector.MySQLConnection() class: cnx = mysql.connector.connect(user='joe', database='test') cnx = MySQLConnection(user='joe', ...An asterisk (*) following an argument indicates a synonymous argument name, available only for compatibility with other Python MySQL ...
https://dev.mysql.com/doc/internals/en/binlog-formats.html
There are three types of log_events: Write_rows_log_event: adds a new row to a table. Status of this subsection: Complete but not reviewed 2009-10-21 The binlog is organized as a linear sequence of events. An SQL query that modifies the database ...
https://dev.mysql.com/doc/internals/en/client-directory.html
The client library includes mysql.cc (the source of the mysql executable) and other utilities. Most of the utilities are mentioned in the MySQL Reference Manual. Generally these are standalone C programs which one runs in "client mode", that is, ...
https://dev.mysql.com/doc/internals/en/com-refresh.html
Note As of MySQL 5.7.11, COM_REFRESH is deprecated and will be removed in a future version of MySQL.
https://dev.mysql.com/doc/internals/en/custom-engine-overview.html
Handlers are instanced on the basis of one handler for each thread that needs to work with a specific table. For example: If three connections all start working with the same table, three handler instances will need to be created. Once a handler ...
https://dev.mysql.com/doc/internals/en/defining-filename-extensions.html
Storage engines are required to provide the MySQL server with a list of extensions used by the storage engine with regard to a given table, its data and indexes. Extensions are expected in the form of a null-terminated string array.
https://dev.mysql.com/doc/internals/en/determining-logging-format.html
This must be done prior to the call to THD::decide_logging_format() (that is, prior to lock_tables). For each statement, we must determine the logging format: row or statement. At parse time, it is detected if the statement is unsafe to log in ...
https://dev.mysql.com/doc/internals/en/err-instead-of-eof.html
00 05 74 61 62 6c 65 00 0c 08 00 40 00 00 00 fd ..table....@.... 48 04 23 48 59 30 30 30 4e 6f 20 74 61 62 6c 65 H.#HY000No table 73 20 75 73 65 64 s used See how after the column definitions a ERR_Packet is sent: 17 00 00 0d ff ................ 48 ... EXPLAIN SELECT * FROM dual; results in 01 00 00 01 0a 18 00 00 02 03 64 65 66 00 00 00 ...
https://dev.mysql.com/doc/internals/en/huffman-compression.html
One could take all possible values - say of a table column - as "messages". But if there are too many of them, the code tables could become bigger than the uncompressed table. In his article from 1952 Huffman proved that his algorithm uses the least ...
https://dev.mysql.com/doc/internals/en/implementing-store-lock-method.html
Before adding the lock into the table lock handler mysqld calls store lock with the requested locks. Store lock can modify the lock level, for example change blocking write lock to non-blocking, ignore the lock (if we don't want to use MySQL table ... The [custom-engine.html#custom-engine-api-reference-store_lock store_lock()] method is called before any reading or writing is ...