Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-databases.html
The WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW Statements”. If the server was started with the --skip-show-database option, you cannot use this statement at all ...
https://dev.mysql.com/doc/refman/8.4/en/show-replicas.html
Statement output includes this column only if the source server is started with the --show-replica-auth-info option. Statement output includes this column only if the source server is started with the --show-replica-auth-info option. SHOW REPLICAS ...
https://dev.mysql.com/doc/refman/8.4/en/show-tables.html
The WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW Statements”. The optional EXTENDED modifier causes SHOW TABLES to list hidden tables created by failed ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.4/en/shutdown.html
Because status variables are initialized for each server startup and do not persist across restarts, Com_shutdown normally has a value of zero, but can be nonzero if SHUTDOWN statements were executed but failed. SHUTDOWN provides an SQL-level ...
https://dev.mysql.com/doc/refman/8.4/en/delete-optimization.html
The time required to delete individual rows in a MyISAM table is exactly proportional to the number of indexes. To delete rows more quickly, you can increase the size of the key cache by increasing the key_buffer_size system variable. To delete all ...
https://dev.mysql.com/doc/refman/8.4/en/create-resource-group.html
This statement creates a new resource group and assigns its initial attribute values. CREATE RESOURCE GROUP statements are not written to the binary log and are not replicated. CREATE RESOURCE GROUP group_name TYPE = {SYSTEM|USER} [VCPU [=] ...
https://dev.mysql.com/doc/refman/8.4/en/declare-local-variable.html
type [DEFAULT value] This statement declares local variables within stored programs. To provide a default value for a variable, include a DEFAULT clause. The value can be specified as an expression; it need not be a constant. If the DEFAULT clause ...
https://dev.mysql.com/doc/refman/8.4/en/do.html
In most respects, DO is shorthand for SELECT expr, ..., but has the advantage that it is slightly faster when you do not care about the result. DO is useful primarily with functions that have side effects, such as RELEASE_LOCK(). It cannot be used ...
https://dev.mysql.com/doc/refman/8.4/en/drop-logfile-group.html
DROP LOGFILE GROUP logfile_group ENGINE [=] engine_name This statement drops the log file group named logfile_group. (For information on creating log file groups, see Section 15.1.16, “CREATE LOGFILE GROUP Statement”.) Important Before dropping ...The log file group must already exist or an error ...
https://dev.mysql.com/doc/refman/8.4/en/drop-tablespace.html
DROP [UNDO] TABLESPACE tablespace_name This statement drops a tablespace that was previously created using CREATE TABLESPACE. mysql> DROP UNDO TABLESPACE undo_003; NDB Example This example shows how to drop an NDB tablespace myts having a data file ...The UNDO keyword must be specified to drop an undo ...