Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/group-management.html
For example, you can create groups for development and production instances. User-defined groups are those created and managed in MySQL Enterprise Service Manager's Manage Groups page. You can use the configuration utility to add connections to ...
https://dev.mysql.com/doc/workbench/en/wb-generating-sql.html
MySQL Workbench can be used to generate SQL, most typically as either INSERT statements or SELECT statements. The following common methods are for generating SQL statements in MySQL Workbench. Note All of the MySQL Workbench Export options include ...
https://dev.mysql.com/doc/internals/en/determining-logging-format.html
This must be done prior to the call to THD::decide_logging_format() (that is, prior to lock_tables). The sp_head object stores the Lex that was generated when the statement defining the sub-statement was parsed (that is, when CREATE FUNCTION/CREATE ... For each statement, we must determine the logging format: row or ...
https://dev.mysql.com/doc/heatwave/en/hw-automl-privileges.html
mysql> GRANT CREATE, DROP, INSERT, SELECT, ALTER, DELETE, UPDATE ON database_name.* TO 'user_name'@'%'; Lakehouse and Tracking/Monitoring Privileges You need the following privileges to access external Lakehouse tables that have machine learning ...
https://dev.mysql.com/doc/refman/8.4/en/declare-handler.html
It can take the following forms: mysql_error_code: An integer literal indicating a MySQL error code, such as 1051 to specify “unknown table”: DECLARE CONTINUE HANDLER FOR 1051 BEGIN -- body of handler END; Do not use MySQL error code 0 because ...statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ...
https://dev.mysql.com/doc/refman/8.4/en/expressions.html
The following table shows the expected form of the expr argument for each unit value. This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-instances.html
Configuring group_replication_group_name tells the plugin that the group that it is joining, or creating, is named "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa". The host name that the server is using for SQL client connections can be verified in the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-privilege-synchronization.html
A statement granting the NDB_STORED_USER privilege, such as GRANT NDB_STORED_USER ON *.* TO 'cluster_app_user'@'localhost', works by directing NDB to create a snapshot using the queries SHOW CREATE USER cluster_app_user@localhost and SHOW GRANTS FOR ... Privilege synchronization is the mechanism used by NDB Cluster for sharing and synchronizing users, roles, and privileges between SQL ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-advisors-wiki-format.html
You can format and highlight text and add hyperlinks, using the notation listed in the following table. When editing or defining an advisor, you can enter text in Wiki format in the Problem Description, Advice, Recommended Action, and Links and ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-unattended-installation-cmdline-options-agent.html
Table 9.2 MySQL Enterprise Monitor Agent Installer Options Option Name Description --agent_installtype Installation type for the agent, which can be database or standalone. --createBackup Command-Line Format --createBackup Type Boolean Default Value ... To view all the options available for an unattended agent installation, invoke the agent installer file passing in the help ...