Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-data-adapter.html
It is also possible to work in a manner where a connection is only established when needed. For example, in this mode, a connection could be established to read a chunk of data, the data could then be modified by the application as required. A ...
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/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/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/indexing-overview.html
The information provided to the optimizer helps the optimizer to make better decisions about which index to use or even to skip using an index and instead perform a table scan. Adding index support to a storage engine revolves around two tasks: ...
https://dev.mysql.com/doc/internals/en/logging-transactions-preliminary-rules.html
(PR-causality) If statement A is executed before statement B, and B is logged in statement format, and B reads tables that A may modifies, then B shall be logged after A. In particular, changes to N-tables shall be written to the binary log when ...