Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-per-table-tablespaces.html
Tables stored in individual tablespace data files can save time and improve chances for a successful recovery when data corruption occurs, when backups or binary logs are unavailable, or when the MySQL server instance cannot be restarted. A ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-redo-log-buffer.html
Thus, if you have transactions that update, insert, or delete many rows, increasing the size of the log buffer saves disk I/O. The log buffer is the memory area that holds data to be written to the log files on disk. The contents of the log buffer ...
https://dev.mysql.com/doc/refman/8.4/en/large-page-support.html
As system root, open the file /etc/sysctl.conf in a text editor, and add the line shown here, where P is the number of large pages obtained in the previous step: vm.nr_hugepages=P Using the actual value obtained previously, the additional line ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-apt-repo.html
This section provides guidance on installing MySQL using the MySQL APT repository. First, add the MySQL APT repository to your system's software repository list. Follow these steps: Go to the download page for the MySQL APT repository at ...
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-notes.html
Removing: After you have copied over the MySQL database files from the previous installation and have successfully started the new server, you should consider removing the old installation files to save disk space. You should keep the following ...
https://dev.mysql.com/doc/refman/8.4/en/memory-use.html
Handler structures for all in-use tables are saved in the table cache and managed as “First In, First Out” (FIFO). MySQL allocates buffers and caches to improve performance of database operations. The default configuration is designed to permit ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-table-info.html
To obtain a description of a MyISAM table or statistics about it, use the commands shown here. The output from these commands is explained later in this section. myisamchk -d tbl_name Runs myisamchk in “describe mode” to produce a description ...
https://dev.mysql.com/doc/refman/8.4/en/myisampack.html
After join The number of distinct Huffman trees left after joining trees to save some header space. When the table is used later, the server reads into memory the information needed to decompress columns. This results in much better performance when ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-basics.html
Generally speaking, when data is saved to disk, it is said that a checkpoint has been reached. NDBCLUSTER (also known as NDB) is an in-memory storage engine offering high-availability and data-persistence features. The NDBCLUSTER storage engine can ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-config-send-buffers.html
This is a way to save memory when many nodes are in use, as long as the maximum amount of memory is never required by all transporters at the same time. The NDB kernel employs a unified send buffer whose memory is allocated dynamically from a pool ...