Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-configuring-io-capacity.html
You can set the innodb_io_capacity value in the MySQL option file (my.cnf or my.ini) or modify it at runtime using a SET GLOBAL statement, which requires privileges sufficient to set global system variables. You can set the innodb_flush_sync value ... The InnoDB master thread and other threads perform various tasks in the background, most of which are I/O related, such as flushing dirty pages from the buffer pool and writing changes from the change buffer to the appropriate secondary ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locks-set.html
InnoDB has to set locks in the latter case: During roll-forward recovery using a statement-based binary log, every SQL statement must be executed in exactly the same way it was done originally. InnoDB does not remember the exact WHERE condition, but ... A locking read, an UPDATE, or a DELETE generally set record locks on every index record that is scanned in the processing of an SQL ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-innodb-replicaset-introduction.html
An InnoDB ReplicaSet consists of at least two MySQL Server instances, and it provides all of the MySQL Replication features you are familiar with, such as read scale-out and data security. InnoDB ReplicaSet uses the following MySQL technologies: ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-checkpoints.html
Then InnoDB scans the log files forward from the checkpoint, applying the logged modifications to the database. InnoDB flushes modified database pages from the buffer pool in small batches. During crash recovery, InnoDB looks for a checkpoint label ...It often makes sense to set the total size of the log files as large as the buffer pool or even ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-temp-table-info.html
Create a simple InnoDB temporary table: mysql> CREATE TEMPORARY TABLE t1 (c1 INT PRIMARY KEY) ENGINE=INNODB; Query INNODB_TEMP_TABLE_INFO to view the temporary table metadata. mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_TEMP_TABLE_INFO\G An empty ... INNODB_TEMP_TABLE_INFO provides information about user-created InnoDB temporary tables that are active in the InnoDB ...row ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-ddl-operations.html
Online DDL support for adding secondary indexes means that you can generally speed up the process of creating and loading a table and associated indexes by creating the table without secondary indexes, then adding secondary indexes after the data is ... Many DDL operations on tables and indexes (CREATE, ALTER, and DROP statements) can be performed ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-optimizer-statistics.html
You can query optimizer statistics data in the mysql.innodb_table_stats and mysql.innodb_index_stats tables. You can manually modify the mysql.innodb_table_stats and mysql.innodb_index_stats tables to force a specific query optimization plan or to ...Persistent optimizer statistics also provide control and flexibility with these additional benefits: You can use the innodb_stats_auto_recalc configuration option to control whether statistics are updated automatically after substantial changes to a ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-many-tables.html
If you have configured non-persistent optimizer statistics (a non-default configuration), InnoDB computes index cardinality values for a table the first time that table is accessed after startup, instead of storing such values in the table. This ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-innodb-cluster-introduction.html
InnoDB Cluster uses the following MySQL technologies: MySQL Shell, which is an advanced client and code editor for MySQL. The following diagram shows an overview of how these technologies work together: Figure 23.1 InnoDB Cluster overview Being ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-read_ahead.html
InnoDB uses two read-ahead algorithms to improve I/O performance: Linear read-ahead is a technique that predicts what pages might be needed soon based on pages in the buffer pool being accessed sequentially. You control when InnoDB performs a ... A ...