Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-fulltext_index-tables.html
Before querying any of them, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains the FULLTEXT index (for example, test/articles). Example 17.5 InnoDB FULLTEXT Index ...For ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-configuration-variables.html
Because the InnoDB storage engine performs many of its optimizations automatically, many performance-tuning tasks involve monitoring to ensure that the database is performing well, and changing configuration options when performance drops. The main ...Turning the adaptive hash indexing feature on and off using the innodb_adaptive_hash_index ... Different settings work best for servers with light, predictable loads, versus ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-innodb-insertbufferactivity-category.html
Delete Merges (Delta) The total number of times the InnoDB secondary index delete buffer was merged to the InnoDB datafiles. Inserts Discarded (Delta) The total number of insert merged operations discarded Merged Recs (Delta) The total number of ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-encrypted-innodb-options.html
For details on how MySQL Server encrypts and decrypts these items, see InnoDB Data-at-Rest Encryption and Encrypting Binary Log Files and Relay Log Files . The same password supplied during backup must be supplied again during a ...The following is ...See Chapter 6, Working with Encrypted InnoDB Tablespaces and Section 8.4, “Working with Encrypted Binary and Relay Logs” on how mysqlbackup commands handle these encrypted ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndb-innodb-engines.html
The NDB storage engine is implemented using a distributed, shared-nothing architecture, which causes it to behave differently from InnoDB in a number of ways. For those unaccustomed to working with NDB, unexpected behaviors can arise due to its ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-ro-txn.html
In this case, attempting to make changes to the database (for InnoDB, MyISAM, or other types of tables) causes an error, and the transaction continues in read-only state: ERROR 1792 (25006): Cannot execute statement in a READ ONLY transaction. Note ... InnoDB can avoid the overhead associated with setting up the transaction ID (TRX_ID field) for transactions that are known to be ...You can still make changes to session-specific temporary tables ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-innodb-change-buffer.html
The innodb_io_capacity parameter sets an upper limit on the I/O activity performed by InnoDB background tasks such as merging data from the change buffer. When should the change buffer not be used? You might consider disabling the change buffer if ...How much space does InnoDB use for the change buffer? ...How do ...What types of ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool-resize.html
Command line: $> mysqld --innodb-buffer-pool-chunk-size=134217728 Configuration file: [mysqld] innodb_buffer_pool_chunk_size=134217728 The following conditions apply when altering innodb_buffer_pool_chunk_size: If the new ... You can configure ...A ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-physical-structure.html
With the exception of spatial indexes, InnoDB indexes are B-tree data structures. Index records are stored in the leaf pages of their B-tree or R-tree data structure. The page size is determined by the innodb_page_size setting when the MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-examples.html
The tables that contain information about InnoDB transactions and data locks enable you to determine which transaction is waiting for another, and which resource is being requested. You can see the underlying data in the INFORMATION_SCHEMA ... This ...Identifying Blocking Transactions It is sometimes helpful to identify which transaction blocks ...As you can see: Session B (trx id ...