Search Results
https://dev.mysql.com/doc/refman/8.4/en/general-thread-states.html
This state occurs after the table with the new structure has been created but before rows are copied into it. end This occurs at the end but before the cleanup of ALTER TABLE, CREATE VIEW, DELETE, INSERT, SELECT, or UPDATE statements. init This ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-index-table-table.html
Before information for newly inserted rows appears in INNODB_FT_INDEX_TABLE, the FULLTEXT index cache must be flushed to disk. The INNODB_FT_INDEX_TABLE table provides information about the inverted index used to process text searches against the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tablestats-table.html
The value could be imprecise if uncommitted transactions are inserting into or deleting from the table. MODIFIED_COUNTER The number of rows modified by DML operations, such as INSERT, UPDATE, DELETE, and also cascade operations from foreign keys.
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/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/partitioning-info.html
When insertions, deletions, or updates are made to partitioned tables, the binary log records information about the partition and (if any) the subpartition in which the row event took place. This section discusses obtaining information about ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-range.html
A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given range. Ranges should be contiguous but not overlapping, and are defined using the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-instrument-naming.html
This instrument comes into play when a scheduled event begins executing. For example, an insert might activate a trigger that causes an update. An instrument name consists of a sequence of elements separated by '/' characters. Example names: ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-query-profiling.html
The following example demonstrates how to use Performance Schema statement events and stage events to retrieve data comparable to profiling information provided by SHOW PROFILES and SHOW PROFILE statements. The setup_actors table can be used to ...