Search Results
https://dev.mysql.com/doc/connectors/en/connector-net-programming-prepared.html
Prepared statements can provide significant performance improvements on queries that are executed more than one time. Prepared execution is faster than direct execution for statements executed more than once, primarily because the query is parsed ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-prepared.html
Prepared statements can provide significant performance improvements on queries that are executed more than one time. Prepared execution is faster than direct execution for statements executed more than once, primarily because the query is parsed ...
https://dev.mysql.com/doc/internals/en/transaction-overview.html
Transactions are not explicitly started on the storage engine level, but are instead implicitly started through calls to either start_stmt() or external_lock(). If the preceding methods are called and a transaction already exists the transaction is ...
https://dev.mysql.com/doc/internals/en/filesort.html
This algorithm is described in the MySQL Reference manual; see ORDER BY Optimization.
https://dev.mysql.com/doc/relnotes/mysql-monitor/8.0/en/news-8-0-16.html
Functionality Added or Changed Bugs Fixed Functionality Added or Changed The OpenSSL libraries used by MySQL Enterprise Monitor installers have been upgraded to 1.0.2r. The bundled JRE was updated to 1.8.0_212 for both the Agent and Service Manager.
https://dev.mysql.com/doc/internals/en/code-tree-representation.html
Every left branch gets a 0 bit, every right branch gets a 1 bit. The in-memory representation of the trees are two unsigned integers per node. Each describes either a leaf value or an offset (in unsigned integers relative from this node) to another ...
https://dev.mysql.com/doc/internals/en/event-class-archaeological-notes.html
Despite the "V3" in the type code name, START_EVENT_V3 currently is used as the type code not only for v3 start events, but also for v1 start events. The original symbol for type code 1 was START_EVENT in the format now known as v1. Later, when v3 ...
https://dev.mysql.com/doc/internals/en/os-specific-commands.html
The exec and system commands enable tests to execute external commands. However, many of such commands are available only on certain platforms. (For example, rm is Unix-specific and not available on Windows.) Please avoid these commands if possible. Have a look at the mysqltest manual and the t/mysqltest.test test ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-report-table.html
From MySQL version 8.0.32 onwards, the heatwave_advisor_report table, is deprecated and replaced with the heatwave_autopilot_report table in the sys schema. When MySQL runs Advisor, it sends detailed output to the heatwave_advisor_report table in ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-exclude-table-columns.html
Before loading a table into MySQL HeatWave, exclude the columns with unsupported data types. For a list of data types that MySQL HeatWave supports, see Section 4.2.1, “Supported Data Types for MySQL HeatWave”. With MySQL version 8.2.0 or ...