PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/federated-description.html
To read a result set, it uses mysql_store_result() and fetches rows one at a time using mysql_fetch_row(). A FEDERATED table consists of two elements: A remote server with a database table, which in turn consists of the table definition (stored in ... When you create a table using one of the standard storage engines (such as MyISAM, CSV or InnoDB), the table consists of the table definition and the associated ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-message-compression.html
From MySQL 8.0.18, you can also configure compression for messages sent for distributed recovery by the method of state transfer from a donor's binary log. Binary log transaction compression (available as of MySQL 8.0.20), which is activated by the ... For messages sent between online group members, Group Replication enables message compression by ...
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 ...