Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-fulltext-index.html
Common index tables are retained even if full-text indexes are dropped. When a full-text index is dropped, the FTS_DOC_ID column that was created for the index is retained, as removing the FTS_DOC_ID column would require rebuilding the previously ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-syntax.html
It is not possible to drop partitions from NDB tables using ALTER TABLE ... Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: Temporary tables. Trying either to ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-ddl-operations.html
Many DDL operations on tables and indexes (CREATE, ALTER, and DROP statements) can be performed online. Foreign key constraints can make a TRUNCATE statement work like a regular DELETE statement, in which case a sequence of commands like DROP TABLE ...Online DDL support for adding secondary indexes means that you can generally speed up the process of creating and loading a table and associated indexes by creating the table without secondary indexes, then adding secondary indexes after the data is ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-hash-key.html
For a discussion of adding and dropping of partitions of tables that are partitioned by range or list, see Section 26.3.1, “Management of RANGE and LIST Partitions”. You cannot drop partitions from tables that are partitioned by HASH or KEY in ... Tables which are partitioned by hash or by key are very similar to one another with regard to making changes in a partitioning setup, and both differ in a number of ways from tables which have been partitioned by range or ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-source.html
rpl_semi_sync_source_wait_no_replica controls whether the source waits for the timeout period configured by rpl_semi_sync_source_timeout to expire, even if the replica count drops to less than the number of replicas configured by ... This section ...
https://dev.mysql.com/doc/refman/8.4/en/show-procedure-code.html
For each statement that is taken from source, there is a code word stmt followed by a type (9 means DROP, 5 means INSERT, and so on). SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers that have ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-metrics-meter-metrics.html
crud_drop_view Mysqlx_crud_drop_view ASYNC COUNTER The number of drop view requests received. drop_collection Mysqlx_stmt_drop_collection ASYNC COUNTER The number of drop collection statements received. drop_collection_index ... The following server ...
https://dev.mysql.com/doc/refman/8.4/en/view-syntax.html
To alter the definition of a view or drop a view, use ALTER VIEW (see Section 15.1.11, “ALTER VIEW Statement”), or DROP VIEW (see Section 15.1.35, “DROP VIEW Statement”). The CREATE VIEW statement creates a new view (see Section 15.1.23, ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-status-variables.html
Mysqlx_aborted_clients The number of clients that were disconnected because of an input or output error. Mysqlx_address The network address or addresses for which X Plugin accepts TCP/IP connections. If multiple addresses were specified using the ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-6.html
(Bug #37704514) Performance: Redundant conditions in some queries optimized away in MySQL 8.0 were no longer removed in later versions, leading to a significant drop in the performance of such queries. (Bug #37822992) InnoDB: Fixed an issue relating ... Note These release notes were created with the assistance of MySQL HeatWave ...