Search Results
https://dev.mysql.com/doc/refman/9.7/en/information-schema-partitions-table.html
For partitioned InnoDB tables, the row count given in the TABLE_ROWS column is only an estimated value used in SQL optimization, and may not always be exact. Each row in this table corresponds to an individual partition or subpartition of a ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 28.1 INFORMATION_SCHEMA Tables Table Name Description Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-buffer-pool.html
For information about optimizing this behavior, see Section 17.8.3.3, “Making the Buffer Pool Scan Resistant”, and Section 17.8.3.4, “Configuring InnoDB Buffer Pool Prefetching (Read-Ahead)”. The buffer pool is an area in main memory where ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-change-buffer.html
Test different settings with a representative workload to determine an optimal configuration. The change buffer is a special data structure that caches changes to secondary index pages when those pages are not in the buffer pool. The buffered ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-create-table-external.html
Those reasons might include space management, I/O optimization, or placing tables on a storage device with particular performance or capacity characteristics, for example. There are different reasons for creating InnoDB tables externally; that is, ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-file-per-table-tablespaces.html
File-per-table tablespace data files can be created on separate storage devices for I/O optimization, space management, or backup purposes. A file-per-table tablespace contains data and indexes for a single InnoDB table, and is stored on the file ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-system-tables.html
The data in this table is used by the MySQL optimizer to calculate which index to use when querying an InnoDB table. You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA tables. Traditionally, you would ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-temp-table-info.html
It does not provide information about internal InnoDB temporary tables used by the optimizer. INNODB_TEMP_TABLE_INFO provides information about user-created InnoDB temporary tables that are active in the InnoDB instance. mysql> SHOW TABLES FROM ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-init-startup-configuration.html
The first decisions to make about InnoDB configuration involve the configuration of data files, log files, page size, and memory buffers, which should be configured before initializing InnoDB. Modifying the configuration after InnoDB is initialized ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-introduction.html
InnoDB tables arrange your data on disk to optimize queries based on primary keys. InnoDB is a general-purpose storage engine that balances high reliability and high performance. Unless you have configured a different default storage engine, ...