Search Results
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-gtids.html
Only statements that can be logged using GTID safe statements can be logged when enforce_gtid_consistency is set to ON, so the operations listed here cannot be used with this option: CREATE TEMPORARY TABLE or DROP TEMPORARY TABLE statements inside ... The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers ...
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/symbolic-links-to-tables.html
Note When you drop a table that is using symlinks, both the symlink and the file to which the symlink points are dropped. If you are not using symlinks, start mysqld with the --skip-symbolic-links option to ensure that no one can use mysqld to drop ... Note Symbolic link support as described here, along with the --symbolic-links option that controls it, and is deprecated; expect these to be removed in a future version of ...
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 ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-progress-table-update.html
Rename the original mysql.backup_progress table to mysql.backup_progress_old, and the mysql.backup_progress_new table to mysql.backup_progress. Note If you are working with a multiprimary Group Replication setting, make sure these privileges are ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-8.html
Schema.dropView() now executes immediately and returns void; also, the ViewDrop interface has been removed. Collection.dropIndex() now executes immediately and returns void; also the DropCollectionIndexStatement interface has been removed. The ...