Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlock-detection.html
Resolve these situations by setting the value of the innodb_lock_wait_timeout system variable. A wait-for list that exceeds 200 transactions is treated as a deadlock and the transaction attempting to check the wait-for list is rolled back. The same ... When deadlock detection is enabled (the default), InnoDB automatically detects transaction deadlocks and rolls back a transaction or transactions to break the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-failure-conditions.html
The operation takes a long time and concurrent DML modifies the table so much that the size of the temporary online log exceeds the value of the innodb_online_alter_log_max_size configuration option. A timeout occurs while waiting for an exclusive ... The failure of an online DDL operation is typically due to one of the following conditions: An ALGORITHM clause specifies an algorithm that is not compatible with the particular type of DDL operation or storage ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-group-write-consensus.html
This section explains how to inspect and configure the maximum number of consensus instances at any time for a group. This maximum is referred to as the event horizon for a group, and is the maximum number of consensus instances that the group can ...This enables you to fine tune the performance of your Group Replication ...
https://dev.mysql.com/doc/ndbapi/en/ndb-nodejs-api-session.html
Batch createBatch() Creates a new, empty batch for collecting multiple operations to be executed together. A session is the main user access path to the database. Session extends Context getMapping(Object parameter, Function(Object err, Object ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-connection-parameters.html
NO_DATE_OVERFLOW Ignore data overflow error 0 Continue with the query execution rather then return error if the time portion is missing. The driver supports the initial statement being executed only at the time of the initial connection. readtimeout ...Each attempt uses this timeout value and there are retries if necessary, so the total effective timeout value is three times the option ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-connection-parameters.html
NO_DATE_OVERFLOW Ignore data overflow error 0 Continue with the query execution rather then return error if the time portion is missing. The driver supports the initial statement being executed only at the time of the initial connection. readtimeout ...Each attempt uses this timeout value and there are retries if necessary, so the total effective timeout value is three times the option ...
https://dev.mysql.com/doc/ndbapi/en/overview-synchronous-transactions.html
Synchronous transactions are defined and executed as follows: Begin (create) the transaction, which is referenced by an NdbTransaction object typically created using Ndb::startTransaction(). To execute several synchronous transactions in parallel, ...At this point, the transaction is merely being defined; it is not yet sent to the NDB ...
https://dev.mysql.com/doc/workbench/en/wb-migration-wizard-data-migration-setup.html
Create a batch file to copy the data at another time: The data may also be dumped to a file that can be executed at a later time, or be used as a backup. Copy and extract the generated Zip file on the target host and then execute the import script ... Transfers data from the source RDBMS to the target MySQL database (see the figure that ...
https://dev.mysql.com/doc/workbench/en/wb-migration-install-odbc-drivers.html
Typically you need to provide a name for the data source (the DSN), in addition to the database server IP, port, username, and sometimes the database the user has access to. For each RDBMS, you need its corresponding ODBC driver, which must also be ...
https://dev.mysql.com/doc/internals/en/delete-row.html
Synopsis virtual int delete_row ( buf); const byte * buf ; Description This is the delete_row method. buf will contain a copy of the row to be deleted. The server will call this right after the current row has been called (from either a previous ...