Search Results
https://dev.mysql.com/doc/internals/en/variation-of-storage-engine.html
Checks of the INFORMATION_SCHEMA The storage engines to be used for information_schema tables are hardcoded. Therefore tests focussed on permissions, optimizer strategies, column data types etc. when selecting on INFORMATION_SCHEMA tables should ...
https://dev.mysql.com/doc/internals/en/optimizer-transpositions.html
MySQL supports transpositions (reversing the order of operands around a relational operator) for simple expressions only. In other words: WHERE - 5 = column1 becomes: WHERE column1 = -5 However, MySQL does not support transpositions where ...
https://dev.mysql.com/doc/internals/en/custom-engine-overview.html
The MySQL server is built in a modular fashion: The storage engines manage data storage and index management for MySQL. The MySQL server communicates with the storage engines through a defined API. Each storage engine is a class with each instance ...
https://dev.mysql.com/doc/internals/en/debug-configurations.html
Using Makefiles, a debug build is done with -DCMAKE_BUILD_TYPE=Debug (an alias for this is -DWITH_DEBUG=1). This includes DBUG instrumentation, plus wrappers around pthread mutexes known as SAFE_MUTEX on Unix systems. If Visual Studio or Xcode ...
https://dev.mysql.com/doc/internals/en/logging-transactions-rules-for-create-table-select.html
(R-log-create-select-statement-format) If logging in statement format (that is, one of the following holds: (1) @@SESSION.binlog_format=STATEMENT; (2) @@SESSION.binlog_format=MIXED and statement is safe): If there is an error, do not write anything.
https://dev.mysql.com/doc/relnotes/mysql-monitor/8.0/en/news-8-0-27.html
Functionality Added or Changed The MySQL server, bundled with MySQL Enterprise Service Manager, has been upgraded to MySQL 8.0.27. The Tomcat server, bundled with MySQL Enterprise Service Manager, has been upgraded to 8.5.70. The OpenSSL libraries ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-collections-basic-crud.html
Working with collections of documents is straightforward when using X DevAPI. The following example shows the basic usage of CRUD operations (see Section 4.3, “Collection CRUD Function Overview” for more details) when working with documents: ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-collections-basic-crud.html
Working with collections of documents is straightforward when using X DevAPI. The following example shows the basic usage of CRUD operations (see Section 4.3, “Collection CRUD Function Overview” for more details) when working with documents: ...
https://dev.mysql.com/doc/connectors/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. If this argument is not given, Connector/Python automatically generates the name, ...
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. If this argument is not given, Connector/Python automatically generates the name, ...