Search Results
https://dev.mysql.com/doc/refman/8.4/en/innochecksum.html
Because --allow-mismatches is set to 1, the checksum tolerates the first mismatch and terminates on the second mismatch, leaving page 600 and pages 700-999 unchanged. This tool reads an InnoDB tablespace file, calculates the checksum for each page, ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-autocommit-commit-rollback.html
To leave autocommit on, begin each transaction with START TRANSACTION and end it with COMMIT or ROLLBACK. If autocommit mode is enabled, each SQL statement forms a single transaction on its own. By default, MySQL starts the session for each new ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool.html
Ideally, you set the size of the buffer pool to as large a value as practical, leaving enough memory for other processes on the server to run without excessive paging. The buffer pool is an area in main memory where InnoDB caches table and index ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-internals.html
To make room for other required database pages, MySQL can evict from the buffer pool an uncompressed page, while leaving the compressed page in memory. This section describes some internal implementation details about compression for InnoDB tables.
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlocks-handling.html
In particular, do not leave an interactive mysql session open for a long time with an uncommitted transaction. This section builds on the conceptual information about deadlocks in Section 17.7.5.2, “Deadlock Detection”. It explains how to ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-fulltext-index.html
If you are not concerned with CREATE FULLTEXT INDEX performance, leave out the FTS_DOC_ID column to have InnoDB create it for you. Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-compression-oltp.html
Traditionally, the InnoDB compression feature was recommended primarily for read-only or read-mostly workloads, such as in a data warehouse configuration. The rise of SSD storage devices, which are fast but relatively small and expensive, makes ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-midpoint_insertion.html
When scanning small tables that do fit into memory, there is less overhead for moving pages around within the buffer pool, so you can leave innodb_old_blocks_pct at its default value, or even higher, such as innodb_old_blocks_pct=50. Rather than ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-statistics-estimation.html
Whatever value of innodb_stats_transient_sample_pages works best for a system, set the option and leave it at that value. Optimizer statistics are not persisted to disk when innodb_stats_persistent=OFF or when individual tables are created or ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-table-import.html
This section describes how to import tables using the Transportable Tablespaces feature, which permits importing tables, partitioned tables, or individual table partitions that reside in file-per-table tablespaces. There are many reasons why you ...