Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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.6.3, “Updatable and Insertable ...You ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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 ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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 ...