Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-table-reference.html
The following table summarizes INFORMATION_SCHEMA InnoDB tables. For greater detail, see the individual table descriptions. Table 28.3 INFORMATION_SCHEMA InnoDB Tables Table Name Description INNODB_BUFFER_PAGE Pages in InnoDB buffer pool ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-monitor-types.html
There are two types of InnoDB monitor: The standard InnoDB Monitor displays the following types of information: Work done by the main background thread Semaphore waits Data about the most recent foreign key and deadlock errors Lock waits for ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-dedicated-server.html
When the server is started with --innodb-dedicated-server, InnoDB automatically calculates values for and sets the following system variables: innodb_buffer_pool_size innodb_redo_log_capacity Note innodb_redo_log_capacity supersedes both ...You ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-restrictions-limitations.html
mysql> CREATE TABLE t1 (c1 INT, db_row_id INT) ENGINE=INNODB; ERROR 1166 (42000): Incorrect column name 'db_row_id' SHOW TABLE STATUS does not provide accurate statistics for InnoDB tables except for the physical size reserved by the table. A MySQL ... This section describes restrictions and limitations of the InnoDB storage ...For ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-queries.html
Follow these guidelines for InnoDB indexes: Because each InnoDB table has a primary key (whether you request one or not), specify a set of primary key columns for each table, columns that are used in the most important and time-critical queries. To ...Do not create a separate secondary index for each column, because each query can only make use of one ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression.html
Using the compression features of InnoDB, you can create tables where the data is stored in compressed form. This section provides information about the InnoDB table compression and InnoDB page compression features. The compression means less data ...The page compression feature is also referred to as transparent page ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-multiple_io_threads.html
On Linux systems, InnoDB uses the asynchronous I/O subsystem by default to perform read-ahead and write requests for data file pages, which changes the way that InnoDB background threads service these types of I/O requests. You can configure the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-benchmarking.html
If InnoDB is not the default storage engine, you can determine if your database server and applications work correctly with InnoDB by restarting the server with --default-storage-engine=InnoDB defined on the command line or with ...Since changing ...Alternatively, to run test queries and other statements without disturbing the original table, make a copy: CREATE TABLE ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-innodb-adaptivehashactivity-category.html
Lists the InnoDB Adaptive Hash Activity metrics and provides a brief description of each. Table 6.10 InnoDB Adaptive Hash Activity Metrics NameDescriptionHash Node Heap The total number of (16Kb) pages allocated to the InnoDB adaptive hash index.
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-innodb-rowactivity-category.html
Lists the InnoDB Row Activity metrics and provides a brief description of each. Table 6.15 InnoDB Row Activity Metrics NameDescriptionRow Queries Inside The number of queries executing inside InnoDB. Row Queries Queue The number of queries in the ...