Search Results
https://dev.mysql.com/doc/refman/8.4/en/faqs-mysql-cluster.html
You must also remember to account for any column indexes as follows: Each primary key or hash index created for an NDBCLUSTER table requires 21−25 bytes per record. Creating NDB Cluster tables with USING HASH for all primary keys and unique ...Can ... In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/8.4/en/charset-table.html
The CREATE TABLE and ALTER TABLE statements have optional clauses for specifying the table character set and collation: CREATE TABLE tbl_name (column_list) [[DEFAULT] CHARACTER SET charset_name] [COLLATE collation_name]] ALTER TABLE tbl_name ...If ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-progress-table-update.html
Rename the original mysql.backup_progress table to mysql.backup_progress_old, and the mysql.backup_progress_new table to mysql.backup_progress. Note If you are working with a multiprimary Group Replication setting, make sure these privileges are ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-trx-table.html
The INNODB_TRX table provides information about every transaction currently executing inside InnoDB, including whether the transaction is waiting for a lock, when the transaction started, and the SQL statement the transaction is executing, if any.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-actors-table.html
Modifications to the setup_actors table affect only foreground threads created subsequent to the modification, not existing threads. The setup_actors table contains information that determines whether to enable monitoring and historical event ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-ml-rag-table.html
If the specified output table doesn't exist, then a new table is created. The routine uses vector store tables and embedding tables created using the same embedding model for context retrieval. Instead, it uses the embeddings stored in this column ... The ML_RAG_TABLE routine runs multiple retrieval-augmented generation (RAG) queries in a batch, in ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-load-event-based.html
If you create the table manually, you can use the CREATE EXTERNAL TABLE command to set it up before loading data into the table. The following example uses Auto Parallel Load to automatically create a new table and set up a stream. mysql> SET ... As ...
https://dev.mysql.com/doc/ndbapi/en/ndb-event.html
Event Constructor Description The Event constructor creates a new instance with a given name, and optionally associated with a table. A blob table event is created for each blob attribute, and blob events are handled as part of main table events.
https://dev.mysql.com/doc/heatwave/en/mys-hw-modifying-tables.html
When an InnoDB table is loaded into MySQL HeatWave Cluster, DDL operations such as ALTER TABLE, RENAME TABLE, TRUNCATE TABLE, and DROP TABLE are permitted. While any of these operations are being executed, queries involving the modified table are ...If you are explicitly trying to use the secondary engine, these queries generate an offload ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cmpmem-table.html
The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables provide status information on compressed pages within the InnoDB buffer pool. The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables have these columns: PAGE_SIZE The block size in bytes. row ...PAGES_USED ...