PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-truncate-table-reclaim-space.html
When a table is truncated, it is dropped and re-created in a new .ibd file, and the freed space is returned to the operating system. To reclaim operating system disk space when truncating an InnoDB table, the table must be stored in its own .ibd ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-indexes.html
Dropping and re-adding an index can be expensive for a large table, whereas making it invisible and visible are fast, in-place operations. MySQL supports invisible indexes; that is, indexes that are not used by the optimizer. The feature applies to ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-log-events.html
Table 25.61 Events relating to NDB Cluster schema operations Event Priority Severity Level Description CreateSchemaObject 8 INFO Schema objected created AlterSchemaObject 8 INFO Schema object updated DropSchemaObject 8 INFO Schema object dropped ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-logs-cluster-log.html
The following table lists the most common NDB cluster log messages. For information about the cluster log, log events, and event types, see Section 25.6.3, “Event Reports Generated in NDB Cluster”. These log messages also correspond to log ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-events.html
This table provides information about event subscriptions in NDB. The columns of the events table are listed here, with short descriptions of each: event_id The event ID name The name of the event table_id The ID of the table on which the event ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-perror.html
This is intended as a drop-in replacement for perror --ndb, which is no longer supported. ndb_perror shows information about an NDB error, given its error code. This includes the error message, the type of error, and whether the error is permanent ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-statistics.html
Alternatively, to disable histogram statistics, use ANALYZE TABLE to drop them. The column_statistics data dictionary table stores histogram statistics about column values, for use by the optimizer in constructing query execution plans. The ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-key.html
Important For a key-partitioned table, you cannot execute an ALTER TABLE DROP PRIMARY KEY, as doing so generates the error ERROR 1466 (HY000): Field in list of fields for partition function not found in table. Partitioning by key is similar to ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-storage-engines.html
Partitioned tables using storage engines other than InnoDB cannot be upgraded from MySQL 5.7 or earlier to MySQL 8.0 or later; you must either drop the partitioning from such tables with ALTER TABLE ... In MySQL 8.0, partitioning support is not ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-linear-hash.html
MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas regular hashing employs the modulus of the hashing function's value. We call this value V; it can be ...