Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/en/innodb-consistent-read.html
Consistent read does not work over certain DDL statements: Consistent read does not work over DROP TABLE, because MySQL cannot use a table that has been dropped and InnoDB destroys the table. A consistent read means that InnoDB uses ...
https://dev.mysql.com/doc/refman/8.4/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.4/en/load-xml.html
The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and >). LOAD XML acts as the complement of running the mysql client in XML output mode (that is, starting the ...
https://dev.mysql.com/doc/refman/8.4/en/memory-storage-engine.html
To free all the memory used by a MEMORY table when you no longer require its contents, execute DELETE or TRUNCATE TABLE to remove all rows, or remove the table altogether using DROP TABLE. The MEMORY storage engine (formerly known as HEAP) creates ...
https://dev.mysql.com/doc/refman/8.4/en/memory-use.html
This memory is not released by the corresponding REVOKE, DROP USER, DROP SERVER, and UNINSTALL PLUGIN statements, so for a server that executes many instances of the statements that cause caching, there is an increase in cached memory use unless it ... MySQL allocates buffers and caches to improve performance of database ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-importing-data.html
If a data import operation does not complete successfully, for whatever reason, you should be prepared to perform any necessary cleanup including possibly one or more DROP TABLE statements, DROP DATABASE statements, or both. It is common when ...
https://dev.mysql.com/doc/refman/8.4/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.4/en/mysql-cluster-sql-statements.html
This section discusses several SQL statements that can prove useful in managing and monitoring a MySQL server that is connected to an NDB Cluster, and in some cases provide information about the cluster itself. SHOW ENGINE NDB STATUS, SHOW ENGINE ...
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. mysql supports the following options, which can be specified on the command line or in the [mysql] ...