Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-summary.html
Read/write transactions commit only after they have been approved by the group. Note that if two transactions are bound to conflict more often than not, then it is a good practice to start them on the same server, where they have a chance to ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-understanding-consistency-guarantees.html
This means that as soon as the incoming traffic slows down or stops, all group members have the same data content. Since the group should behave as a single entity, it is reasonable to expect that writes on the primary are instantaneously available ... In terms of distributed consistency guarantees, either in normal or failure repair operations, Group Replication has always been an eventual consistency ...
https://dev.mysql.com/doc/refman/8.4/en/hash-joins.html
A hash join is used even if any pair of joined tables does not have at least one equi-join condition, as shown here: mysql> EXPLAIN FORMAT=TREE -> SELECT * FROM t1 -> JOIN t2 ON (t1.c1 = t2.c1) -> JOIN t3 ON (t2.c1 < t3.c1)\G ...It is possible to ...
https://dev.mysql.com/doc/refman/8.4/en/hexadecimal-literals.html
Hexadecimal literal values are written using X'val' or 0xval notation, where val contains hexadecimal digits (0..9, A..F). Lettercase of the digits and of any leading X does not matter. A leading 0x is case-sensitive and cannot be written as 0X.
https://dev.mysql.com/doc/refman/8.4/en/identifier-case-sensitivity.html
If you are using MySQL on only one platform, you do not normally have to use a lower_case_table_names setting other than the default. For example, on Unix, you can have two different tables named my_table and MY_TABLE, but on Windows these two names ... In MySQL, databases correspond to directories within the data ...
https://dev.mysql.com/doc/refman/8.4/en/index.html
It may include documentation of features of MySQL versions that have not yet been released. For information about which versions have been released, see the MySQL 8.4 Release Notes. If you have any questions about the features included in your ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-introduction.html
In some cases (for example, the ROUTINE_DEFINITION column in the INFORMATION_SCHEMA ROUTINES table), users who have insufficient privileges see NULL. Some tables have different privilege requirements; for these, the requirements are mentioned in the ... INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-processlist-table.html
Like the output from the SHOW PROCESSLIST statement, the PROCESSLIST table provides information about all threads, even those belonging to other users, if you have the PROCESS privilege. Otherwise (without the PROCESS privilege), nonanonymous users ... Important INFORMATION_SCHEMA.PROCESSLIST is deprecated and subject to removal in a future MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-resource-groups-table.html
You can see information only for columns for which you have some privilege. System resource groups have a priority that ranges from -20 to 0. User resource groups have a priority that ranges from 0 to 19. The RESOURCE_GROUPS table provides access ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-schemata-table.html
The following statements are equivalent: SELECT SCHEMA_NAME AS `Database` FROM INFORMATION_SCHEMA.SCHEMATA [WHERE SCHEMA_NAME LIKE 'wild'] SHOW DATABASES [LIKE 'wild'] You see only those databases for which you have some kind of privilege, unless ...