PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-requirements.html
Infrastructure Server Instance Configuration Server instances that you want to use for Group Replication must satisfy the following requirements. Transactions are executed optimistically and then, at commit time, are checked for conflicts. If there ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-restarting-group.html
Group Replication is designed to ensure that the database service is continuously available, even if some of the servers that form the group are currently unable to participate in it due to planned maintenance or unplanned issues. As long as the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-secure-user.html
State transfer from the binary log requires a replication user with the correct permissions so that Group Replication can establish direct member-to-member replication channels. The same replication user is used for distributed recovery on all the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cmp-per-index-table.html
The INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET tables provide status information on operations related to compressed InnoDB tables and indexes, with separate statistics for each combination of database, table, and index, to help you ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tablestats-table.html
The INNODB_TABLESTATS table provides a view of low-level status information about InnoDB tables. This data is used by the MySQL optimizer to calculate which index to use when querying an InnoDB table. This information is derived from in-memory data ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-optimization.html
Applications that monitor databases may make frequent use of INFORMATION_SCHEMA tables. To write queries for these tables most efficiently, use the following general guidelines: Try to query only INFORMATION_SCHEMA tables that are views on data ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-partitions-table.html
Each row in this table corresponds to an individual partition or subpartition of a partitioned table. The PARTITIONS table has these columns: TABLE_CATALOG The name of the catalog to which the table belongs. TABLE_SCHEMA The name of the schema ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-processlist-table.html
Important INFORMATION_SCHEMA.PROCESSLIST is deprecated and subject to removal in a future MySQL release. As such, the implementation of SHOW PROCESSLIST which uses this table is also deprecated. It is recommended to use the Performance Schema ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-change-buffer.html
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 changes, which may result from INSERT, UPDATE, or DELETE operations (DML), are merged later when ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-tuning-monitoring.html
Overall application performance, CPU and I/O utilization and the size of disk files are good indicators of how effective compression is for your application. This section builds on the performance tuning advice from Section 17.9.1.3, “Tuning ...