Search Results
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-spring-config-connpooling.html
Pooling of connections also alleviates problems such as collecting large amounts of sockets in the TIME_WAIT state. The difference is that DBCP will pool connections to the database instead of creating a new connection every time one is requested.
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/refman/8.4/en/performance-schema-stage-tables.html
The Performance Schema tables provide a container to store progress data, but make no assumptions about the semantics of the metric itself: A “work unit” is an integer metric that increases over time during execution, such as the number of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-debugging-queries.html
Setting Secondary Engine Definition By default, SELECT queries are offloaded to MySQL HeatWave for execution and fall back to the DB System if that is not possible. To force a query to execute on MySQL HeatWave or fail if that is not possible, set ... This topic describes how to debug queries that fail to offload to MySQL HeatWave for ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-consistency-guarantees.html
A transaction cannot be on-hold forever, and if the time held exceeds wait_timeout it returns an ER_GR_HOLD_WAIT_TIMEOUT error. Transactions whose consistency level is not EVENTUAL hold execution until a timeout, configured by wait_timeout value is ... Although the Transaction Synchronization Points section explains that conceptually there are two synchronization points from which you can choose: on read or on write, these terms were a simplification and the terms used in Group Replication are: before and after transaction ...
https://dev.mysql.com/doc/internals/en/binary-log-structure-and-contents.html
The details about event structure have changed over time, which gives rise to different versions of the binary log format. The binary log is a set of files that contain information about data modifications made to a MySQL server instance. The log ...
https://dev.mysql.com/doc/connectors/en/connector-net-interceptors.html
The BaseCommandInterceptor class has these methods that you can override: public virtual bool ExecuteScalar(string sql, ref object returnValue); public virtual bool ExecuteNonQuery(string sql, ref int returnValue); public virtual bool ... An ...
https://dev.mysql.com/doc/connector-net/en/connector-net-interceptors.html
The BaseCommandInterceptor class has these methods that you can override: public virtual bool ExecuteScalar(string sql, ref object returnValue); public virtual bool ExecuteNonQuery(string sql, ref int returnValue); public virtual bool ... An ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-syntax.html
query_insights: Provides runtime information for successfully executed queries and runtime estimates for EXPLAIN queries, queries cancelled using Ctrl+C, and queries that fail due to an out-of-memory error. For the most accurate recommendations, ...
https://dev.mysql.com/doc/refman/8.4/en/stored-objects-security.html
For an event, an error occurs at event execution time if the account does not exist. Stored programs (procedures, functions, triggers, and events) and views are defined prior to use and, when referenced, execute within a security context that ...