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/handler-scope.html
A specific handler is for a MySQL error code, SQLSTATE value, or condition name. For example, there might be a specific MySQL error code handler in an outer block, and a general SQLWARNING handler in an inner block. Or there might be handlers for a ... A stored program may include handlers to be invoked when certain conditions occur within the ...
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/index-hints.html
The USE INDEX (index_list) hint tells MySQL to use only one of the named indexes to find rows in the table. The alternative syntax IGNORE INDEX (index_list) tells MySQL to not use some particular index or indexes. These hints are useful if EXPLAIN ... Index hints give the optimizer information about how to choose indexes during query ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-tuning.html
You can expect less compression from a MySQL compressed table than from file-based compression tools, because MySQL compresses data in chunks based on the page size, 16KB by default. File-based compression utilities can examine much larger chunks of ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...
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-preload-buffer-pool.html
[mysqld] innodb_buffer_pool_dump_pct=40 The innodb_buffer_pool_dump_pct default value is 25 (dump 25% of most-recently-used pages). To restore the buffer pool state at server startup, specify the --innodb-buffer-pool-load-at-startup option when ...
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 ...