Search Results
https://dev.mysql.com/doc/refman/8.4/en/drop-tablespace.html
mysql> CREATE TABLESPACE `ts1` ADD DATAFILE 'ts1.ibd' Engine=InnoDB; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY) TABLESPACE ts1 Engine=InnoDB; mysql> DROP TABLE t1; mysql> DROP TABLESPACE ts1; This example demonstrates dropping an undo tablespace.
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search-ngram.html
The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word delimiters. To address this limitation, ...The ngram full-text parser is supported for use with InnoDB and ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-getting-started.html
MySQL Group Replication is provided as a plugin for the MySQL server; each server in a group requires configuration and installation of the plugin. Tip To deploy multiple instances of MySQL, you can use InnoDB Cluster which enables you to easily ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-case-sensitivity.html
In MySQL, databases correspond to directories within the data directory. The following statement would not work because it refers to a table both as my_table and as MY_TABLE: mysql> SELECT * FROM my_table WHERE MY_TABLE.col=1; Partition, ...Each ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking.html
Record locks for nonmatching rows are released after MySQL has evaluated the WHERE condition. For UPDATE statements, InnoDB does a “semi-consistent” read, such that it returns the latest committed version to MySQL so that MySQL can determine ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-read-only-instance.html
You can query InnoDB tables where the MySQL data directory is on read-only media by enabling the --innodb-read-only configuration option at server startup. To enable read-only mode for an entire MySQL instance, specify the following configuration ...How to Enable To prepare an instance for read-only operation, make sure all the necessary information is flushed to the data files before storing it on the read-only ...
https://dev.mysql.com/doc/refman/8.4/en/ipv6-support.html
Support for IPv6 in MySQL includes these capabilities: MySQL Server can accept TCP/IP connections from clients connecting over IPv6. For example, this command connects over IPv6 to the MySQL server on the local host: $> mysql -h ::1 To use this ...
https://dev.mysql.com/doc/refman/8.4/en/merge-storage-engine.html
When you create a MERGE table, MySQL creates a .MRG file on disk that contains the names of the underlying MyISAM tables that should be used as one. The table format of the MERGE table is stored in the MySQL data dictionary. Additional Resources A ... The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as ...
https://dev.mysql.com/doc/refman/8.4/en/nonpersistible-system-variables.html
You must perform this step directly on the MySQL server host because persist_only_admin_x509_subject itself cannot be persisted at runtime. SET PERSIST and SET PERSIST_ONLY enable global system variables to be persisted to the mysqld-auto.cnf ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features.html
The following sections provide information about what is supported and what is not in MySQL replication, and about specific issues and situations that may occur when replicating certain statements. If you use a feature on the source server that is ...Statement-based replication depends on compatibility at the SQL level between the source and ...