Search Results
https://dev.mysql.com/doc/workbench/en/wb-forward-engineering-sql-scripts.html
Generate USE statements Generate Separate CREATE INDEX Statements Select this option to create separate statements for index creation instead of including index definitions in CREATE TABLE statements. Don't create view placeholder tables Generate ...
https://dev.mysql.com/doc/refman/8.4/en/pam-pluggable-authentication.html
PAM pluggable authentication provides these capabilities: External authentication: PAM authentication enables MySQL Server to accept connections from users defined outside the MySQL grant tables and that authenticate using methods supported by PAM.
https://dev.mysql.com/doc/refman/8.4/en/information-schema.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Other terms that are sometimes used for this information are data ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb.html
This section explains how to optimize database operations for InnoDB tables. InnoDB is the storage engine that MySQL customers typically use in production databases where reliability and concurrency are important.
https://dev.mysql.com/doc/refman/8.4/en/optimizing-myisam.html
The MyISAM storage engine performs best with read-mostly data or with low-concurrency operations, because table locks limit the ability to perform simultaneous updates. In MySQL, InnoDB is the default storage engine rather than MyISAM.
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-api.html
DefaultHashMapSize: Set size (in buckets) to use for table hash maps. ArbitrationDelay: When asked to arbitrate, arbitrator waits this many milliseconds before voting. AutoReconnect: Specifies whether an API node should reconnect fully when ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-key-caches.html
By default, table indexes are assigned to the main (default) key cache created at the server startup. This feature enables you to assign different table indexes to different key caches. Where there are multiple key caches, the server must know which ... Note As of MySQL 8.4, the compound-part structured-variable syntax discussed here for referring to multiple MyISAM key caches is ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-ml-rag.html
The routine uses vector store tables and embedding tables created using the same embedding model for context retrieval. Instead, it uses this embedding for context retrieval from valid vector store and embedding tables that contain vector embeddings ...vector_store: the list of vector store tables used for context ... The ML_RAG routine performs ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-subpartitions.html
Consider the following CREATE TABLE statement: CREATE TABLE ts (id INT, purchased DATE) PARTITION BY RANGE( YEAR(purchased) ) SUBPARTITION BY HASH( TO_DAYS(purchased) ) SUBPARTITIONS 2 ( PARTITION p0 VALUES LESS THAN (1990), PARTITION p1 VALUES LESS ... Subpartitioning—also known as composite partitioning—is the further division of each partition in a partitioned ...
https://dev.mysql.com/doc/refman/8.4/en/kerberos-pluggable-authentication.html
Kerberos pluggable authentication provides these capabilities: External authentication: Kerberos authentication enables MySQL Server to accept connections from users defined outside the MySQL grant tables who have obtained the proper Kerberos ...