Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool.html
The buffer pool is an area in main memory where InnoDB caches table and index data as it is accessed. The larger the buffer pool, the more InnoDB acts like an in-memory database, reading data from disk once and then accessing the data from memory ...The buffer pool permits frequently used data to be accessed directly from memory, which speeds up ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-space-requirements.html
If the operation takes a long time and concurrent DML modifies the table so much that the size of the temporary log file exceeds the value of innodb_online_alter_log_max_size, the online DDL operation fails with a DB_ONLINE_LOG_TOO_BIG error, and ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-usage.html
Creating a Compressed Table in File-Per-Table Tablespace To create a compressed table in a file-per-table tablespace, innodb_file_per_table must be enabled (the default). The FILE_BLOCK_SIZE value must be a valid compressed page size in relation to ...The system tablespace (space 0, the .ibdata files) can contain user-created tables, but it also contains internal system data, which is never ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-cluster-metric-mysqlserver-innodbactivity-category.html
Lists the InnoDB Activity metrics and provides a brief description of each. Table 8.8 InnoDB Activity Metrics NameDescriptionTarget Name Name of the OEM Target Buffer Pool Pages Flushed (Delta) The number of buffer pool page-flush requests. Buffer ...Dblwr Pages Written (Delta) The number of pages that have been written for doublewrite ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tablespaces-table.html
The INNODB_TABLESPACES table provides metadata about InnoDB file-per-table, general, and undo tablespaces. Note The INFORMATION_SCHEMA FILES table reports metadata for InnoDB tablespace types including file-per-table tablespaces, general ...The ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-change-buffer.html
The type of data cached in the change buffer is governed by the innodb_change_buffering variable. You can set the innodb_change_buffering variable in the MySQL option file (my.cnf or my.ini) or change it dynamically with the SET GLOBAL statement, ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-preload-buffer-pool.html
By default, tablespace ID and page ID data is saved in a file named ib_buffer_pool, which is saved to the InnoDB data directory. Even though a buffer pool can be many gigabytes in size, the buffer pool data that InnoDB saves to disk is tiny by ...
https://dev.mysql.com/doc/internals/en/innodb-fil-header.html
The fields FIL_PAGE_FILE_FLUSH_LSN, FIL_PAGE_PREV, and FIL_PAGE_NEXT all have to do with logs, so I'll refer you to my article “How Logs Work With MySQL And InnoDB” on devarticles.com. FIL_PAGE_FILE_FLUSH_LSN and FIL_PAGE_ARCH_LOG_NO are valid ...This feature allows InnoDB to navigate from leaf to leaf without having to back up to the root ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-acid.html
MySQL includes components such as the InnoDB storage engine that adhere closely to the ACID model so that data is not corrupted and results are not distorted by exceptional conditions such as software crashes and hardware malfunctions. Consistency ... The ACID model is a set of database design principles that emphasize aspects of reliability that are important for business data and mission-critical ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking-reads.html
If you query data and then insert or update related data within the same transaction, the regular SELECT statement does not give enough protection. FOR SHARE, or from reading the data in certain transaction isolation levels. These clauses are ...