Search Results
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-optimization-tips.html
This section lists a number of miscellaneous tips for improving query processing speed: If your application makes several database requests to perform related updates, combining the statements into a stored routine can help performance. Similarly, ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-unix-servers.html
Note The discussion here uses mysqld_safe to launch multiple instances of MySQL. For MySQL installation using an RPM distribution, server startup and shutdown is managed by systemd on several Linux platforms. On these platforms, mysqld_safe is not ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-general-options.html
MySQL release binaries provided by Oracle are not built using this option. The options described in this section can be used for any type of table maintenance operation performed by myisamchk. The sections following this one describe options that ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-repair-options.html
--correct-checksum Command-Line Format --correct-checksum Correct the checksum information for the table. --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 ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-added-deprecated-removed.html
Parameters Introduced in NDB 8.4 The following node configuration parameters have been added in NDB 8.4. RequireCertificate: Node is required to find key and certificate in TLS search path. RequireLinkTls: Read-only; is set to true if either ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-windows-initial-start.html
On the computer designated as the SQL node host, open a console window and navigate to the directory where you unpacked the NDB Cluster binaries (if you are following our example, this is C:\mysql\bin). Once the NDB Cluster executables and needed ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-interconnects.html
This required specialized hardware, software, and MySQL binaries that are no longer available. Even before design of NDBCLUSTER began in 1996, it was evident that one of the major problems to be encountered in building parallel databases would be ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-unsupported.html
A number of features supported by other storage engines are not supported for NDB tables. Trying to use any of these features in NDB Cluster does not cause errors in or of itself; however, errors may occur in applications that expects the features ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-logs-event-buffer.html
NDB uses one or more memory buffers for events received from the data nodes. There is one such buffer for each Ndb object subscribing to table events, which means that there are usually two buffers for each mysqld performing binary logging (one ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-transporters.html
Notes For each running data node in the cluster, the transporters table displays a row showing the status of each of that node's connections with all nodes in the cluster, including itself. This information is shown in the table's status column, ...