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-upgrade.html
While you are in the process of upgrading an online group, in order to maximize availability, you might need to have members with different MySQL Server versions running at the same time. The basic process of upgrading members of a group is the same ... This section explains how to upgrade a Group Replication ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-page-table.html
ACCESS_TIME An abstract number used to judge the first access time of the page. The INNODB_BUFFER_PAGE table provides information about each page in the InnoDB buffer pool. For related usage information and examples, see Section 17.15.5, “InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-analyze-table-complexity.html
Using these parameters, an approximate formula for estimating ANALYZE TABLE complexity would be: The value of innodb_stats_persistent_sample_pages * number of indexed columns in a table * the number of partitions Typically, the greater the resulting ... ANALYZE TABLE complexity for InnoDB tables is dependent on: The number of pages sampled, as defined by ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-compression-oltp.html
MySQL uses a variable amount of free space for the pages within each compressed table, only when a designated percentage of compression operations “fail” at runtime, requiring an expensive operation to split the compressed page. These ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-transaction-scheduling.html
Note Prior to MySQL 8.0.20, InnoDB also uses a First In First Out (FIFO) algorithm to schedule transactions, and the CATS algorithm is used under heavy lock contention only. CATS algorithm enhancements in MySQL 8.0.20 rendered the FIFO algorithm ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk.html
The most effective means of doing so is to shut down the MySQL server while running myisamchk, or to lock all tables that myisamchk is being used on. If mysqld is running, you must force it to flush any table modifications that are still buffered in ... The myisamchk utility gets information about your database tables or checks, repairs, or optimizes ...
https://dev.mysql.com/doc/refman/8.0/en/not-enough-file-handles.html
To tell mysqld to keep open fewer files at a time, you can make the table cache smaller by reducing the value of the table_open_cache system variable (the default value is 64). If you get ERROR 'file_name' not found (errno: 23), Can't open file: ...
https://dev.mysql.com/doc/refman/8.0/en/outer-join-optimization.html
MySQL implements an A LEFT JOIN B join_specification as follows: Table B is set to depend on table A and all tables on which A depends. Table A is set to depend on all tables (except B) that are used in the LEFT JOIN condition. The LEFT JOIN ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-data-lock-waits-table.html
Example data lock wait information: mysql> SELECT * FROM performance_schema.data_lock_waits\G *************************** 1. Use the data_lock_waits table to help diagnose performance problems that occur during times of heavy concurrent load. Note ... The data_lock_waits table implements a many-to-many relationship showing which data lock requests in the data_locks table are blocked by which held data locks in the data_locks ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-group-members-table.html
UNREACHABLE: The failure detection process suspects that this member cannot be contacted, because the group messages have timed out. MEMBER_COMMUNICATION_STACK The communication stack used for the group, either the XCOM communication stack or the ...