Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-per-table-tablespaces.html
Disk space is returned to the operating system after truncating or dropping a table created in a file-per-table tablespace. Truncating or dropping a table stored in a shared tablespace creates free space within the shared tablespace data file, which ... A file-per-table tablespace contains data and indexes for a single InnoDB table, and is stored on the file system in a single data ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node-remarks.html
The ndb_mgm client supports a DROP NODEGROUP command, but it is possible to drop a node group only when no data nodes in the node group contain any data. This section provides general information about the behavior of and current limitations in ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-partitioning-keys-unique-keys.html
This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management.html
There are a number of ways using SQL statements to modify partitioned tables; it is possible to add, drop, redefine, merge, or split existing partitions using the partitioning extensions to the ALTER TABLE statement. Important Only a single ...
https://dev.mysql.com/doc/refman/8.4/en/truncate-table.html
Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of DROP TABLE and CREATE TABLE statements. It differs from DELETE in the following ways: Truncate operations drop and re-create the table, which is much ...To achieve high performance, TRUNCATE TABLE bypasses the DML method of deleting ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html
The DROP TABLE and CREATE TABLE statements are not executed because the default database is not db1, even though the statements name a table in db1. This option is on by default, which enables database, table, and column name completion. (Default ...
https://dev.mysql.com/doc/refman/8.4/en/lock-tables.html
Another use for UNLOCK TABLES is to release the global read lock acquired with the FLUSH TABLES WITH READ LOCK statement, which enables you to lock all tables in all databases. A session holding a WRITE lock can perform table-level operations such ... LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_type] ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlcheck.html
If you use the --databases or --all-databases option to process all tables in one or more databases, an invocation of mysqlcheck might take a long time. There are three general ways to invoke mysqlcheck: mysqlcheck [options] db_name [tbl_name ...] ... The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
Only those statements are written to the binary log where the default database (that is, the one selected by USE) is db_name. To specify more than one database, use this option multiple times, once for each database; however, doing so does not cause ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-handling-nulls.html
DROP PARTITION, see Section 15.1.9, “ALTER TABLE Statement”.) NULL is also treated in this way for partitioning expressions that use SQL functions. Partitioning in MySQL does nothing to disallow NULL as the value of a partitioning expression, ...