Search Results
https://dev.mysql.com/doc/refman/8.4/en/locking-service.html
If the intent is for there to be a correspondence between rows inserted and locks acquired, that intent is not satisfied. MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-general-options.html
key_buffer_size is used when you are checking the table with --extend-check or when the keys are repaired by inserting keys row by row into the table (like when doing normal inserts). The options described in this section can be used for any type ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-limits.html
Memory consumed when data is inserted into an NDB table is not automatically recovered when deleted, as it is with other storage engines. Instead, the following rules hold true: A DELETE statement on an NDB table makes the memory formerly used by ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-params-ndbd.html
InsertRecoveryWork: Percentage of RecoveryWork used for inserted rows; has no effect unless partial local checkpoints are in use. RestartOnErrorInsert: Control type of restart caused by inserting error (when StopOnError is enabled). The listings in ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-blob-tool.html
This tool can be used to check for and remove orphaned BLOB column parts from NDB tables, as well as to generate a file listing any orphaned parts. It is sometimes useful in diagnosing and repairing corrupted or damaged NDB tables containing BLOB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-desc.html
ndb_desc provides a detailed description of one or more NDB tables. Usage ndb_desc -c connection_string tbl_name -d db_name [options] ndb_desc -c connection_string index_name -d db_name -t tbl_name Additional options that can be used with ndb_desc ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-import.html
--errins-type=name Command-Line Format --errins-type=name Type Enumeration Default Value [none] Valid Values stopjobstopallsighupsigintlist Error insert type; use list as the name value to obtain all possible values. --errins-delay=# Command-Line ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-mta.html
Conversely, transactions performing inserts, updates and deletes on foreign key child tables (referencing) are not especially serialized with regard to one another. To use this functionality with NDB Cluster, it is necessary that the replica be ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-nutshell.html
Firewall stored procedures now avoid performing unnecessary combinations of DELETE plus INSERT statements, as well as those of INSERT IGNORE plus UPDATE operations, thus consuming less time and fewer resources, making them faster and more efficient.
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-transaction-management.html
Avoid performing rollbacks after inserting, updating, or deleting huge numbers of rows. Set innodb_change_buffering=all so that update and delete operations are buffered in addition to inserts. To optimize InnoDB transaction processing, find the ...