Search Results
https://dev.mysql.com/doc/refman/8.4/en/json-function-reference.html
Table 14.22 JSON Functions Name Description Deprecated -> Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT(). ->> Return value from JSON column after evaluating path and unquoting the result; equivalent to ...
https://dev.mysql.com/doc/refman/8.4/en/key-cache-restructuring.html
For example: mysql> SET GLOBAL cold_cache.key_buffer_size=4*1024*1024; If you assign to either the key_buffer_size or key_cache_block_size key cache component a value that differs from the component's current value, the server destroys the cache's ... A key cache can be restructured at any time by updating its parameter ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-key-caches.html
By default, table indexes are assigned to the main (default) key cache created at the server startup. Note As of MySQL 8.4, the compound-part structured-variable syntax discussed here for referring to multiple MyISAM key caches is deprecated.
https://dev.mysql.com/doc/refman/8.4/en/multiple-windows-services.html
On Windows, a MySQL server can run as a Windows service. The procedures for installing, controlling, and removing a single MySQL service are described in Section 2.3.3.8, “Starting MySQL as a Windows Service”. To set up multiple MySQL services, ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-crash-recovery.html
myisamchk works by creating a copy of the .MYD data file row by row. If you use --quick, myisamchk does not create a temporary .MYD file, but instead assumes that the .MYD file is correct and generates only a new index file without touching the .MYD ... This section describes how to check for and deal with data corruption in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-memory.html
This space is not needed if you do a repair with --quick; in this case, only the index file is re-created. This space must be available on the same file system as the original data file, as the copy is created in the same directory as the original.
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-other-options.html
If keys are packed (PACK_KEYS=1), myisamchk must unpack key blocks first, then re-create indexes and pack the key blocks again. (In this case, re-creating indexes is faster than updating offsets for each index.) . myisamchk supports the following ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-repair-options.html
--data-file-length=len, -D len Command-Line Format --data-file-length=len Type Numeric The maximum length of the data file (when re-creating data file when it is “full”). --tmpdir can be set to a list of directory paths that are used ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-backup.html
The next few sections describe how to prepare for and then to create an NDB Cluster backup using the functionality for this purpose found in the ndb_mgm management client. It is also possible to create backups using multiple LDMs to achieve ...To ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-data-node-memory-management.html
If an undo log buffer is created as part of a CREATE LOGFILE GROUP SQL statement, the memory is taken from the transaction memory. All memory allocation for a data node is performed when the node is started. This ensures that the data node can run ...