Search Results
https://dev.mysql.com/doc/internals/en/x-protocol-notices-notices.html
Global Notices Global Notices are sent by the server in case of events happen that are unrelated to the currently active message sequence: server is shutting down node disconnected from group schema or table dropped binlog events Server Shutting ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-topic-modeling-prepare.html
mysql> CREATE DATABASE topic_modeling_data; mysql> USE topic_modeling_data; Create the table to use for both training and testing. mysql> CREATE TABLE movies ( description TEXT ); Insert the sample data into the table. He must ensure his parents ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-component-installation.html
For example, the InnoDB storage engine uses the keyring for tablespace encryption, so a keyring component or plugin must be loaded and available prior to InnoDB initialization. Alternatively, to use a global and local manifest file pair, the global ... Keyring service consumers require that a keyring component or plugin be installed: To use a keyring component, begin with the instructions ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-privilege-synchronization.html
Note NDB Cluster 8.4 does not support distribution of MySQL users and privileges across SQL nodes in an NDB Cluster by altering the MySQL privilege tables such that they use the NDB storage engine as was done in older releases (NDB 7.6 and ...
https://dev.mysql.com/doc/refman/8.4/en/show-procedure-status.html
To use either statement, you must be the user named as the routine DEFINER, have the SHOW_ROUTINE privilege, have the SELECT privilege at the global level, or have the CREATE ROUTINE, ALTER ROUTINE, or EXECUTE privilege granted at a scope that ...
https://dev.mysql.com/doc/refman/8.4/en/stored-objects.html
Trigger: An object created with CREATE TRIGGER that is associated with a table. A trigger is activated when a particular event occurs for the table, such as an insert or update. The following sections provide additional information about SQL syntax ... This chapter discusses stored database objects that are defined in terms of SQL code that is stored on the server for later ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-save.html
This enables you to alter the configuration temporarily for debugging or other purposes, then restore it to the previous state by invoking the ps_setup_reload_saved() procedure. It is intended you call ps_setup_reload_saved() later within the same ...To prevent other simultaneous calls to save the configuration, ps_setup_save() acquires an advisory lock named sys.ps_setup_save by calling the GET_LOCK() ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-topic-modeling-prepare.html
mysql> CREATE DATABASE topic_modeling_data; mysql> USE topic_modeling_data; Create the table to use for both training and testing. mysql> CREATE TABLE movies ( description TEXT ); Insert the sample data into the table. He must ensure his parents ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/replication-advisor-ref.html
Default frequency 00:01:00 Default auto-close enabled yes Slave Has Login Accounts With Inappropriate Privileges Altering and dropping tables on a slave can break replication. It also enables you to review all alterations made to your database. It ...By default, the server logs the length of the event as well as the event itself and uses this information to verify that the event was written ...
https://dev.mysql.com/doc/refman/8.4/en/account-locking.html
MySQL supports locking and unlocking user accounts using the ACCOUNT LOCK and ACCOUNT UNLOCK clauses for the CREATE USER and ALTER USER statements: When used with CREATE USER, these clauses specify the initial locking state for a new account. When ...In the absence of either clause, the account is created in an unlocked ...