Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-read-only-instance.html
To enable read-only mode for an entire MySQL instance, specify the following configuration options at server startup: --innodb-read-only=1 If the instance is on read-only media such as a DVD or CD, or the /var directory is not writeable by all: ...
https://dev.mysql.com/doc/refman/8.4/en/monitor-innodb-mutex-waits-performance-schema.html
To ensure that all InnoDB mutex instances are instrumented and enabled, add the following performance-schema-instrument rule to your MySQL configuration file: performance-schema-instrument='wait/synch/mutex/innodb/%=ON' If you do not require wait ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-migration.html
Techniques for moving or copying InnoDB tables include: Importing Tables MySQL Enterprise Backup Copying Data Files (Cold Backup Method) Restoring from a Logical Backup Importing Tables A table that resides in a file-per-table tablespace can be ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-buffer-pool-tables.html
The InnoDB INFORMATION_SCHEMA buffer pool tables provide buffer pool status information and metadata about the pages within the InnoDB buffer pool. Example 17.6 Querying System Data in the INNODB_BUFFER_PAGE Table This query provides an approximate ...The InnoDB INFORMATION_SCHEMA buffer pool tables include those listed below: mysql> SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB_BUFFER%'; +-----------------------------------------------+ | Tables_in_INFORMATION_SCHEMA (INNODB_BUFFER%) | +-----------------------------------------------+ | INNODB_BUFFER_PAGE_LRU | | INNODB_BUFFER_PAGE | | INNODB_BUFFER_POOL_STATS | +-----------------------------------------------+ Table Overview INNODB_BUFFER_PAGE: Holds information about each page in the InnoDB buffer ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-innodb-logactivity-category.html
Pages Flushed Lsn The redo log sequence number within InnoDB, up to which the buffer pool has been flushed to the data files. Table 6.14 InnoDB Log Activity Metrics NameDescriptionCheckpoint File The low order 32bit value for the redo log sequence ... Lists the InnoDB Log Activity metrics and provides a brief description of ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-fulltext-index.html
mysql> SELECT index_id, name, table_id, space from INFORMATION_SCHEMA.INNODB_INDEXES WHERE index_id=457; +----------+------+----------+-------+ | index_id | name | table_id | space | +----------+------+----------+-------+ | 457 | idx | 327 | 283 | ...By default, two threads tokenize, sort, and insert words and associated data into the index ... Full-text indexes are created on text-based columns (CHAR, ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-page-compression.html
For example, if innodb_page_size=16K and the file system block size is 4K, page data must compress to less than or equal to 12K to make hole punching possible. Therefore, page compression only works if page data can be compressed to a size that is ...For example, for page compression to work on Windows, you could build the file system with a cluster size of 512 Bytes (which has a compression unit of 8KB) and initialize InnoDB with an innodb_page_size value of 16K or ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-benefits.html
InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware or software issue, regardless of what was happening in the database at the time, you don't need to do anything special after restarting the database.
https://dev.mysql.com/doc/internals/en/innodb-mutex-rwlock-implementation.html
When MySQL starts, InnoDB writes a message to the log file indicating whether atomic memory access is used for mutexes, for mutexes and read/write locks, or neither. In MySQL and InnoDB, multiple threads of execution access shared data structures.
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-innodb-ioactivity-category.html
Os File Fsyncs (Delta) The total number of fsync() operations performed by InnoDB. Os File Reads (Delta) The total number of files reads performed by read threads within InnoDB. Os File Writes (Delta) The total number of file writes performed by ...