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/innodb-performance-midpoint_insertion.html
Both innodb_old_blocks_pct and innodb_old_blocks_time can be specified in the MySQL option file (my.cnf or my.ini) or changed at runtime with the SET GLOBAL statement. Rather than using a strict LRU algorithm, InnoDB uses a technique to minimize ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-persistent-stats.html
As a result, there are four n_diff% rows instead of two to account for the both the secondary index columns (c,d) and the primary key columns (a,b). The persistent optimizer statistics feature improves plan stability by storing statistics to disk ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-physical-structure.html
With the exception of spatial indexes, InnoDB indexes are B-tree data structures. Spatial indexes use R-trees, which are specialized data structures for indexing multi-dimensional data. Index records are stored in the leaf pages of their B-tree or ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-recovery.html
During recovery, InnoDB reads corruption flags from both locations and merges results before marking in-memory table and index objects as corrupt. To achieve point-in-time recovery after restoring a backup, you can apply changes from the binary log ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-redo-log.html
Modifying redo log capacity requires changing the number or the size of redo log files, or both. The redo log is a disk-based data structure used during crash recovery to correct data written by incomplete transactions. During normal operations, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-row-format.html
Table data and secondary indexes both use this type of structure. The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML operations. As more rows fit into a single disk ...
https://dev.mysql.com/doc/refman/8.0/en/internal-temporary-tables.html
In some cases, the server creates internal temporary tables while processing statements. The server creates temporary tables under conditions such as these: Evaluation of UNION statements, with some exceptions described later. Evaluation of some ...
https://dev.mysql.com/doc/refman/8.0/en/ipv6-remote-connections.html
For example, put the following lines in the server option file and restart the server: [mysqld] bind_address = * Specifying * (or ::) as the value for bind_address permits both IPv4 and IPv6 connections on all server host IPv4 and IPv6 interfaces.
https://dev.mysql.com/doc/refman/8.0/en/ipv6-server-config.html
A value of *, which is the default, or a value of ::, permit both IPv4 and IPv6 connections on all server host IPv4 and IPv6 interfaces. The MySQL server listens on one or more network sockets for TCP/IP connections. Each socket is bound to one ...
https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html
If both arguments are scalars, the function performs a simple equality test. The functions in this section perform search or comparison operations on JSON values to extract data from them, report whether data exists at a location within them, or ...