Search Results
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/nonpersistible-system-variables.html
To use X.509, clients must specify the --ssl-key and --ssl-cert options to connect. SET PERSIST and SET PERSIST_ONLY enable global system variables to be persisted to the mysqld-auto.cnf option file in the data directory (see Section 15.7.6.1, ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-issues.html
To use it, just add the keyword EXPLAIN to the front of your SELECT statement: mysql> EXPLAIN SELECT * FROM t1, t2 WHERE t1.i = t2.i; EXPLAIN is discussed in more detail in Section 15.8.2, “EXPLAIN Statement”. Use ANALYZE TABLE tbl_name to ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-myisam-bulk-data-loading.html
Use myisamchk --keys-used=0 -rq /path/to/db/tbl_name to remove all use of indexes for the table. To increase performance for MyISAM tables, for both LOAD DATA and INSERT, enlarge the key cache by increasing the key_buffer_size system variable.
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-exchange.html
Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. The IGNORE keyword has no effect when used with ALTER TABLE ... There are no rows in nt that lie outside the boundaries of the partition ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-pruning.html
An INSERT statement also accesses only one partition per inserted row; this is true even for a table that is partitioned by HASH or KEY although this is not currently shown in the output of EXPLAIN. For tables that are partitioned by HASH or ... The ...
https://dev.mysql.com/doc/refman/8.4/en/persisted-system-variables.html
Syntax for Persisting System Variables These SET syntax options are available for persisting system variables: To persist a global system variable to the mysqld-auto.cnf option file in the data directory, precede the variable name by the PERSIST ...
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
REFERENCES Creation of a foreign key constraint requires the REFERENCES privilege for the parent table. The related system variable binlog_rotate_encryption_master_key_at_startup, which rotates the binary log master key automatically when the server ... The privileges granted to a MySQL account determine which operations the account can ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-mcmd.html
ssl_cert Type File name Default Value NULL The path name of the SSL public key certificate file in PEM format. ssl_key Type File name Default Value NULL The path name of the server SSL private key file in PEM format. For better security, use a ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-32.html
(Bug #108814, Bug #34717205) When Connector/J looked for the presence of the ON DUPLICATE KEY UPDATE clause in prepared statements, it neglected the cases where the VALUES function was used without the VALUE(S) clause in INSERT statements. As a ...