Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-internals.html
Updates and inserts of small records may be written to this modification log without requiring the entire page to be completely reconstructed. If recompression fails (a situation known as a compression failure), the B-tree nodes are split and the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlock-example.html
Client A enables innodb_print_all_deadlocks, creates two tables, 'Animals' and 'Birds', and inserts data into each. The following example illustrates how an error can occur when a lock request causes a deadlock. Thererfore, the previous read-only ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlocks-handling.html
You can get deadlocks even in the case of transactions that just insert or delete a single row. That is because these operations are not really “atomic”; they automatically set locks on the (possibly several) index records of the row inserted or ... This section builds on the conceptual information about deadlocks in Section 17.7.5.2, “Deadlock ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-operations.html
The change buffer is not used, because there are no random-access inserts into the secondary indexes. The next row inserted into the table uses the specified value for its auto-increment column. Online support details, syntax examples, and usage ...
https://dev.mysql.com/doc/refman/8.4/en/json-function-reference.html
Table 14.22 JSON Functions Name Description Deprecated -> Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT(). ->> Return value from JSON column after evaluating path and unquoting the result; equivalent to ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-log-statistics.html
This includes all inserts, updates, writes and deletes, as well as writes performed as part of unique index operations. For inserts and updates, this is proportional to the number of columns written, and the size of their data. The Operations ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-memory-per-fragment.html
Each variable-sized page is reorganized as needed to fit the changing size of variable-sized row parts as they are inserted, updated, and deleted; if a given row part grows too large for the page it is in, it can be moved to a different page.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-option-tables.html
Ndb_conflict_fn_max_ins: Number of times that NDB replication conflict resolution based on "greater timestamp wins" has been applied to insert operations. Ndb_conflict_fn_max_del_win_ins: Number of times that NDB replication conflict resolution ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-move-data.html
Usage The program is invoked with the names of the source and target tables; either or both of these may be qualified optionally with the database name. ndb_move_data options source target Options that can be used with ndb_move_data are shown in the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html
Initially, mysql executes statements in the input because specifying a database db_name on the command line is equivalent to inserting USE db_name at the beginning of the input. The INSERT and CREATE TABLE statements are executed because the default ... mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option ...