Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-compression-oltp.html
Because working with compressed data sometimes involves keeping both compressed and uncompressed versions of a page in memory at the same time, when using compression with an OLTP-style workload, be prepared to increase the value of the ...
https://dev.mysql.com/doc/refman/8.4/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.4/en/innodb-performance-multiple_io_threads.html
InnoDB uses background threads to service various types of I/O requests. You can configure the number of background threads that service read and write I/O on data pages using the innodb_read_io_threads and innodb_write_io_threads configuration ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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.4/en/installing.html
macOS For installation on macOS, including using both the binary package and native PKG formats, see Section 2.4, “Installing MySQL on macOS”. A summary of the procedure follows and later sections provide the details. If you plan to upgrade an ...
https://dev.mysql.com/doc/refman/8.4/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.4/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 ...