Search Results
https://dev.mysql.com/doc/refman/8.4/en/optimizing-memory-tables.html
On the CREATE INDEX statement, use the clause USING BTREE or USING HASH. For best performance with MEMORY tables, examine the kinds of queries against each table, and specify the type to use for each associated index, either a B-tree index or a hash ... Consider using MEMORY tables for noncritical data that is accessed often, and is read-only or rarely ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-spatial-analysis.html
Other storage engines support non-SPATIAL indexes, as described in Section 15.1.15, “CREATE INDEX Statement”. For MyISAM and InnoDB tables, search operations in columns containing spatial data can be optimized using SPATIAL indexes. The most ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-new-primary.html
Explicitly defined transactions (with a START TRANSACTION or BEGIN statement) are subject to the timeout, disconnection, and incoming transaction blocking even if they do not modify any data. To allow inspection of the primary while the function is ... The following function enables you to set a member of a single-primary replication group to take over as the ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-j2ee-concepts-connection-pooling.html
When using connection pooling, always make sure that connections, and anything created by them (such as statements or result sets) are closed. The syntax needs to be exact for reasons of efficiency, as this test is done for every statement that is ... Connection pooling is a technique of creating and managing a pool of connections that are ready for use by any thread that needs ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-overview.html
This might include: allocate statement handle and set optional statement attributes. This might include: prepare the SQL statement and execute the SQL statement, or execute it directly without prepare. Interacting with a MySQL server from an ...
https://dev.mysql.com/doc/connectors/en/connector-python-opentelemetry.html
Query Span Time from when an SQL statement is requested (on the connector side) to the moment the connector finishes processing the server's reply to this statement. Query attributes with prepared statements is supported as of MySQL Enterprise ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-overview.html
This might include: allocate statement handle and set optional statement attributes. This might include: prepare the SQL statement and execute the SQL statement, or execute it directly without prepare. Interacting with a MySQL server from an ...
https://dev.mysql.com/doc/connector-python/en/connector-python-opentelemetry.html
Query Span Time from when an SQL statement is requested (on the connector side) to the moment the connector finishes processing the server's reply to this statement. Query attributes with prepared statements is supported as of MySQL Enterprise ...
https://dev.mysql.com/doc/internals/en/load-data-infile-events.html
LOAD DATA INFILE is not written to the binary log like other statements. It is written as one or more events in a packed format, not as a cleartext statement in the binary log. The events indicate what options are present in the statement and how ...Historically, there seem to have been at least four event sequences for representing LOAD DATA INFILE ...
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.