Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-midpoint_insertion.html
Rather than using a strict LRU algorithm, InnoDB uses a technique to minimize the amount of data that is brought into the buffer pool and never accessed again. For an explanation of the inner workings of the InnoDB buffer pool and specifics about ...The goal is to make sure that frequently accessed (“hot”) pages remain in the buffer pool, even as read-ahead and full table scans bring in new blocks that might or might not be accessed ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-scheduling.html
InnoDB uses the Contention-Aware Transaction Scheduling (CATS) algorithm to prioritize transactions that are waiting for locks. When multiple transactions are waiting for a lock on the same object, the CATS algorithm determines which transaction ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node-basics.html
ALGORITHM=INPLACE, REORGANIZE PARTITION statement in the mysql client for each NDBCLUSTER table. REORGANIZE PARTITION ALGORITHM=INPLACE reorganizes partitions but does not reclaim the space freed on the “old” nodes. In this section, we list the ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-configuration-variables.html
Controlling the algorithm that determines when InnoDB performs certain types of background writes. The algorithm works for some types of workloads but not others, so you might disable this feature if you observe periodic drops in performance. In ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-range-list.html
You can see that this is the case by re-running the previous SELECT query: mysql> SELECT * FROM tr WHERE purchased -> BETWEEN '1995-01-01' AND '1999-12-31'; Empty set (0.00 sec) Note DROP PARTITION is supported by native partitioning in-place APIs ... Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-binary-log-transaction-compression-stats-table.html
Compressed transactions are grouped by the compression algorithm used, and uncompressed transactions are grouped together with the compression algorithm stated as NONE, so the compression ratio can be calculated. This table shows statistical ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-convenience-functions.html
mysql> SET @pt1 = ST_GeomFromText('POINT(0 0)'); mysql> SET @pt2 = ST_GeomFromText('POINT(1 1)'); mysql> SELECT ST_AsText(ST_MakeEnvelope(@pt1, @pt2)); +----------------------------------------+ | ST_AsText(ST_MakeEnvelope(@pt1, @pt2)) | ... The ...
https://dev.mysql.com/doc/refman/8.4/en/switchable-optimizations.html
The following list describes the permissible opt_name flag names, grouped by optimization strategy: Batched Key Access Flags batched_key_access (default off) Controls use of BKA join algorithm. The derived_merge flag controls whether the optimizer ...Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-operation.html
The thread pool exposes system variables that may be used to configure its operation: thread_pool_algorithm: The concurrency algorithm to use for scheduling. If thread_pool_max_active_query_threads is 0, the default algorithm applies as just ... The ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/connection-options.html
If none of the algorithms specified by --compression-algorithms are permitted by the server, connection to the server will not be established. --login-path=name --port=port-num --protocol={tcp|socket|pipe|memory} --pipe (alias for --protocol=pipe) ... When mysqlbackup creates a backup, it sends SQL commands to a MySQL server using a database server ...