Search Results
https://dev.mysql.com/doc/refman/8.4/en/view-updatability.html
Some views are updatable and references to them can be used to specify tables to be updated in data change statements. That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying table. Derived ...For dependent subqueries in the select list, no data change statements are ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-storage-engine.html
Table 18.2 MyISAM Storage Engine Features Feature Support B-tree indexes Yes Backup/point-in-time recovery (Implemented in the server, rather than in the storage engine.) Yes Cluster database support No Clustered indexes No Compressed data Yes ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-handling-nulls.html
If you insert a row into a table partitioned by RANGE such that the column value used to determine the partition is NULL, the row is inserted into the lowest partition. DROP PARTITION, see Section 15.1.9, “ALTER TABLE Statement”.) NULL is also ... 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 ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-rag.html
For context retrieval, the ML_RAG routine uses the name of the embedding model used to embed the input query to find relevant vector store tables that contain vector embeddings from the same embedding model. The examples in this topic use the vector ... The ML_RAG routine runs retrieval-augmented generation which aims to generate more accurate responses for your ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-session.html
Table 4.47 createQuery(QueryDefinition<T>) Parameter Description qd the query definition return the query instance 4.3.1.22.5 currentTransaction() public abstract Transaction currentTransaction(); Get the current com.mysql.clusterj.Transaction.
https://dev.mysql.com/doc/mysql-monitor/8.0/en/admin-advisors-reference.html
Default frequency 12:00:00 Default auto-close enabled yes Database May Not Be Portable Due To Identifier Case Sensitivity The case sensitivity of the underlying operating system determines the case sensitivity of database and table names. However, ...However, for performance reasons, it is recommended to run 64-bit binaries on 64-bit platforms, and 32-bit binaries on 32-bit ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-examples.html
This section describes the use of locking information as exposed by the Performance Schema data_locks and data_lock_waits tables. The tables that contain information about InnoDB transactions and data locks enable you to determine which transaction ...Identifying Blocking Transactions It is sometimes helpful to identify which transaction blocks ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-queries-myisam.html
Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize queries, use ANALYZE TABLE or run myisamchk --analyze on a table after it has been loaded with data. (For unique indexes, this is always 1.) MySQL uses this ...This updates a value for each index part that indicates the average number of rows that have the same ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-key.html
NDB Cluster uses MD5() for this purpose; for tables using other storage engines, the server employs its own internal hashing function. PARTITION BY KEY are similar to those for creating a table that is partitioned by hash. Any columns used as the ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-maintenance.html
A number of table and partition maintenance tasks can be carried out on partitioned tables using SQL statements intended for such purposes. Table maintenance of partitioned tables can be accomplished using the statements CHECK TABLE, OPTIMIZE ...