Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-effect.html
latin1_swedish_ci latin1_german1_ci latin1_german2_ci Muffler Muffler Müller MX Systems Müller Muffler Müller MX Systems MX Systems MySQL MySQL MySQL The character that causes the different sort orders in this example is ü (German ...
https://dev.mysql.com/doc/refman/8.4/en/cursor-restrictions.html
In MySQL, a server-side cursor is materialized into an internal temporary table. Initially, this is a MEMORY table, but is converted to a MyISAM table when its size exceeds the minimum value of the max_heap_table_size and tmp_table_size system ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-storage-engines.html
Where can I obtain complete documentation for MySQL storage engines? See Chapter 18, Alternative Storage Engines. The disabled_storage_engines configuration option defines which storage engines cannot be used to create tables or tablespaces. MySQL ...Where can I obtain complete documentation for MySQL storage engines? ...
https://dev.mysql.com/doc/refman/8.4/en/get-diagnostics.html
For example: mysql> GET DIAGNOSTICS CONDITION 1 @p5 = SCHEMA_NAME, @p6 = TABLE_NAME; mysql> SELECT @p5, @p6; +------+------+ | @p5 | @p6 | +------+------+ | | | +------+------+ In standard SQL, if there are multiple conditions, the first condition ... GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-handling.html
To tell MySQL to accept the query, you can use the ANY_VALUE() function: SELECT name, ANY_VALUE(address), MAX(age) FROM t GROUP BY name; Alternatively, disable ONLY_FULL_GROUP_BY. SQL-92 and earlier does not permit queries for which the select ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-bootstrap.html
For the purpose of demonstrating that the server is indeed in a group and that it is able to handle load, create a table and add some content to it. mysql> CREATE DATABASE test; mysql> USE test; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-limitations.html
Group Replication cannot be started following a MySQL Server upgrade that uses the MINIMAL option (--upgrade=MINIMAL), which does not upgrade system tables on which the replication internals depend. Note For a group in multi-primary mode, unless you ... Limit on Group Size Limits on Transaction Size The following known limitations exist for Group ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-network-partitioning.html
Detecting Partitions The replication_group_members performance schema table presents the status of each server in the current view from the perspective of this server. The majority of the time the system does not run into partitioning, and therefore ... The group needs to achieve consensus whenever a change that needs to be replicated ...
https://dev.mysql.com/doc/refman/8.4/en/index-merge-optimization.html
This access method merges index scans from a single table only, not scans across multiple tables. AND key_partN = constN Any range condition over the primary key of an InnoDB table. If all columns used in the query are covered by the used indexes, ... The Index Merge access method retrieves rows with multiple range scans and merges their results into ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-init-startup-configuration.html
(The MySQL server changes its current working directory to the data directory when it begins executing.) Alternatively, you can specify an absolute path for system tablespace data files. To specify an alternate location for global temporary ...Note ... The first decisions to make about InnoDB configuration involve the configuration of data files, log files, page size, and memory buffers, which should be configured before initializing ...