Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-defragmenting.html
Random insertions into or deletions from a secondary index can cause the index to become fragmented. If the insertions into an index are always ascending and records are deleted only from the end, the InnoDB filespace management algorithm ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-system-tables.html
As a final step, insert a row into table t1 (TABLE_ID = 71) and view the data in the INNODB_TABLESTATS table. mysql> INSERT INTO t1 VALUES(5, 'abc', 'def'); Query OK, 1 row affected (0.06 sec) mysql> SELECT * FROM ... You can extract metadata about ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-failure-conditions.html
For example, you might insert duplicate values into a column while a unique index is being created, or you might insert NULL values into a column while creating a primary key index on that column. The failure of an online DDL operation is typically ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given query.
https://dev.mysql.com/doc/refman/8.4/en/json-search-functions.html
The functions in this section perform search or comparison operations on JSON values to extract data from them, report whether data exists at a location within them, or report the path to data within them. JSON_CONTAINS(target, candidate[, path]) ...
https://dev.mysql.com/doc/refman/8.4/en/locking-functions.html
If the intent is for there to be a correspondence between rows inserted and locks acquired, that intent is not satisfied. While held by one session, other sessions cannot obtain a lock of the same name. Returns 1 if the lock was obtained ...
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 ...