Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnectionpool-constructor.html
Syntax: MySQLConnectionPool(pool_name=None, pool_size=5, pool_reset_session=True, **kwargs) This constructor instantiates an object that manages a connection pool. Example: dbconfig = { "database": "test", "user": "joe", } cnxpool = ...If this ...
https://dev.mysql.com/doc/connector-python/en/connector-python-asyncio.html
async with await connect(**config) as cnx: # Show tables await cnx.cmd_query("SHOW tables") show_tables = (await cnx.get_rows())[0] # Return execution sequence and table names retrieved with `SHOW tables;`. Installing Connector/Python also installs ...
https://dev.mysql.com/doc/internals/en/code-tree-representation.html
This is safe as the size of the trees is limited by either having a maximum of 256 elements for byte value compression or 4096 elements for distinct column value compression. Every left branch gets a 0 bit, every right branch gets a 1 bit. The ...
https://dev.mysql.com/doc/internals/en/com-binlog-dump-gtid.html
If the binlog-filename is empty, the server will send the binlog-stream of the first known binlog.
https://dev.mysql.com/doc/internals/en/example-several-mysql-packets.html
64 d Note sending a MySQL Packet of the size 224−5 to 224−1 via compression leads to at least one extra compressed packet. Executing SELECT repeat("a", 50) results in uncompressed ProtocolText::Resultset like: 01 00 00 01 01 25 00 00 02 03 64 ...
https://dev.mysql.com/doc/internals/en/getting-source-tree.html
This section describes how to obtain the MySQL source tree, which is currently available on GitHub. For more information about MySQL's move to GitHub, refer to the announcement on the MySQL Release Engineering blog: MySQL on GitHub To obtain the ...
https://dev.mysql.com/doc/internals/en/guided-tour-majordir-mysys.html
This is the toolbox directory, for example it has low level routines for file access. Sampling of programs on mysql-5.0/mysys size name comment ---- ---- ------- 17684 charset.c character sets 6165 mf_qsort.c quicksort 5609 mf__tempfile.c temporary ... The next major directory is labelled mysys, which stands for MySQL System ...
https://dev.mysql.com/doc/internals/en/implementing-savepoint-set-method.html
The savepoint_set() method is called whenever a user issues the SAVEPOINT statement: int (*savepoint_set)(THD *thd, void *sv); The *sv parameter points to an uninitialized storage area of the size defined by savepoint_offset. When savepoint_set() ...
https://dev.mysql.com/doc/internals/en/innodb-fil-header.html
The word "space" is generic jargon for either "log" or "tablespace". -------- - root - -------- | ---------------------- | | | | -------- -------- - leaf - <--> - leaf - -------- -------- Everyone has seen a B-tree and knows that the entries in the ...
https://dev.mysql.com/doc/internals/en/innodb-fil-trailer.html
The Fil Trailer has one part, as follows: Name Size Remarks FIL_PAGE_END_LSN 8 low 4 bytes = checksum of page, last 4 bytes = same as FIL_PAGE_LSN The final part of a page, the fil trailer (or File Page Trailer), exists because InnoDB's architect ...It's impossible for a page to be only half-written, or corrupted by crashes, because the log-recovery mechanism restores to a consistent ...