Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-what-is-new.html
NDB implements a new tool ndb_sign_keys which can be used to create and manage CA, certificate files, and keys. You can generate a set of keys and certificates for all nodes in a cluster with a given configuration file using ndb_sign_keys ... What ...
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. By ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-optimization.html
To see whether a given Performance Schema table has indexes and what they are, use SHOW INDEX or SHOW CREATE TABLE: mysql> SHOW INDEX FROM performance_schema.accounts\G *************************** 1. row *************************** Table: accounts ... Applications that monitor databases may make frequent use of Performance Schema ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-configuration-commands.html
(Neither type of attribute has a default value other than what is set for it when the cluster is created.) A mandatory attribute can be changed at any time by the user; a read-only attribute cannot be changed once the cluster has been created. A ...
https://dev.mysql.com/doc/ndb-operator/8.4/en/crd-ndbmysqldspec.html
If unspecified, a secret is created by the operator with a generated name in the format ndb_resource_name-mysqld-root-password. rootHost (string): (optional) Names the host or hosts from which the root user can connect to the MySQL server. If ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-update-vector-store.html
To test the steps in this topic, download and place the MySQL AI user guide PDF in the folder demo-directory that you created earlier for storing files to ingest into the vector store. The examples in this topic use the vector store table ... To ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-table-import.html
Otherwise, the table must be created on the same MySQL server instance into which it is being imported. If the table was created in an external directory by specifying the DATA DIRECTORY clause in the CREATE TABLE statement, the table that you ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-stored-procs.html
If replication or binary logging in general (for the purpose of point-in-time recovery) is active, then MySQL DBAs have two security options open to them: Any user wishing to create stored functions must be granted the SUPER privilege. Are stored ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/schema-advisor-ref.html
Default frequency 00:10:00 Default auto-close enabled no Object Changed: Database Has Been Created For development environments, changes to databases and objects may be a normal occurrence, but not for production environments. Default frequency ...
https://dev.mysql.com/doc/refman/8.4/en/federated-usagenotes.html
It is possible for one FEDERATED table to point to another, but you must be careful not to create a loop. Care should be taken when creating a FEDERATED table since the index definition from an equivalent MyISAM or other table may not be supported.