Search Results
https://dev.mysql.com/doc/refman/8.4/en/get-diagnostics.html
This instance of GET DIAGNOSTICS assigns the number of available conditions and the rows-affected count to the user variables @p1 and @p2: GET DIAGNOSTICS @p1 = NUMBER, @p2 = ROW_COUNT; To obtain condition information, specify the condition number ... GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-log-events.html
Table 25.36 Events relating to single user mode Event Priority Severity Level Description SingleUser 7 INFO Entering or exiting single user mode BACKUP Events These events provide information about backups being created or restored. Table 25.33 ...
https://dev.mysql.com/doc/refman/8.4/en/storage-engines.html
(The CREATE TABLE statement in MySQL 8.4 creates InnoDB tables by default.) MySQL Server uses a pluggable storage engine architecture that enables storage engines to be loaded into and unloaded from a running MySQL server. For advanced users, it ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-1.html
It was removed due to a critical issue that could stop the server from restarting following the creation of a very large number of tables (8001 or more). (Bug #36685422) Microsoft Windows: For MSI installations on Windows, MySQL Configurator now ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-models-delete.html
Users that create models or have the required privileges to a model on the MODEL_CATALOG table can delete them. The schema is named for the user that created the model. Before You Begin Review how to Create a Machine Learning Model. mysql> DELETE ...Delete a Model To delete a model from the model catalog table: Query the model catalog table for the model_id, model_owner, and ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-hashicorp-plugin.html
The following instructions describe how to create the certificate and key files using OpenSSL. (Optional) To check key file content and validity, use the following commands: openssl rsa -in company.key -check openssl rsa -in vault.key -check Create ... Note The keyring_hashicorp plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data.html
mysql> CALL sys.HEATWAVE_LOAD( '[{"db_name": "db_1", "tables": [{ "table_name": "table_1", "engine_attribute": { "file": [{"uri": "oci://bucket_1@tenant_1/data_file_1.csv"}] } }] }]', NULL); While you can specify all parameters in one command, it ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/setting-up-innodb-cluster-and-mysql-router.html
AdminAPI has built-in functionality for creating sandbox instances that are pre-configured to work with InnoDB Cluster, InnoDB ClusterSet, and InnoDB ReplicaSet in a locally deployed scenario. This example contains the following sections: ... In the ...
https://dev.mysql.com/doc/heatwave-aws/en/running-autopilot-index-advisor-using-heatwave-console.html
Running Autopilot Index Advisor 11.1 Running Autopilot Index Advisor To run Autopilot Index Advisor, the user must connect to the DB system and have the following MySQL privileges: The EXECUTE privilege on the sys schema. The Advisor runs on all ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-requirements.html
The required user account credentials, InnoDB ClusterSet metadata, and Group Replication configuration will be set up during the InnoDB ClusterSet replica cluster creation process. Using AdminAPI commands in MySQL Shell, you can create sandbox MySQL ... The basis of an InnoDB ClusterSet deployment is an existing InnoDB Cluster at MySQL 8.0.27 or higher, and a number of standalone MySQL Server instances that can be formed into replica clusters to provide disaster tolerance for this primary ...