https://dev.mysql.com/fulltext-stopwords.html
The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and collation_server system variables). False hits or misses might occur for stopword lookups if the ...
https://dev.mysql.com/function-optimization.html
This UPDATE statement uses a nondeterministic function to select rows to be modified: UPDATE t SET col_a = some_expr WHERE id = FLOOR(1 + RAND() * 49); Presumably the intent is to update at most a single row for which the primary key matches the ...
https://dev.mysql.com/group-by-functions.html
The SUM() and AVG() functions return a DECIMAL value for exact-value arguments (integer or DECIMAL), and a DOUBLE value for approximate-value arguments (FLOAT or DOUBLE). Prior to MySQL 8.0, bit functions and operators required BIGINT (64-bit ...
https://dev.mysql.com/group-replication-enterprise-backup.html
For example: s3> rm -rf /var/lib/mysql/* If the system variables innodb_data_home_dir, innodb_log_group_home_dir, and innodb_undo_directory point to any directories other than the data directory, they should also be made empty; otherwise, the ...
https://dev.mysql.com/group-replication-functions-for-maximum-consensus.html
Default value is 10, valid values are integers in the range of 10 to 200. The following functions enable you to inspect and configure the maximum number of consensus instances that a group can execute in parallel.
https://dev.mysql.com/innodb-autocommit-commit-rollback.html
shell> mysql test mysql> CREATE TABLE customer (a INT, b CHAR (20), INDEX (a)); Query OK, 0 rows affected (0.00 sec) mysql> -- Do a transaction with autocommit turned on. mysql> START TRANSACTION; Query OK, 0 rows affected (0.00 sec) mysql> INSERT ...If autocommit mode is enabled, each SQL statement forms a single transaction on its ...
https://dev.mysql.com/innodb-compression-tuning.html
Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed data. When you are ready to conduct long-term testing and put compressed tables into production, see Section ...
https://dev.mysql.com/innodb-data-encryption.html
Warning The keyring_file and keyring_encrypted file plugins are not intended as regulatory compliance solutions. mysql> CREATE TABLE t1 (c1 INT) ENCRYPTION = 'Y'; To alter the encryption of an existing file-per-table tablespace, an ENCRYPTION clause ... InnoDB supports data-at-rest encryption for file-per-table tablespaces, general tablespaces, the mysql system tablespace, redo logs, and undo ...
https://dev.mysql.com/innodb-deadlock-example.html
The client returns this error: ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction At that point, the lock request for the other client can be granted and it deletes the row from the table. The following example ...
https://dev.mysql.com/innodb-file-per-table-tablespaces.html
You can backup or restore tables created in file-per-table tablespaces quickly using MySQL Enterprise Backup, without interrupting the use of other InnoDB tables. The scan is performed with a broad internal lock, which may delay other operations. A ...
