PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/host-cache.html
This requires the DROP privilege for the Performance Schema host_cache table or the RELOAD privilege. The MySQL server maintains an in-memory host cache that contains information about clients: IP address, host name, and error information. The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-files-table.html
It is also important to remember that once an extent is used, it cannot be freed again without dropping the data file of which it is a part. For additional information, and examples of creating, dropping, and obtaining information about NDB Cluster ... The FILES table provides information about the files in which MySQL tablespace data is ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-st-spatial-reference-systems-table.html
DROP SPATIAL REFERENCE SYSTEM: See Section 15.1.31, “DROP SPATIAL REFERENCE SYSTEM Statement”. The ST_SPATIAL_REFERENCE_SYSTEMS table provides information about available spatial reference systems (SRSs) for spatial data. Entries in the ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-columns.html
An invisible column dropped from a table is dropped in the usual way from any index definition that names the column. An invisible column is normally hidden to queries, but can be accessed if explicitly referenced. As an illustration of when ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-table-distribution-status.html
The table_distribution_status table provides information about the progress of table distribution for NDB tables. is_reorg_ongoing Whether the table is currently being reorganized (1 if true) .
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-upgrade-downgrade.html
Do not use ALTER TABLE on any existing NDB tables; do not create any new NDB tables which cannot be safely dropped prior to downgrading. After backing up the state data, drop all NDB tables which have been created or altered since the upgrade took ... Versions Supported for Upgrade to NDB 8.0 Reverting an NDB Cluster 8.0 Upgrade Known Issues When Upgrading or Downgrading NDB Cluster This section provides information about NDB Cluster software and compatibility between different NDB Cluster 8.0 releases with regard to performing upgrades and ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-list.html
(Using ALTER TABLE employees DROP PARTITION pWest would also delete all of these rows, but would also remove the partition pWest from the definition of the table; you would need to use an ALTER TABLE ... List partitioning in MySQL is similar to ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-clone-progress-table.html
The stages of a cloning operation include DROP DATA, FILE COPY, PAGE_COPY, REDO_COPY, FILE_SYNC, RESTART, and RECOVERY. Stages include DROP DATA, FILE COPY, PAGE_COPY, REDO_COPY, FILE_SYNC, RESTART, and RECOVERY. Note The Performance Schema table ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-auto-increment.html
Regardless of the method used to create and populate the copy having the AUTO_INCREMENT column, the final step is to drop the original table and then rename the copy: DROP t1; ALTER TABLE t2 RENAME t1; See also Section B.3.6.1, “Problems with ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-temptables.html
In statement-based replication mode, CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE statements cannot be used inside a transaction, procedure, function, or trigger when GTIDs are in use on the server (that is, when the enforce_gtid_consistency ...