Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-autocommit-commit-rollback.html
By default, MySQL starts the session for each new connection with autocommit enabled, so MySQL does a commit after each SQL statement if that statement did not return an error. Grouping DML Operations with Transactions By default, connection to the ...If autocommit mode is enabled, each SQL statement forms a single transaction on its ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-table-import.html
FOR EXPORT must remain open while the operation is running; otherwise, the .cfg file is removed as locks are released upon connection closure. This section describes how to import tables using the Transportable Tablespaces feature, which permits ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-isolation-levels.html
A user can change the isolation level for a single session or for all subsequent connections with the SET TRANSACTION statement. To set the server's default isolation level for all connections, use the --transaction-isolation option on the command ... Transaction isolation is one of the foundations of database ...
https://dev.mysql.com/doc/refman/8.4/en/insert-optimization.html
Ideally, you make a single connection, send the data for many new rows at once, and delay all index updates and consistency checking until the very end. To optimize insert speed, combine many small operations into a single large operation. The size ...
https://dev.mysql.com/doc/refman/8.4/en/installing-development-tree.html
The initial download may take some time to complete, depending on the speed of your connection. This section describes how to install MySQL from the latest development source code, which is hosted on GitHub. To obtain the MySQL Server source code ...
https://dev.mysql.com/doc/refman/8.4/en/ipv6-brokers.html
After configuring your server host to use a broker-supplied IPv6 address, start the MySQL server with an appropriate bind_address setting to permit the server to accept IPv6 connections. Note that if the broker allocates dynamic addresses, the ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-system-variables.html
If this variable is not set, the keyring_hashicorp plugin opens an HTTPS connection without using server certificate verification, and trusts any certificate delivered by the HashiCorp Vault server. These variables are unavailable unless the ...
https://dev.mysql.com/doc/refman/8.4/en/load-xml.html
In a Web environment, clients usually connect to MySQL from a Web server. In this environment, the client with respect to the MySQL server is actually the Web server, not the remote program being run by the user who connects to the Web server. The ...
https://dev.mysql.com/doc/refman/8.4/en/lock-tables.html
(For additional information about the interaction between table locking and transactions, see Interaction of Table Locking and Transactions.) If the connection for a client session terminates, whether normally or abnormally, the server implicitly ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-first-start.html
Note The IP address shown for a given NDB Cluster SQL or other API node in the output of SHOW is the address used by the SQL or API node to connect to the cluster data nodes, and not to any management node. Starting the cluster is not very ...