Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-certificates.html
The certificates table contains the following columns: Node_id ID of the node where this certificate is found Name Certificate name Expires Expiration date, in mm-nnn-yyyy format (for example, 18-Dec-2023). The certificates table provides ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndbd.html
In a multi-processor system performing a large number of operations (including updates), the ndbd process can consume up to 2 CPUs if permitted to do so. The ndbd binary provides the single-threaded version of the process that is used to handle all ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-what-is-new.html
Previously, when SQL nodes performing binary logging used log_replica_updates=OFF, any replicated updates which were applied on a replica NDB cluster were sent on to the SQL nodes performing binary logging. These updates were not actually applied or ... What is New in NDB Cluster 8.4 Changes in NDB 8.x Innovation Releases The following sections describe changes in the implementation of MySQL NDB Cluster in NDB Cluster 8.0 through 8.0.44, as compared to earlier release ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-commands.html
If you are running with --safe-updates enabled, status also prints the values for the mysql variables that affect your queries. mysql sends each SQL statement that you issue to the server to be executed. There is also a set of commands that mysql ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-tips.html
Input-Line Editing Disabling Interactive History Unicode Support on Windows Displaying Query Results Vertically Using Safe-Updates Mode (--safe-updates) Disabling mysql Auto-Reconnect mysql Client Parser Versus Server Parser Input-Line Editing mysql ... This section provides information about techniques for more effective use of mysql and about mysql operational ...
https://dev.mysql.com/doc/refman/8.4/en/mysqld-safe.html
mysqld_safe tries to use the sleep and date system utilities to determine how many times per second it has attempted to start. mysqld_safe is the recommended way to start a mysqld server on Unix. mysqld_safe adds some safety features such as ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-character.html
When you use a randomly generated value as a primary key in an InnoDB table, prefix it with an ascending value such as the current date and time if possible. For character and string columns, follow these guidelines: Use binary collation order for ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-table.html
Use OPTIMIZE TABLE in these cases, depending on the type of table: After doing substantial insert, update, or delete operations on an InnoDB table that has its own .ibd file because it was created with the innodb_file_per_table option enabled. After ...OPTIMIZE TABLE reorganizes the physical storage of table data and associated index data, to reduce storage space and improve I/O efficiency when accessing the ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-handling-nulls.html
Partitioning in MySQL does nothing to disallow NULL as the value of a partitioning expression, whether it is a column value or the value of a user-supplied expression. Even though it is permitted to use NULL as the value of an expression that must ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-key.html
Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined expression, the hashing function for key partitioning is supplied by the MySQL server. NDB Cluster uses MD5() for this purpose; for ...