Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-resource-group.html
These attributes are specified the same way as described for CREATE RESOURCE GROUP (see Section 15.7.2.2, “CREATE RESOURCE GROUP Statement”). If FORCE is given, existing threads in the group are moved to their respective default group (system ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-mixed.html
When the body of a view requires row-based replication, the statement creating the view also uses it. For example, this occurs when the statement creating a view uses the UUID() function. (Bug #12092, Bug #30244) When USER(), CURRENT_USER(), or ...
https://dev.mysql.com/doc/refman/8.4/en/call.html
CALL sp_name([parameter[,...]]) CALL sp_name[()] The CALL statement invokes a stored procedure that was defined previously with CREATE PROCEDURE. To get back a value from a procedure using an OUT or INOUT parameter, pass the parameter by means of a ...Stored procedures that take no arguments can be invoked without ...
https://dev.mysql.com/doc/refman/8.4/en/data-directory.html
Information managed by the MySQL server is stored under a directory known as the data directory. The following list briefly describes the items typically found in the data directory, with cross references for additional information: Data directory ...
https://dev.mysql.com/doc/refman/8.4/en/event-scheduler.html
Section 27.4.3, “Event Syntax”, discusses the SQL statements for creating, altering, and dropping MySQL Events. You may also find the MySQL User Forums to be helpful. The MySQL Event Scheduler manages the scheduling and execution of events, ...
https://dev.mysql.com/doc/refman/8.4/en/full-disk.html
This section describes how MySQL responds to disk-full errors (such as “no space left on device”), and to quota-exceeded errors (such as “write failed” or “user block limit reached”). Exceptions to the preceding behavior are when you ...
https://dev.mysql.com/doc/refman/8.4/en/gtid-functions.html
WAIT_FOR_EXECUTED_GTID_SET() monitors all the GTIDs that are applied on the server, including transactions that arrive from all replication channels and user clients. The functions described in this section are used with GTID-based replication. It ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-st-spatial-reference-systems-table.html
Notes The SRS_NAME, ORGANIZATION, ORGANIZATION_COORDSYS_ID, and DESCRIPTION columns contain information that may be of interest to users, but they are not used by MySQL. The ST_SPATIAL_REFERENCE_SYSTEMS table provides information about available ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-backup.html
MySQL Enterprise Backup can also create compressed backup files, and back up subsets of tables and databases. In conjunction with the MySQL binary log, users can perform point-in-time recovery. Logical Backups Using mysqldump In addition to physical ... The key to safe database management is making regular ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-read-only-instance.html
For example, CREATE USER, GRANT, REVOKE, and INSTALL PLUGIN operations are not permitted in read-only mode. The default setting is ibtmp1:12M:autoextend, which creates the ibtmp1 temporary tablespace data file in the data directory. For example: ...