Search Results
https://dev.mysql.com/doc/refman/8.4/en/drop-server.html
DROP SERVER [ IF EXISTS ] server_name Drops the server definition for the server named server_name. Dropping a server for a table does not affect any FEDERATED tables that used this connection information when they were created. DROP SERVER is not ...
https://dev.mysql.com/doc/refman/8.4/en/drop-event.html
DROP EVENT [IF EXISTS] event_name This statement drops the event named event_name. This statement requires the EVENT privilege for the schema to which the event to be dropped belongs. The event immediately ceases being active, and is deleted ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-drop-table.html
Usage ndb_drop_table -c connection_string tbl_name -d db_name Options that can be used with ndb_drop_table are shown in the following table. --database, -d Command-Line Format --database=name Type String Default Value TEST_DB Name of the database in ...--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving ...
https://dev.mysql.com/doc/internals/en/files-in-innodb-sources.html
\buf (BUFFERING) File Name What Name Stands For Size Comment Inside File --------- -------------------- ------ ------------------- buf0buf.c Buffering / Buffering 65,582 The database buffer buf_pool buf0flu.c Buffering / Flush 29,583 ... \db ... The ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-create-alter-drop-server.html
The statements CREATE SERVER, ALTER SERVER, and DROP SERVER are not written to the binary log, regardless of the binary logging format that is in use.
https://dev.mysql.com/doc/refman/8.4/en/alter-database.html
See Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) If you change the default character set or collation for a database, any stored routines that are to use the new defaults must be dropped and recreated. TEMPORARY tables; ...alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
ALTER TABLE with ADD PARTITION, DROP PARTITION, COALESCE PARTITION, REBUILD PARTITION, or REORGANIZE PARTITION does not create temporary tables (except when used with NDB tables); however, these operations can and do create temporary partition files. Renaming a table requires ALTER and DROP on the old table, ALTER, CREATE, and INSERT on the new ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-operations.html
The temporary table comprising the new clustered index is renamed with the name of the original table, and the original table is dropped from the database. However, DROP PARTITION with ALGORITHM=COPY or old_alter_table=ON rebuilds the partitioned ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html
Invocation Syntax There are in general three ways to use mysqldump—in order to dump a set of one or more tables, a set of one or more complete databases, or an entire MySQL server—as shown here: mysqldump [options] db_name [tbl_name ...] ... The ...The mysqldump command can also generate output in CSV, other delimited text, or XML ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-performanceschema-activity-category.html
Table 6.22 Performance Schema Activity Metrics NameDescriptionCond Classes Lost (Delta) How many instruments of type cond could not be loaded. Cond Instances Lost (Delta) How many instances of object type cond could not be created. File Classes Lost ... Lists the Performance Schema Activity metrics and provides a brief description of ...