Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-parallel-load-overview.html
mysql> GRANT SELECT ON performance_schema.* TO 'user_name'@'%'; About Lakehouse Auto Parallel Load Schema Inference Lakehouse Auto Parallel Load includes schema inference, and uses it in one of two ways: Lakehouse Auto Parallel Load analyzes the ...
https://dev.mysql.com/doc/refman/8.4/en/show-engine.html
An NdbTransaction is created each time a table schema operation (such as CREATE TABLE or ALTER TABLE) is performed on an NDB table. An NdbBlob is created for each new operation involving a BLOB column in an NDB table. Note InnoDB mutexes and rwlocks ... SHOW ENGINE engine_name {STATUS | MUTEX} SHOW ENGINE displays operational information about a storage ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-security-mysql-privileges.html
The only tables that would be safe from this sort of mayhem would be those tables that were created using storage engines other than NDB, and so not visible to a “rogue” SQL node. This includes all MySQL privilege types (SELECT privilege, UPDATE ... In this section, we discuss how the MySQL privilege system works in relation to NDB Cluster and the implications of this for keeping an NDB Cluster ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-lifecycle.html
A GTID is also assigned to the creation, alteration, or deletion of a database, and of a non-table database object such as a procedure, function, trigger, event, view, user, role, or grant. One GTID is generated for the CREATE TABLE action and one ...Whenever the binary log is rotated or the server is shut down, the server writes GTIDs for all transactions that were written into the previous binary log file into the mysql.gtid_executed ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-storage-engines.html
This means that partitioned tables cannot be created using any other storage engine than these. (You must be using MySQL NDB Cluster with the NDB storage engine to create NDB tables.) InnoDB storage engine. It is not possible under normal ... In ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-generate-embeddings.html
Using this method, you can create vector embedding tables that you can use to perform similarity searches using the DISTANCE() function, without setting up a vector store. OutputTableName: the name of the table where you want to create a new column ...You can pass the text string in the routine manually or use data from tables in your ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-query-time-estimation.html
row *************************** query_id: 15 LEFT(query_text,160): CREATE TABLE flight_from_US SELECT * FROM flight WHERE `from` IN (SELECT airport_id FROM airport_geo WHERE country="UNITED STATES") *************************** 3. row ...To view the ... Auto Query Time Estimation provides: Runtimes for successfully executed queries Runtime estimates for EXPLAIN ...
https://dev.mysql.com/doc/refman/8.4/en/trigger-syntax.html
To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER Statement”. Here is a simple example that associates a ...
https://dev.mysql.com/doc/refman/8.4/en/function-resolution.html
This occurs even when the function name is used in nonexpression context: mysql> CREATE TABLE count(i INT); ERROR 1064 (42000): You have an error in your SQL syntax ... When the parser encounters a word that is the name of a built-in function, it ...
https://dev.mysql.com/doc/refman/8.4/en/where-optimization.html
If there is an ORDER BY clause and a different GROUP BY clause, or if the ORDER BY or GROUP BY contains columns from tables other than the first table in the join queue, a temporary table is created. COUNT(*) on a single table without a WHERE is ...