PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-innodb_cmpmem.html
The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables provide status information about compressed pages that reside in the buffer pool. Please consult Section 14.9, “InnoDB Table and Page Compression” for further information on compressed tables and ...Each row of the two tables described here corresponds to a single page ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-multiple-buffer-pools.html
Multiple buffer pool instances are configured using the innodb_buffer_pool_instances configuration option, and you might also adjust the innodb_buffer_pool_size value. When the InnoDB buffer pool is large, many data requests can be satisfied by ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-limitations.html
This is similar to the idea of a foreign key constraint check in InnoDB in which constraints must hold during a transaction. OPTIMIZE TABLE for an InnoDB table is mapped to an ALTER TABLE operation to rebuild the table and update index statistics ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-performance.html
Session 1: mysql> CREATE TABLE t1 (c1 INT) ENGINE=InnoDB; mysql> START TRANSACTION; mysql> SELECT * FROM t1; The session 1 SELECT statement takes a shared metadata lock on table t1. Note For a greater understanding of the MySQL processing associated ... Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in ...
https://dev.mysql.com/doc/refman/5.7/en/index-statistics.html
For InnoDB and MyISAM tables, you have some control over collection of table statistics by means of the innodb_stats_method and myisam_stats_method system variables, respectively. The innodb_stats_method system variable has a global value; the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-identifying.html
If you enable a different file format using the innodb_file_format configuration option, the change only applies to newly created tables. For example: mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME='test/t1'\G ...Also, when ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-innodb_cmp.html
The INNODB_CMP and INNODB_CMP_RESET tables provide status information about operations related to compressed tables, which are described in Section 14.9, “InnoDB Table and Page Compression”. These two tables have identical contents, but reading ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-spin_lock_polling.html
InnoDB mutexes and rw-locks are typically reserved for short intervals. InnoDB minimizes this issue by forcing a random delay between polls to desychronize polling activity. That number is generated by randomly selecting an integer ranging from 0 ...On a multi-core system, it can be more efficient for a thread to continuously check if it can acquire a mutex or rw-lock for a period of time before it ...
https://dev.mysql.com/doc/refman/5.7/en/sys-innodb-buffer-stats-by-schema.html
These views summarize the information in the INFORMATION_SCHEMA INNODB_BUFFER_PAGE table, grouped by schema. Warning Querying views that access the INNODB_BUFFER_PAGE table can affect performance. The innodb_buffer_stats_by_schema and ...Do not ...
https://dev.mysql.com/doc/refman/5.7/en/sys-innodb-buffer-stats-by-table.html
These views summarize the information in the INFORMATION_SCHEMA INNODB_BUFFER_PAGE table, grouped by schema and table. Warning Querying views that access the INNODB_BUFFER_PAGE table can affect performance. The innodb_buffer_stats_by_table and ...