Search Results
https://dev.mysql.com/doc/refman/8.4/en/select-optimization.html
Tuning these statements is a top priority, whether to achieve sub-second response times for dynamic web pages, or to chop hours off the time to generate huge overnight reports. With efficient use of the InnoDB buffer pool, MyISAM key cache, and the ...NDB Cluster supports a join pushdown optimization whereby a qualifying join is sent in its entirety to NDB Cluster data nodes, where it can be distributed among them and executed in ...
https://dev.mysql.com/doc/connectors/en/connector-net-connections-pooling.html
You can turn it off or adjust its performance characteristics using the connection string options Pooling, Connection Reset, Connection Lifetime, Cache Server Properties, Max Pool Size and Min Pool Size. At runtime, Connector/NET selects one of the ... The MySQL Connector/NET supports connection pooling for better performance and scalability with database-intensive ...
https://dev.mysql.com/doc/connector-net/en/connector-net-connections-pooling.html
You can turn it off or adjust its performance characteristics using the connection string options Pooling, Connection Reset, Connection Lifetime, Cache Server Properties, Max Pool Size and Min Pool Size. At runtime, Connector/NET selects one of the ... The MySQL Connector/NET supports connection pooling for better performance and scalability with database-intensive ...
https://dev.mysql.com/doc/internals/en/write-row.html
Synopsis virtual int write_row ( buf); byte * buf ; Description This is the write_row method. No [custom-engine.html#custom-engine-api-reference-extra extra()] hint is given currently if a bulk load is happening. buf is a byte array of data with a ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/transaction-handling.html
Transactions can be used to group operations into an atomic unit. Either all operations of a transaction succeed when they are committed, or none. It is possible to roll back a transaction as long as it has not been committed. Transactions can be ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/transaction-handling.html
Transactions can be used to group operations into an atomic unit. Either all operations of a transaction succeed when they are committed, or none. It is possible to roll back a transaction as long as it has not been committed. Transactions can be ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-usage.html
Rewriting Prepared Statements Prepared statements are rewritten at parse time (that is, when they are prepared), not when they are executed later. This is also true for statements executed by MySQL client programs including mysqlbinlog, mysqladmin, ... To enable or disable the plugin, enable or disable the rewriter_enabled system ...
https://dev.mysql.com/doc/workbench/en/wb-note-editor.html
Any number of notes may be open at the same time. To invoke the note editor, double-click a note object in the Model Note section on the MySQL Model page. This opens the note editor docked at the bottom of the application. Each additional note ...
https://dev.mysql.com/doc/x-devapi-userguide/en/connection-attributes-xdevapi.html
Connection attributes are key-value pairs that application programs can pass to the server during connection time to be stored in the PERFORMANCE_SCHEMA tables session_account_connect_attrs and session_connect_attrs. There are two different kinds ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/connection-attributes-xdevapi.html
Connection attributes are key-value pairs that application programs can pass to the server during connection time to be stored in the PERFORMANCE_SCHEMA tables session_account_connect_attrs and session_connect_attrs. There are two different kinds ...