Search Results
https://dev.mysql.com/doc/refman/8.4/en/midpoint-insertion.html
By default, the key cache management system uses a simple LRU strategy for choosing key cache blocks to be evicted, but it also supports a more sophisticated method called the midpoint insertion strategy. When using the midpoint insertion strategy, ...key_cache_division_limit is a component of structured key cache variables, so its value is a parameter that can be set per ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-server-clients.html
On Unix, set the MYSQL_UNIX_PORT and MYSQL_TCP_PORT environment variables to point to the Unix socket file and TCP/IP port number before you start your clients. Start the client with --protocol=TCP to connect using TCP/IP, --protocol=SOCKET to ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-check.html
It does a check-read of every key for each row to verify that they indeed point to the correct row. To check a MyISAM table, use the following commands: myisamchk tbl_name This finds 99.99% of all errors. What it cannot find is corruption that ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-repair.html
If the data file contains everything that it should and the delete links point at the correct locations within the data file, this should work, and the table is fixed. The discussion in this section describes how to use myisamchk on MyISAM tables ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-table-close.html
When the last instance of a table is closed (because a FLUSH TABLES operation was performed or because there is no room in the table cache), the counter is decremented if the table has been updated at any point. Each MyISAM index file (.MYI file) ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-memory.html
If TMPDIR points to a memory file system, out of memory errors can easily occur. The following formula yields the amount of space required: (largest_key + row_pointer_length) * number_of_rows * 2 You can check the length of the keys and the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-config-starting.html
The following config.ini file is a recommended starting point for configuring a cluster running NDB Cluster 8.4: # TCP PARAMETERS [tcp default] SendBufferMemory=2M ReceiveBufferMemory=2M # Increasing the sizes of these 2 buffers beyond the default ...Changes in configuration are also likely to be indicated when changes are made in the platform on which the cluster is run, or in applications that use the NDB Cluster 's ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-connection-strings.html
With the exception of the NDB Cluster management server (ndb_mgmd), each node that is part of an NDB Cluster requires a connection string that points to the management server's location. This connection string is used in establishing a connection ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-disk-data-storage-requirements.html
Each row in a Disk Data table uses 8 bytes in memory to point to the data stored on disk. The following items apply to Disk Data storage requirements: Variable-length columns of Disk Data tables take up a fixed amount of space. For each row, this ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-cluster-operations.html
The cluster_operations table provides a per-operation (stateful primary key op) view of all activity in the NDB Cluster from the point of view of the local data management (LQH) blocks (see The DBLQH Block). (Currently, the MySQL Server does not ...