Search Results
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-performance-extensions.html
callableStmtCacheSize If 'cacheCallableStmts' is enabled, how many callable statements should be cached? Default Value 100 Since Version 3.1.2 metadataCacheSize The number of queries to cache 'ResultSetMetadata' for if 'cacheResultSetMetaData' is ...Prior to version 8.0.29, this property was named 'parseInfoCacheFactory', which remains as an ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-performance-extensions.html
callableStmtCacheSize If 'cacheCallableStmts' is enabled, how many callable statements should be cached? Default Value 100 Since Version 3.1.2 metadataCacheSize The number of queries to cache 'ResultSetMetadata' for if 'cacheResultSetMetaData' is ...Prior to version 8.0.29, this property was named 'parseInfoCacheFactory', which remains as an ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-examples.html
It is also important to note that the results vary depending on whether the operation is logged using statement-based or row-based binary logging format. With statement-based format, DML statements are handled based on the current database, as ...
https://dev.mysql.com/doc/refman/8.4/en/set-operations.html
Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT Limitations of Set Operations SQL set operations combine the results of multiple ...
https://dev.mysql.com/doc/refman/8.4/en/range-optimization.html
The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value intervals. Additionally, for BTREE indexes, comparison of a key part with a constant value is a range condition when ...The following sections describe conditions under which the optimizer uses range ...
https://dev.mysql.com/doc/connectors/en/connector-j-reference-implementation-notes.html
Because of this, use the corresponding PreparedStatement.setBlob() or ResultSet.updateBlob() (in the case of updatable result sets) methods to save changes back to the database. PreparedStatement Two variants of prepared statements are implemented ... MySQL Connector/J, as a rigorous implementation of the JDBC API, passes all of the tests in the publicly available version of Oracle's JDBC compliance test ...
https://dev.mysql.com/doc/internals/en/determining-logging-format.html
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 statement format (that is, requires row format). THD::decide_logging_format() determines the logging ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-implementation-notes.html
Because of this, use the corresponding PreparedStatement.setBlob() or ResultSet.updateBlob() (in the case of updatable result sets) methods to save changes back to the database. PreparedStatement Two variants of prepared statements are implemented ... MySQL Connector/J, as a rigorous implementation of the JDBC API, passes all of the tests in the publicly available version of Oracle's JDBC compliance test ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log.html
It also contains events for statements that potentially could have made changes (for example, a DELETE which matched no rows), unless row-based logging is used. The binary log also contains information about how long each statement took that updated ... The binary log contains “events” that describe database changes such as table creation operations or changes to table ...
https://dev.mysql.com/doc/refman/8.4/en/with.html
A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple times. The following discussion describes how to write ...