Search Results
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-spring-config-jdbctemplate.html
Spring makes extensive use of the Template method design pattern (see Template Method Pattern). Our immediate focus will be on the JdbcTemplate and related classes, specifically NamedParameterJdbcTemplate. The template classes handle obtaining and ...
https://dev.mysql.com/doc/internals/en/writing-platform-checks.html
If you modify MySQL source and want to add a new platform check, please read http://www.vtk.org/Wiki/CMake_HowToDoPlatformChecks first. In MySQL, most of the platform tests are implemented in configure.cmake and the template header file, ...
https://dev.mysql.com/doc/ndbapi/en/ndb-nodejs-overview.html
This connector differs in a number of key respects from most other MySQL Connectors and APIs. In addition, it employs a domain object model for data storage. Applications retrieve data in the form of fully-instantiated objects, rather than as rows ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-myisam-bulk-data-loading.html
Locking also lowers the total time for multiple-connection tests, although the maximum wait time for individual connections might go up because they wait for locks. For a MyISAM table, you can use concurrent inserts to add rows at the same time that ... These performance tips supplement the general guidelines for fast inserts in Section 10.2.5.1, “Optimizing INSERT ...
https://dev.mysql.com/doc/refman/8.4/en/persisted-system-variables.html
Many system variables are dynamic and can be changed at runtime using the SET statement to affect operation of the current server instance. Modifying system variables with SET GLOBAL is a runtime capability that can be done from clients run locally ... The MySQL server maintains system variables that configure its ...
https://dev.mysql.com/doc/refman/8.4/en/cursor-restrictions.html
For example, if a client executes a query but is only interested in the first row, the remaining rows are not transferred. Initially, this is a MEMORY table, but is converted to a MyISAM table when its size exceeds the minimum value of the ...
https://dev.mysql.com/doc/refman/8.4/en/hash-joins.html
When the memory required for a hash join exceeds the amount available, MySQL handles this by using files on disk. It is possible to control whether hash joins are employed using one of the BNL and NO_BNL optimizer hints, or by setting ...
https://dev.mysql.com/doc/connector-net/en/connector-net-faq.html
Questions 10.1: Are all commands executed after a transaction begins automatically enlisted in the transaction? 10.2: How do I obtain the value of an auto-incremented column? Questions and Answers10.1: Are all commands executed after a transaction ...When a client begins a transaction in classic MySQL, all subsequent commands (on that connection) are part of that transaction until the client commits or rolls back the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-limits.html
The maximum number of operations that can be performed per transaction is set using the configuration parameters MaxNoOfConcurrentOperations and MaxNoOfLocalOperations. For example, the maximum number of ordered indexes in the cluster is determined ... In this section, we list limits found in NDB Cluster that either differ from limits found in, or that are not found in, standard ...
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-20.html
If compression is required, compression algorithm negotiation occurs as for preferred mode, but if no common algorithm is available, the connection request terminates with an error. To avoid CPU inefficiency, data packets are not compressed even ...