Search Results
https://dev.mysql.com/doc/refman/8.4/en/explain.html
Obtaining Execution Plan Information The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, UPDATE, and TABLE statements. In practice, the DESCRIBE keyword is more often ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-innodb-change-buffer.html
What types of operations modify secondary indexes and result in change buffering? INSERT, UPDATE, and DELETE operations can modify secondary indexes. How do I determine the current size of the change buffer? The current size of the change buffer is ...What types of operations modify secondary indexes and result in change buffering? ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-restrictions.html
For InnoDB, all DML operations (INSERT, UPDATE, DELETE) involving columns with full-text indexes are processed at transaction commit time. For example, for an INSERT operation, an inserted string is tokenized and decomposed into individual words.
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-buffer-page-lru-table.html
The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, how they are ordered in the LRU list that determines which pages to evict from the buffer pool when it becomes full. The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-buffer-page-table.html
The INNODB_BUFFER_PAGE table provides information about each page in the InnoDB buffer pool. For related usage information and examples, see Section 17.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”. Do not query this table on a ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tables-table.html
Even if free space displays as 0, it may be possible to insert rows as long as new extents need not be allocated. Even with file-per-table mode with each InnoDB table in a separate .ibd file, change buffering can delay the write to the data file, so ...The information_schema_stats_expiry system variable defines the period of time before cached table statistics ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-triggers-table.html
The value is INSERT (a row was inserted), DELETE (a row was deleted), or UPDATE (a row was modified). To see information about a table's triggers, you must have the TRIGGER privilege for the table. The TRIGGERS table has these columns: ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-views-table.html
If a view is not updatable, statements such UPDATE, DELETE, and INSERT are illegal and are rejected. (Even if a view is updatable, it might not be possible to insert into it; for details, refer to Section 27.5.3, “Updatable and Insertable ...You ...
https://dev.mysql.com/doc/refman/8.4/en/innochecksum.html
This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged pages. It was originally developed to speed up verifying the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool.html
This midpoint insertion strategy treats the list as two sublists: At the head, a sublist of new (“young”) pages that were accessed recently At the tail, a sublist of old pages that were accessed less recently Figure 17.2 Buffer Pool List The ...