Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-reload-mysql-tables.html
As of MySQL 8.4.0, MySQL HeatWave lets you reload all tables using the HEATWAVE_RELOAD routine. Before You Begin Complete the steps to load data using Auto Parallel Load or manually. Learn how to use the Machine Learning capabilities of MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-service.html
If there is no user context, this value can be NULL. The value need not actually be a “user”; the meaning depends on the application. Functions that implement the keyring function interface pass the value of CURRENT_USER() as the user_id value ... MySQL Server supports a keyring service that enables internal components and plugins to securely store sensitive information for later ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-waiter.html
SINGLE USER MODE: This is shown for all cluster data nodes when the cluster is in single user mode. --single-user The program waits for the cluster to enter single user mode. ndb_waiter repeatedly (each 100 milliseconds) prints out the status of ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-auto-sync.html
#!/user/bin/perl -w # file: reset-replica.pl # Copyright (c) 2005, 2020, Oracle and/or its affiliates. It is possible to automate much of the process described in the previous section (see Section 25.7.9, “NDB Cluster Backups With NDB Cluster ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-logging.html
Optimize the use of spin delay by user threads waiting for flushed redo. innodb_log_wait_for_flush_spin_hwm: Defines the maximum average log flush time beyond which user threads no longer spin while waiting for flushed redo. Consider the following ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-filtering.html
Pre-filtering is done by the Performance Schema and has a global effect that applies to all users. Post-filtering is performed on a per-user basis because individual users select which of the available events are of interest. Reasons to use ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-install-configuration-file.html
The mcmd configuration file allows you to configure mcmd with its application options. A sample configuration file is provided with the MySQL Cluster Manager distribution at mcmd8.4.6/doc/sample_mcmd.conf. Edit the [mcmd] section of the file and ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-23.html
Old names have been deprecated—though they are still usable for now, they are to be removed eventually in future releases; users are therefore encouraged to switch to the new names. (WL #14207) Functionality Added or Changed Important Change: A ...
https://dev.mysql.com/doc/refman/8.4/en/lock-instance-for-backup.html
LOCK INSTANCE FOR BACKUP permits DDL operations that only affect user-created temporary tables. In effect, files that belong to user-created temporary tables can be created, renamed, or removed while a backup lock is held. The BACKUP_ADMIN privilege ... LOCK INSTANCE FOR BACKUP UNLOCK INSTANCE LOCK INSTANCE FOR BACKUP acquires an instance-level backup lock that permits DML during an online backup while preventing operations that could result in an inconsistent ...
https://dev.mysql.com/doc/heatwave/en/heatwave-errors.html
Description: This error indicates issues such as memory limits, data type range violations, or interruption of the query by the user. Error number: 1042; Symbol: HW_ER_TOPK_QKRN_CREATION Message: Error - failed to process the sort operation with ...